G
Guest
Does anyone know if/how/when object IDs (from MSysObjects) change in MS
Access? In a table in my database, I reference Form and Report objects using
their object IDs, but I have noticed that the IDs seem to randomly change.
The database is not replicated and the forms have not been dropped and
recreated. I have not been able to reproduce this behavior by:
- Renaming the object;
- Modifying the object;
- Modifying multiple objects;
- Compacting and Repairing the database;
- Copying the DB to a new name.
Referencing the object by ID as opposed to name is preferable for all the
normal reasons. Any ideas?
Access? In a table in my database, I reference Form and Report objects using
their object IDs, but I have noticed that the IDs seem to randomly change.
The database is not replicated and the forms have not been dropped and
recreated. I have not been able to reproduce this behavior by:
- Renaming the object;
- Modifying the object;
- Modifying multiple objects;
- Compacting and Repairing the database;
- Copying the DB to a new name.
Referencing the object by ID as opposed to name is preferable for all the
normal reasons. Any ideas?