Access Database with SQL 2005 linked tables

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
 
S

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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Linking tables access - sql server 2005 4
SQL Database Diagram not showing up as an access object 1
Sort date by Desc doesn't work in SQL Server 2005 2
Access 2000 ADP and SQL Server 2005 2
Access klient slow down on SQL 2005 HELP PLZ 2
Access and SQLServer Express 2005 3
SQL Connection Error with MS Access 7

Top