Access-SQL link

J

JIM.H.

Hello,
I am using trusted windows user connection to SQL server.
I created an ODBC link from Access to SQL server. I am
able to modify data in tables through SQL Enterprise
Manager however I am not able to modify them in Access.
What is missing?
Thanks,
Jim.
 
A

Arvin Meyer

JIM.H. said:
Hello,
I am using trusted windows user connection to SQL server.
I created an ODBC link from Access to SQL server. I am
able to modify data in tables through SQL Enterprise
Manager however I am not able to modify them in Access.
What is missing?
Click to expand...

Probably a primary key. You need to make sure that the primary key is
available in the Access link.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top