Auto Update Linked Tables 1

[jt643]

Is there a way I can autoupdate or refresh my linked tables via VB or within Access so my users don't have to go through the 'Linked Table Manager' each time?

 

[lupins46]

You don't normally have to do this unless the location has changed.

 

[alvechurchdata]

You can use DAO to link the tables as the application starts. I have a sub which links in a named table from a named database. Here's the core of it:

Set tdfLinked = gdbs.CreateTableDef(strTable)
tdfLinked.Connect = ";DATABASE=" & strDatabaseName
tdfLinked.SourceTableName = strTable
gdbs.TableDefs.Append tdfLinked

gdbs is a public holding the current database.

There's a similar sub which calls gdbs.TableDefs.Delete to unlink the tables before they are relinked.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[jt643]

Perfect thanks to both of you!