Access-SQL link

  • Thread starter Thread starter JIM.H.
  • Start date Start date
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.
 
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
 
Back
Top