Dual Access to Access

[Klane]

Hi I have set up a database in the office on the network. I wanted to see if
anyone new if more than one person can open it at once, make changes and they
are saved.

We have had two people open it, make changes and sometimes they are there
when we reopen it and other times not
Help please

 

[Keith Wilby]

Hi I have set up a database in the office on the network. I wanted to see
if
anyone new if more than one person can open it at once, make changes and
they
are saved.

We have had two people open it, make changes and sometimes they are there
when we reopen it and other times not
Help please

Access is a multi-user application but you should set it up correctly. The
first step is to split the application and give each user their own copy of
the user-interface. More info here:

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.co.uk

 

[Steve]

Did you set it up as a split database with a backend on the server and give
each user a frontend? When you do this, multiple users can open the backend,
make changes to the backend and save their changes.

Steve
(e-mail address removed)

 

[Arvin Meyer MVP]

Split your database and put only the data on the server. For a discussion of
best practices see:

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm