I developed an Access Database some time ago which links to a number of tables in an SQL database as a series of linked tables. After linking to each table my Access Database then runs a series of Data Definition Queries, such as:
CREATE UNIQUE INDEX _uniqueindex ON ASSET(CLASS_ID ASC, ASSET_ID ASC)
This has worked well for years, but when I install my database now, the first time I link to the SQL database it works fine, but when I need to re-link to the SQL database to access a different set of tables, I now get an error number 3285 - Invalid Index Defintion.
Has anyone got a suggestion on the cause/solution.
CREATE UNIQUE INDEX _uniqueindex ON ASSET(CLASS_ID ASC, ASSET_ID ASC)
This has worked well for years, but when I install my database now, the first time I link to the SQL database it works fine, but when I need to re-link to the SQL database to access a different set of tables, I now get an error number 3285 - Invalid Index Defintion.
Has anyone got a suggestion on the cause/solution.