T Can´t Open Table

A

Ari

Hello everybody!!

I have a Button in a Main Form to add new records in the suppliers table.

When I click on this button this message appears "The talble "suppliers" is Open in exclusive mode by another user or this opening by means of the user interface and can already not be manipulated by coding" ................

any idea??

thanks!!!
 
A

Ari

I can give you this tips:

a.. This is not a shared DataBase, it is for a single user.
b.. The Tables was imported from MS SQLServer
c.. The Main Form, include some fields from the same Table which I need to open in the other Form for adding records.
I hope you can help me

Thanks!
 
P

Pat Hartman

Something in your own code is causing the lock conflict. You'll need to post the code if you want help identifying the culprit statement.
Hello everybody!!

I have a Button in a Main Form to add new records in the suppliers table.

When I click on this button this message appears "The talble "suppliers" is Open in exclusive mode by another user or this opening by means of the user interface and can already not be manipulated by coding" ...............

any idea??

thanks!!!
 
K

Ken Snell [MVP]

Make sure that the form has RecordLocking set to No Locks. If the form is
based on suppliers table, and you have recordlocking set to any type of lock
in the form's properties, you won't be able to open another form based on
the same table.

--

Ken Snell
<MS ACCESS MVP>

Hello everybody!!

I have a Button in a Main Form to add new records in the suppliers table.

When I click on this button this message appears "The talble "suppliers" is
Open in exclusive mode by another user or this opening by means of the user
interface and can already not be manipulated by coding" ...............

any idea??

thanks!!!
 
Top