Multi user database - Problems!

[Guest]

Hello all,
I want to have an access applicaion in a multi user
environment. I dont need any password protection and user differentions.

But, my database is in the Terminal Service Client. Many tables in the
database are linked from some other databases. All the queries and the user
interface(Forms) are all in the same database(file).

Currently, when a user is using the database, another user cannot.
The erroe I am getting is 'Teh database has been placed in a state by user
'Admin' on machine 'servername' that prevents it from being opened or locked.'

How do I deal with this error??!?

Thanx for any pointers guys..

Joshua.

 

[Joseph Meehan]

Hello all,
I want to have an access applicaion in a multi user
environment. I dont need any password protection and user
differentions.

But, my database is in the Terminal Service Client. Many tables in the
database are linked from some other databases. All the queries and
the user interface(Forms) are all in the same database(file).

Currently, when a user is using the database, another user cannot.
The erroe I am getting is 'Teh database has been placed in a state by
user 'Admin' on machine 'servername' that prevents it from being
opened or locked.'

How do I deal with this error??!?

Thanx for any pointers guys..

Joshua.

Step one is to consider your general database design. It sounds like
you need to split that database, but then since it is linked to other
databese(s) you should not just split this one, but rather think about the
macro (whole) thing, not the micro (just your current problem).

I suspect after considering all the needs and limitations you have, you
will find that reconfiguring the system is the right approach and will be
worth the effort. That may eliminate you problem.

Now some ideas about your specific problem. Check to see that no one is
opening that database in exclusive mode. It might be set as default on
their machine. Make sure all users have full rights to the directories
where any of the data is stored for the system. They need to have delete
rights.

Check to see if there is a YOURFILENAME.LDB file on the server in the
same directory is located after everyone has logged out. Instruct all
users to close Access before they turn off their machine.