Access Database with SQL 2005 linked tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stewart - 08 Nov 2005 20:35 GMT

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

Reply to this Message

Stewart - 08 Nov 2005 21:00 GMT

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

> Hello,
>
[quoted text clipped - 7 lines]
>
> - Stewart

Reply to this Message

Kevin3NF - 11 Nov 2005 20:47 GMT

How did you migrate the SQL Server db? In place upgrade, backup/restore,
detach/attach?

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

> 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
[quoted text clipped - 11 lines]
>>
>> - Stewart

Reply to this Message