By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Attaching SQL Tables - Unique Key

P: n/a
I am trying to attach some SQL tables to an Access DB in code using the
docmd.TransferDatabase. I am getting a popup asking me to specify the
unique key for the attached table. I have this information, but I can't see
how to put this data into the TransferDatabase command and fully automate
this process.

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gary Floam wrote:
I am trying to attach some SQL tables to an Access DB in code using the
docmd.TransferDatabase. I am getting a popup asking me to specify the
unique key for the attached table. I have this information, but I can't see
how to put this data into the TransferDatabase command and fully automate
this process.


Make sure you have a Primary Key or Unique index on the table you are
trying to attach.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.