Can MS Access 2007 support multiuser environment?

Question

There is an application which is running on several machines(say roughly on 2).This application updates an shared mdb placed on network.Both users are trying to update the shared mdb at one time but the problem is only one user is able to update mdb at one time.Another user is not able to open it.Can anyone suggest that access support multiuser environment?

edit:
There is one form TFormRoadAttrib.When it activates following function is called

procedure TFrmRoadAttrib.FormActivate(Sender: TObject);
if dmTimeDomain <> nil then
   begin
     if not (dmTimeDomain.dbTimeDomain.InTransaction) then
     begin
       dmTimeDomain.dbTimeDomain.BeginTrans;
     end;
   end;

where dbTimeDomain=TADOConnection and its value is

'Provider=Microsoft.ACE.OLEDB.12.0;
Mode=Share Deny None;
Extended Properties="";
Locale Identifier=1033;
Jet OLEDB:Registry Path="";
Jet OLEDB:Database Password="";
Jet OLEDB:Engine Type=4;
Jet OLEDB:Database Locking Mode=0;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password="";
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDB:Don't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False;
Data Source=Q:\BEL_01\BEL_GADM\ACCESS\Restrictions.mdb;
Jet OLEDB:System database=C:\Program Files\Tele Atlas\Common Files\DPT.MDW;
User ID=dbadpt;
Password=dbadpt;

When we click on Ok button following code executes

if dmTimeDomain <> nil then
 begin
      if (dmTimeDomain.dbTimeDomain.InTransaction) then
            dmTimeDomain.dbTimeDomain.CommitTrans;
     end;
end;

Kindly suggest.

Remove the delphi tag. It is not applicable or helpful to your quesion. — Steve Jorgensen
What if one of the users is using a Delphi application? There isn't enough information provided to know, but it's possible something in the Delphi data access layer might be causing the problem. Actually, now that I've read the comments below, this is precisely the case. The Delphi tag definitely belongs, but we also need the Delphi code so Delphi folks can figure out what the options are. — David-W-Fenton
Please post the Delphi code that controls the transaction. That's likely the source of the problem. — David-W-Fenton
I have updated the description field of my question Kindly have a look on that for additional info. — anshul
Connection mode defined in the connection string is "Share Deny None" while in shared mdb it is set to "share".If i am changing the mode in connection string to "ReadWrite" then error is coming. — anshul

Steve Jorgensen Steve Jorgensen · Accepted Answer · 2011-02-15T09:24:45

Access definitely supports a multi-user environment, but your permissions must be set correctly. All users must be able to create files in the directory where the database is located, and all users must have permission to modify files created in that directory by other users. There are many ways to mess that up. This is because Access uses a separate .ldb file as part of its mechanism for managing concurrent, multi-user access.

A good test is to have one user create a text file in the shared directory, and then make sure the other user can open that file, and then save a change to it.

Can MS Access 2007 support multiuser environment?

3 Answers