error:table laready opened eclusively or through user interface

  • Thread starter Thread starter Mike Parmley
  • Start date Start date
M

Mike Parmley

I've spent many hours searching Microsoft's web site and
find many folks having this problem and all of them very
frustrated after spending much time without finding a
solution. I hope someone can help!

The exact error is "The table 'table name' is already
opened exclusively by another user or it is already open
through the user interface and cannot be manipulated
programmatically." This error occurs when another user
has the database and table open and I try to do the same
on my machine.

We are both working on a Win 2k machine with Access 2k SR-
3. The database is split with the program objects in a
database on drive c on each machine. In each of these
databases there is link to a table on a Novell Server
using an UNC path to link the table. I have experienced
the same result when I created a new database on the same
server with just one table (not linked). All the settings
were the same.

I've checked all the file/record lock settings and they
are set for no locks and the file is shared. I have
checked the network rights of each of us confirmed we each
have appropriate rights.

ANY SUGGESTIONS???? THANKS!
 
Back
Top