Multiuser Problems

[Guest]

I have a database that i want to be used by multiple users at once. The
problem is that when another user tries to connect to the database i get this
message.

"The table 'MSysAccessObjects' is already opened exclusively by another
user, or it is already open through the user interface and cannot be
manipulated programmatically."

The database has been set to open in shared mode by default and whilst
testing i have also had each user open the database in shared mode, yet i
continually get this message and cant have more than 1 user connected to the
database at one time.

Does anyone know what the problem is here???? Each of the computers trying
to connect to the database do not have administrator rights (i dont know if
this makes a difference or not)

Any help would be greatly appreciated.

 

[Guest]

You need to split the database into a FE/BE configuration.
Then each user needs a seperate copy of the FE that is linked to on single
BE file ...

R. Hicks

 

[Rick B]

In order to do this, each user will need access to read, write, modify, and
delete in the folder where your database file lives. This will allow them
to create, modify, and delete the locking file (ldb) that tracks who is
using the database file.

 

[Guest]

any information on how to do this??? or any idea where i can find said
information?????

 

[Lynn Trapp]

The first thing to check is whether or not all users have full permissions
to the folder where the database is stored.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

I have checked and all users do have full permissions to the folder where the
database is stored

 

[Lynn Trapp]

2 questions:

1. Is your database split? If not do so and give each user their own copy
of the front end.
2. Have you ever implemented Access Replication on this database? If so,
you might check this website -
http://support.microsoft.com/default.aspx?scid=kb;en-us;282368

If neither of those solve your problem, then you may be suffering some kind
of corruption.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Guys thanks for your help i have finally got it working, once again cheers guys