keep primary key on import of SQL database

[xsnrg]

I use a TransferDatabase code to automate importing SQL tables into external backend Access databases...

DoCmd.TransferDatabase acImport, "ODBC Database", _
    "ODBC;DSN=eProj;UID=EProjUser;PWD=EPr0jUs3r;LANGUAGE=us_english;" _
    & "DATABASE=eProjRpt", acTable, "dbo.TaskAssignment", "dbo_TaskAssignment"

When I did the import manually, the primary key remained. Now there is no primary key... I assume ALL indexes are removed.

I need the PK for some of my other queries and actions... How do I automatically reassign these PKs to my tables?


McLean Jones
buddycenters.org
"Believing is Seeing

 

[PHV]

Take a look at the CREATE INDEX sql instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[xsnrg]

I don't know SQL outside of the basic I perform in Access VBA. Where would I find this instruction. I'm a quick learner if I have something to read.

McLean Jones
buddycenters.org
"Believing is Seeing

 

[PHV]

In the Jet SQL help file.
If you can't open it inside access, search your computer for jet*.chm files.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[xsnrg]

Any other on-line places to look. My help files are screwed up on my machine. And I did find this file in a search but still can't open it... I get this error...

McLean Jones
buddycenters.org
"Believing is Seeing