T
telethink
I have several ms access 2000 (SP3) queries that have been working for many
years in a billing system I wrote. Suddenly, they stopped working. They
display pre-existing data but will not allow the addition of new records,
empty record does not apear at end. Formerly, they allowed new records.
Nothing was changed in the database except data.
This happened at the same time we started getting odd error messages like,
"Module does not exist", "You stopped the previous process". Wording not
related to what the system was doing.
First, I tried to resolve by doing DB compact and repair. No help. I keep
copies and restored SQL source code from copies that DO work. No help.
Seems there is something wrong with DLL, EXE or other interal parts of MS
Access. Repaired, reinstalled, uninstalled and them reinstalled Office. No
help.
I'm a sr systems engineer. So, this is difficult.
Old copies of DB work. Current won't.
Tried importing objects into a new DB. No help. Still get weird unrelated
msgs.
Tried making a new UI DB w only forms, rpts, qrys, macros, modules -
imported from bad db. Then made a Data-Only DB - imported only tables from
bad db. Annoying msgs gone. Still cannot add a new record.
There has to be a fix.
years in a billing system I wrote. Suddenly, they stopped working. They
display pre-existing data but will not allow the addition of new records,
empty record does not apear at end. Formerly, they allowed new records.
Nothing was changed in the database except data.
This happened at the same time we started getting odd error messages like,
"Module does not exist", "You stopped the previous process". Wording not
related to what the system was doing.
First, I tried to resolve by doing DB compact and repair. No help. I keep
copies and restored SQL source code from copies that DO work. No help.
Seems there is something wrong with DLL, EXE or other interal parts of MS
Access. Repaired, reinstalled, uninstalled and them reinstalled Office. No
help.
I'm a sr systems engineer. So, this is difficult.
Old copies of DB work. Current won't.
Tried importing objects into a new DB. No help. Still get weird unrelated
msgs.
Tried making a new UI DB w only forms, rpts, qrys, macros, modules -
imported from bad db. Then made a Data-Only DB - imported only tables from
bad db. Annoying msgs gone. Still cannot add a new record.
There has to be a fix.