Access Database with SQL 2005 linked tables

  • Thread starter Thread starter Stewart
  • Start date Start date
S

Stewart

Hello,

I have a Microsoft Access front-end for a SQL 2005 database. The Access
front-end was in SQL 2000 and worked perfectly. When I migrated it to 2005,
I relinked the database and I can view the information, but I am unable to
add anything to the database. All of the Add Record functions have been
disabled.

Does anyone know why this is happening?

- Stewart
 
Nevermind, I figured it out. When I did the replication, SQL 2005 did not
copy over the Primary Key and Foreign Key Relationships. I manually
recreated them and it all woks fine....
 
Back
Top