Access 2003 Front End for SQL 2005

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...
"Stewart" <stewart@.nospam.com> wrote in message
news:%23$zL6TK5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> 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
>