record locks.

P

PaulG

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
 
G

GreySky

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
 
P

PaulG

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.
 
Top