Access and SQL Enterprise

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

Hi there, need some help (dont we all...lol)

I have an Access 2002 database that has 2 linked tables
(using an ODBC SQL driver) to tables residing on a SQL
server running SQL Enterprise v8.

I can open these linked tables and view data, but cant
edit, or insert new records. However, if I use the
Management Console, I am able to edit, or insert new
records.

I can also use Excel and an ADO connection to insert or
delete records to these tables, however, I dont wish to
use Excel as an ongoing tool. I would like to use Access.

What do I need to do ?

Thanks in anticipation.
 
You need the PrimaryKey Field in the SQL Server Table to be able to edit the
data in the same Table linked via ODBC in Access.

Use EM to check whether the SQL Server Tables have PK Fields.
 
Back
Top