I’ve developed an Access 2003 app with linked tables. It’s been deployed with Access RunTime.
One of the linked tables is a “Version” table containing a version number for the data. In the program, there’s a global variable containing a version number for the program structure. At startup, the logic compares the two version numbers to make sure they’re the same. I was hoping that from this logic I could programmatically alter tables (specifically, via SQL, to add new columns), then update the data’s version number in the Version table. However, an Access error message says that’s it’s not possible to alter linked tables.
Can anyone suggest a generic way to program this in VBA?
One of the linked tables is a “Version” table containing a version number for the data. In the program, there’s a global variable containing a version number for the program structure. At startup, the logic compares the two version numbers to make sure they’re the same. I was hoping that from this logic I could programmatically alter tables (specifically, via SQL, to add new columns), then update the data’s version number in the Version table. However, an Access error message says that’s it’s not possible to alter linked tables.
Can anyone suggest a generic way to program this in VBA?
