More that one user at a time

[technixrs]

Is there a way to have more that one person connected to the database where they can edit it in Access 2003? If so what setting do i change because at the moment when i open the database from a second computer i only have read only access

 

[Ricky1946]

Technikrs,
Have you tried splitting your database and putting the tables on a central drive.When you have done this you have to link the tables to both 'front-end' applications. Providing you are not actually trying to edit the very same record you should not have a problem.
Let me know.
Ian

"To say 'thankyou' encourages others."

 

[BobStubbs]

Access supports multi-user databases within a single .mdb file, so you don't need to split your database into front end and back end unless you encounter performance issues due to database size / number of users etc.

To configure an Access 2000 or later database in this way:

-- Make sure the .mdb file is held on a shared drive which all users can access.
-- Implement user and group security, to make sure there is only one Administrator with rights to open the database exclusively. This is not essential, but from my experience is definitely 'highly recommended'
-- Open the database as Administrator, and choose the Tools ... Options menu option.
-- Click the [Advanced] tab
-- Set these options:

Default open mode = Shared
Default record locking = Edited records
Tick the 'Open databases using record-level locking' check box.

I use this configuration on a 25 Mb database used by up to six concurrent users, with no problems.

I hope that this helps.


Bob Stubbs