I have an Access ADP that works well with a SQL Server database. I want to leave that ADP and the associated SQL Server database as is, but make a copy of both the database and the ADP that I can modify to make a slightly different application.
I used SQL Server Management Studio to make the copy of the SQL database to another name, then copied my ADP to another name, modified the database server connection in the new ADP. It is seeing the correct database, but the new copy does not contain the primary keys on any of the tables (making it so I can't update the data in the tables from the ADP).
Is there a way to copy the database & ADP so that the primary keys are in place in the copy as they were in the original?
As I'm writing this, I see that the problem was in copying the SQL Server database, not really the ADP file. I should probably post the question in SQL forum, but perhaps someone can help me here. Any suggestions?
I used SQL Server Management Studio to make the copy of the SQL database to another name, then copied my ADP to another name, modified the database server connection in the new ADP. It is seeing the correct database, but the new copy does not contain the primary keys on any of the tables (making it so I can't update the data in the tables from the ADP).
Is there a way to copy the database & ADP so that the primary keys are in place in the copy as they were in the original?
As I'm writing this, I see that the problem was in copying the SQL Server database, not really the ADP file. I should probably post the question in SQL forum, but perhaps someone can help me here. Any suggestions?