Re: Problems networking Access

Default open mode - Exclusive

The above should be set to shared...


The database is also split, the workstation has a frontend which is
linked to the backend on the server.

Good, that is the recommended setup.


When I enter records into the database from the workstation, they do
not appear on the server.

How are you testing the above? A form should be loaded to one record...you
exit the form (and thus save the record). You are then back to some type of
prompt the user for the next record to work on. If you just open form to a
large table of records, that form have to be told to re-load the records
(so that is can see other reocrds added by other people).

A good approach is to build some type of search form, such as

http://www.members.shaw.ca/AlbertKallal/Search/index.html

So, ask/display the records you are searching for. If you do this, then you
eliminate the issue/problem of having to re-load up a form with a LARGE
number of records in the process, and your appcation will performance much
better.

You should not have to exit the application, but you certainly have to close
the form, or issue a requery to that form to see new records added. As
mentioned, if you change your design to ask for what records to view first,
then others peoples work will be available if you open up a form to these
newly added records....

And, if you are just testing by opening the back end direclty, you will have
to close, and then re-open a table to see the newly added records.

Of course, users would never see, or edit a table direct..but just a like
form, you do have to close, and then re-open the form to see records added
by other people.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.

Relevant Pages

  • Slow database
    ... Server is Win2K Server ... Workstation is XP Pro and or 2K Pro ... So today I thought I would rebuild a database ...
    (microsoft.public.access.externaldata)
  • Re: VB6 App On MS Server
    ... LAN with 6 concurrent users. ... The server hosts both the Access Database and 3 executables that make ... Generally speaking all of the workstation load "Program A" from the ...
    (microsoft.public.vb.general.discussion)
  • Re: VB6 App On MS Server
    ... LAN with 6 concurrent users. ... The server hosts both the Access Database and 3 executables that make ... Generally speaking all of the workstation load "Program A" from the ...
    (microsoft.public.vb.general.discussion)
  • Re: Slow responce from Network
    ... are you going after SQL Server or Oracle or something else? ... oriented database, it is a file server database. ... workstation in order to locate the data you want. ... > accessing only data from the network. ...
    (microsoft.public.access.forms)
  • Inventory search form
    ... the start of a Database Results region. ... unable to display database content. ... server that supports Active Server Pages."); ... >>create the search form. ...
    (microsoft.public.frontpage.programming)