 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2007linked tables
Hi, I need to copy a linked table to a new table but the new table should not have a link. ie all the data and settings accept for the link to another db. How can I do this? Colm hi Colm, > Hi, I need to copy a linked table to a new table but the new table > should not have a link. ie > all the data and settings accept for the link to another db. Use a table creation query, e.g. SELECT * INTO newTable FROM linkedTable mfG --> stefan <-- > hi Colm, > [quoted text clipped - 8 lines] > mfG > --> stefan <-- Hi, I dont see how that will work unless the newtable has already been created with the same design as the old table will it? Colm >> hi Colm, >> [quoted text clipped - 11 lines] > Hi, I dont see how that will work unless the newtable has already been > created with the same design as the old table will it? INSERT INTO requires an existing target table. SELECT INTO creates its own target table.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thx but although this copies all the data ok fine some of the properties dont occure in the new table eg I have a control box as a control for a lookup table and also check box fields that have been replaced by boolean 1 or 0 values. Is there no way I can copy the table and keep all the properties (apart from the link)? > >> hi Colm, > [quoted text clipped - 22 lines] > > - Show quoted text - hi Colm, > Thx but although this copies all the data ok fine some of the > properties dont occure in the new table eg I have a control box as a > control for a lookup table and also check box fields that have been > replaced by boolean 1 or 0 values. Is there no way I can copy the > table and keep all the properties (apart from the link)? Commandment 2, http://www.mvps.org/access/tencommandments.htm Try DoCmd.CopyObject. mfG --> stefan <-- Thanks but this only works the reverse way ie I could copy a table from the current db to another db but not the table from the other db to the current db. How about importing the table? Whats the vba code for that? I dont see any obvious one in docmd. Thx for the commandments - I should send this to the idiot that wrote this code:-) > hi Colm, > [quoted text clipped - 10 lines] > mfG > --> stefan <-- hi Colm, > Thanks but this only works the reverse way ie I could copy a table > from the current db to another db but not the table from the other db > to the current db. Nope, if you don't specify a database you can copy it: DoCmd.CopyObject , "TEST", acTable, "CopyTable" > Thx for the commandments - I should send this to the idiot that wrote > this code:-) Do this. Better late than never:) mfG --> stefan <-- Tx but that wont work because its a linked table and I dont want the linked table. As I say is there an import table function? Colm > hi Colm, > [quoted text clipped - 13 lines] > mfG > --> stefan <-- yeah, if you don't want to deal with linked table crap-- then move to Access Data Projects-- and keep all your DATA and QUERIES where they belong (on a secure DATABASE SERVER) Seriously File, New, Project (existing data) > Tx but that wont work because its a linked table and I dont want the > linked table. [quoted text clipped - 20 lines] > > mfG > > --> stefan <-- hi Colm, > Tx but that wont work because its a linked table and I dont want the > linked table. > > As I say is there an import table function? Yes, the import wizards uses DoCmd.TransferDatabase. mfG --> stefan <-- sorry but that wont work because it just copies the link and the whole point is that I dont want a linked table Is there an "import table" function I can use? Colm > hi Colm, > [quoted text clipped - 13 lines] > mfG > --> stefan <-- sorry but that wont work because it just copies the link and the whole point is that I dont want a linked table Is there an "import table" function I can use? Colm > hi Colm, > [quoted text clipped - 13 lines] > mfG > --> stefan <-- sorry but that wont work because it just copies the link and the whole point is that I dont want a linked table Is there an "import table" function I can use? Colm linked tables have been depecrated you should move to Access Data Projects > Hi, I need to copy a linked table to a new table but the new table > should not have a link. ie [quoted text clipped - 3 lines] > > Colm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.