INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I've learned more from your forums in 3 days than 3 months at school and on the job combined..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Project (ADP) Forum

Database Copy Loses Primary Keys

Read More Threads Like This One

Baesucks (Programmer)

12 May 11 15:54

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?

lameid (Programmer)

19 May 11 20:59

My question would be if in SSMS you see the primary keys or not?

If not, it is a SQL/Methoodology issue.

If you do, I would start with a blank ADP file, set the connection to pick up the tables. Hopefully you will see the keys then and subsequently import all the other objects from the original ADP file.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Access Project (ADP)