How To Conncet Access Be Tables Using Vb Code

[Ashfaque]

Hi,

I need to know is there any specific code that would establish link for tables from Access BE?

I know it using Get External Data...Link Tables. Even though they are in other db but it leads to increase heavy size of main db. I want no table objects (except system tables) to be displayed in main db and only link tables once main db activates and should no table remain exists in FE after closing.


There should be some way to establish connectivity of tables from Access BE at the time of opening main db . This will help a ton to reduce the size of main db and its zip file can be copied even in a 1.44 mb floppy.

I heard something about shell but exactly I don't know how to do it.

Any idea....

With kind regards,
Ashfaque

 

[erroldou]

If you have already linked your Main db to tables in another db, then you should regularly use the 'Compact and Repair' facility. This will greatly reduce the size of you Main db. Do this before backing up and you might well fit it onto a floppy...

From the 'Tools' menu, choose 'Database utilities', then choose 'Compact and Repair Database'.

 

[Ashfaque]

Thanks for the reply.

But this is not what I am looking for. Compact and Repair is to compact the size of the db if your db contains linked / local tables. My first question was I dont want any of my customized tables to be appreared in db. Anyhow thanks.

Any other ideas..?

With kind regards,
Ashfaque

 

[Ashfaque]

Hi Gents,

Waiting for the reply...

With kind regards,
Ashfaque

 

[Friday]

Read this post. Pat Hartman's suggestion may work for you.