Accessing a table

[Guest]

Is there a way to access a table when it is opened on another computer. Right
now when I try to do it, it says the database has been placed in a state by
user 'Admin' on machine 'Dispatch' that prevents from being opened or locked.
The Dispatch computer only has one Administrator user account that everyone
uses. All of the other cumputers have user accounts set up on them.

 

[Tom van Stiphout]

On Sat, 17 Nov 2007 11:04:00 -0800, mustangric2001

Yes, this is certainly possible. However you need to play by the
rules, and they say that tables go in a back-end database on the
server, and clients have all other objects, and linked tables.

You can research your error message at microsoft.com, for example
http://support.microsoft.com/kb/248967

-Tom.