linked tables

  • Thread starter Thread starter colmkav
  • Start date Start date
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
 
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 <--
 
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
 
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.
 
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,
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 <--
 
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,
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 <--
 
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
 
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
 
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
 
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
 
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)
 
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 <--
 
Back
Top