Re: Access 2003 Front End for SQL 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxxxxx> wrote in message
news:%23$zL6TK5FHA.3880@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages