VBA, Table Linking in Access 2000 on startup

Table Linking in Access 2000 on startup

Author	Message
Greg Gerk #1 / 2	Table Linking in Access 2000 on startup I have used access 97 and the table linking module from the Northwind database to automatically detect and ask for the new table links on startup to my data base if the path has been changed. However, Now I am using Access 2000 and am having trouble performing the same function. It keeps asking me for an SQL server location which I am not using. Any ideas as to how to overcome this problem? I have tried modifying the code but it is much more complicated than the 97 version. I am just trying to do the same thing using MDB files and not ADP. Thanks Greg G.
Sat, 13 Jul 2002 03:00:00 GMT

Dev Ashis #2 / 2	Table Linking in Access 2000 on startup Are you trying to use FixAllDataAccessPages and FixPageConnection procs? These functions are for DataAccessPages only. I haven't tried this myself, but have you tried to use the old relink code? -- Dev Quote: > I have used access 97 and the table linking module from the Northwind > database to automatically detect and ask for the new table links on startup > to my data base if the path has been changed. However, Now I am using Access > 2000 and am having trouble performing the same function. It keeps asking me > for an SQL server location which I am not using. Any ideas as to how to > overcome this problem? I have tried modifying the code but it is much more > complicated than the 97 version. I am just trying to do the same thing using > MDB files and not ADP. Thanks Greg G.
Sat, 13 Jul 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]