linked tables

C

colmkav

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
 
S

Stefan Hoffmann

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.
Click to expand...
Use a table creation query, e.g.

SELECT * INTO newTable FROM linkedTable


mfG
--> stefan <--
 
C

colmkav

hi Colm,


Use a table creation query, e.g.

SELECT * INTO newTable FROM linkedTable

mfG
--> stefan <--
Click to expand...

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
 
R

Rick Brandt

colmkav said:
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?
Click to expand...

INSERT INTO requires an existing target table.

SELECT INTO creates its own target table.
 
C

colmkav

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)?
 
S

Stefan Hoffmann

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)?
Click to expand...
Commandment 2, http://www.mvps.org/access/tencommandments.htm

Try DoCmd.CopyObject.


mfG
--> stefan <--
 
C

colmkav

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:)
 
S

Stefan Hoffmann

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.
Click to expand...
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:)
Click to expand...
Do this. Better late than never:)


mfG
--> stefan <--
 
C

colmkav

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
 
C

colmkav

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
 
C

colmkav

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
 
C

colmkav

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
 
A

Aaron Kempf

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)
 
S

Stefan Hoffmann

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?
Click to expand...
Yes, the import wizards uses DoCmd.TransferDatabase.


mfG
--> stefan <--
 
Top