Link to home
Create AccountLog in
Avatar of brightfarm
brightfarm

asked on

can not add new record to database table

My group has a SQL Server database with an Access ADP (2003) as the front-end. One of the tables got "accidently" deleted and I was able to import the data from another database that has similar tables. The table that was deleted had a primary key and the table that I imported did not. I assume that the reason that I am unable to add new records to the table is because the table does not have a primary key. When I try to add a primary key to the table, I get a message that states that the version of Access that was used originally is not compatable with the version of SQL Server 2005. We recently upgraded our databases from SQL Server 2000 to SQl Server 2005. Is there a way to correct this without rebuilding the front-end with a more recent version of Access? I have SQL Server 2005 on my machine but my skill level with the application is as a beginner. Can I add a primary key with the SQL Server application instead of attempting to do it throught the ADP? Any help would be appreciated.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account