R
Randy K
I'm not an MS Access programmer but do use it as a tool. One of the
users created some linked tables to SQL server using an ODBC
connection. If we close the database and reopen it we can an error
when trying to open the linked tables. We have to relink them. Is
this how it suppose to work? If so is there an easy way to relink the
tables programmatically when opening up the Access mdb?
Thanks, BTW we are using SQL Server 2000 w/ MS Access 2000
users created some linked tables to SQL server using an ODBC
connection. If we close the database and reopen it we can an error
when trying to open the linked tables. We have to relink them. Is
this how it suppose to work? If so is there an easy way to relink the
tables programmatically when opening up the Access mdb?
Thanks, BTW we are using SQL Server 2000 w/ MS Access 2000