linked tables

[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

 

[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.

Use a table creation query, e.g.

SELECT * INTO newTable FROM linkedTable


mfG
--> stefan <--

 

[colmkav]

hi Colm,


Use a table creation query, e.g.

SELECT * INTO newTable FROM linkedTable

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

 

[Rick Brandt]

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.

 

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

 

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

Commandment 2, http://www.mvps.org/access/tencommandments.htm

Try DoCmd.CopyObject.


mfG
--> stefan <--

 

[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

 

[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.

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

 

[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

 

[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

 

[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

 

[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

 

[Aaron Kempf]

linked tables have been depecrated

you should move to Access Data Projects

 

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

 

[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?

Yes, the import wizards uses DoCmd.TransferDatabase.


mfG
--> stefan <--