I am working on a project that involves access and sql server
i conncted my access project to my data base by using odbc connection.
now i can read data from my tables, but when i'm trying to insert data or delete it i get an error:
"can't delete 1 record(s) in the delete query due to key violations and 0 record(s) due to lock violations"
(when i tried to delete a raw)
now if i will run the query while the table is open it will be executed
i don't really understand the problem
is it cous i have some tables that are connected to each other? do i need to open connection to all the tables? and how can i do that?
please help
i conncted my access project to my data base by using odbc connection.
now i can read data from my tables, but when i'm trying to insert data or delete it i get an error:
"can't delete 1 record(s) in the delete query due to key violations and 0 record(s) due to lock violations"
(when i tried to delete a raw)
now if i will run the query while the table is open it will be executed
i don't really understand the problem
is it cous i have some tables that are connected to each other? do i need to open connection to all the tables? and how can i do that?
please help