Updating Linked Tables

[RobS23]

I have several SQL views linked in an Access 2000 mdb (not data project) for Users to 'Play' with. Updating the link seems to be a very confusing process for them, so can anyone help me with some code to update the link as an autoexec?

I know how to use the TableDef to create links but: 1. This is old hat. and 2. It asks the user to select a Primary Key field - again throwing them in to fits of confusion.


Any help folks!?!?

 

[LonnieJohnson]

MS Access has a RefreshLink Method and an example to go with it. Go to help and type RefreshLink.

ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV