Linking certain tables from back end database through VBA

[tobesurveyor via AccessMonster.com]

Hello-

I found my answer once when I was beginning my application design, but since
then I have never been able to put my hands on it again and was hoping for
some help.

I have a FE(local) and a BE(On server). At any given time in the FE I want
to link to only specific tables on the BE as decided by which button the user
clicks on the startup form of the FE. A table in the FE will have the path
to the BE and for now want to hard code which tables to link to.

The ideal situation would be to link to those certain tables when the button
is clicked, and then when the user closes out that portion of the FE and
returns to the startup form those linked tables are deleted out of the FE.

Any help would be greatly appreciated.

Thanks,
Chris F.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "LinkTables.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

This is certainly going to slow down a user and is a most unusual request;
but, here is the basic syntax to link to a table:


tdf.Connect = ";database=" & Me.datapath
tdf.RefreshLink

tdf is a table definition as
Currentdb.Tabledefs("ATableName")

datapath is the full path to the back end

You can determine whether a table is lined or not with this:
If Len(tdf.Connect) > 0 Then
' Its a linked table. Re-link

To delete a link, you use the DeleteObject method. For linked tables, it
does not delete the table in the back end, just the link to it:

DoCmd.DeleteObject acTable, tdf.Name