Unlink tables in access 2000 1

[rohini21]

Hi All,

Can some one help mewith unlinking tbales in access 2000. I hav efew linked tables to external source. How can I unlink them?

Cheers
Vivek

 

[EvilCabal]

Hey,
to remove the link either delete the tables from the database (the one with the linked tables, not the source table of course). Or, you can do it through VBA by setting to connect property to "".

Dim tblLinked As TableDef
Set tblLinked = CurrentDb.TableDefs(YourTable)
tblLinked.Connect = ""

 

[Junior1544]

if it's a one time thing, Click on the table, and press the delete key...

if you want to do it in code, I'm not sure of the delete code off hand, but I'm sure it's not hard...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[rohini21]

Thanks,

Where can I put this code to get executed so that my tables are unlinked. One more thinr. I am facing another problem I am unable to create a replica if I make some changes in the design of the tables.

 

[rabtip]

I am running a frontend on several PC's and backend on my server I need to add a few new fields into my table
When I try and do this I get a message"table orders is a linked table with some properties that cannot be modified"
Can anyone please advise I am new to Access so be gentle

 

[earthandfire]

rabtip I've replied to your separate post