record locks.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a table from a Query using two different tables,
linking them with a primary key.

When I try to make the table Access tells me it stopped the process because
me and another user are attemptimg to change data at the same time. I am the
only one that usese this database. Can anyone tell me what I need to do to
make the new table.

P
 
Odd error message. I'm only responding because no one else has taken a stab
yet. By chance, are these two tables linked in from SQL Server via ODBC, and
have bit (boolean) fields? If so, perhaps you have some nulls in those bit
fields that the ODBC driver converts to 0, only for the engine to then think
someone else changed a record.

No idea otherwise...

David Atkins, MCP
 
I think you are on the right track. I suspected something like this. Months
ago myIT department did some prep work to convert the database to the SQL
server. I am not really sure what that was, but I will find out and see if
there is anything I can undo. Thanks for the response.
 
I found out how to unlink the table from the SQL server and it worked

thanks again

P
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Same record/Primary key in multiple tables 0
Query design 0
How to keep records straight 15
Access Access Record Order 0
Make table with AutoNumber fields 4
Using ID field to select linked table record 2
Linked SQL Tables don't report Cascading Updates and Deletes 2

Back
Top