Change path in MSysObjects

  • Thread starter Thread starter Glenn
  • Start date Start date
You don't. You shouldn't try to change the contents of the system tables
through SQL.

Instead, use DAO to change the Connect property of the TableDef or QueryDef
objects in question. (I believe there are analogous ways to make the same
changes through ADOX)
 
-----Original Message-----
You don't. You shouldn't try to change the contents of the system tables
through SQL.

Instead, use DAO to change the Connect property of the TableDef or QueryDef
objects in question. (I believe there are analogous ways to make the same
changes through ADOX)
Click to expand...

Thank you for the reply but the case is as follows :
I have MDB file that have table links to the other MDB
files.
I want to create a package for these all files into CD/DVD
disc so any user could access and use this
file/application. But the table links "path" is fixed to
the actual directory path where the linked table reside.
How can I handle this ?
Thank you.
 
Glenn said:
Thank you for the reply but the case is as follows :
I have MDB file that have table links to the other MDB
files.
I want to create a package for these all files into CD/DVD
disc so any user could access and use this
file/application. But the table links "path" is fixed to
the actual directory path where the linked table reside.
How can I handle this ?
Thank you.
Click to expand...

As I said, use DAO to change the Connect property of the TableDef or
QueryDef objects.

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" for one possible approach.
 
Back
Top