I recently switched 2 data table to BE. Prior to doing this, I was issuing the following
CurrentDb.Execute "ALTER TABLE tablename ALTER COLUMN Sequence Counter (1,1)"
Which worked perfectly fine, but after making the switch to BE my code became
SET appAccess = OpenCurrentDb("C:\ ...." , FALSE)
Msgbox Err.Number - returns 0
appAccess.RUN "Altercol" tablename
In the BE DB, I placed the CurrentDb.Execute "ALTER....." statement in a MODULE, but I get a runtime error 438 on appAccess.RUN.
1. Does appAccess become my current DB?
2 Is this acceptable to alter a linked table?
3 What would be the proper syntax to perform the ALTER? Is it merely writing an SQL statement and them executing that stateement?