Join tables ODBC

  • Thread starter Thread starter Orlik
  • Start date Start date
O

Orlik

I have 2 tables in a SQL server and I can join them and view all data but I
cant update/add records.

I have both pri.keys - any one hawing and idea....
 
Orlik

If the data is stored in SQL-Server, you (your ODBC DSN) will need to have
permissions in SQL-Server.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff

If I remove one of the tables (no join) I can write/add records.

It is a big problem because every thing with the Access database, but not
after I changed the database to MSSQL with ODBC.

It is just a simpel Sub_form and the query gives me all the trouble...

thanks a lot for answering...
 
Back
Top