losthorizon
Technical User
Please excuse the duplicate posting; this having been posted under "Relationships" before...
At first, we thought our problem was a "relationship" problem, but that now all seems okay, after doing some more checking.
We were having a problem with '#deleted' showing up in bound controls, though we didn't have this problem with 'Access 97,' using the exact same code. (The code does, in fact, delete a record from the one side of a '1 to many relationship.' The controls are bound to the table on the 'many' side.
The two tables have 'referential integrity' set, 'cascade delete,' and they are related by 'autonumber primary to foreign').
We eventually solved that problem by using a series of me.requery's, dbengine.idle's and doevents. (According to another newsgroup posting, perhaps another method would have been to NOT depend on the autonumber field, but, instead, create a "next Id" table).
But the main issue, and our root problem, STILL goes unresolved:
Every time we attempted to save the database while the
code was running, we received a "You do not have exclusive
access to this database and your changes will not be saved"
message. It pops up, and the #deleted appears in the boxes.
If we type: ? dbengine.systemdb, in the 'immediate' window,
'System.mdb' displays.
If, on the other hand, the design changes were saved without
any errors with the code running, ?dbengine.systemdb
displays: "c:\program files\common files\system\system.mdw.
The #deleted does NOT appear in the boxes -- & everything
works fine!
We have both 'Access 97' and 'Access 2000' on our machines. We already downloaded all the latest patches and updates from the 'Windows Update' site.
The 'Win 2000' Access program is intended to have
NO security, of any sort. From what the 'immediate' window says, I have a strong suspicion that sometimes the
program reads the 'Access 97' workgroup file (and fails!),
but also sometimes reads the Win 2000 workgroup file
(and then succeeds!)
Are the 'Access 97' and 'Access 2000 .mdw' files located in their correct locations?
How can we make the 'Win 2000' Access program always read
the Win 2000 .mdw file, ignoring the Access 97 files?
i. e. (C:\Program Files\Common Files\SYSTEM\system.mdw?)
Could it be a registry problem? Thanks in advance.
At first, we thought our problem was a "relationship" problem, but that now all seems okay, after doing some more checking.
We were having a problem with '#deleted' showing up in bound controls, though we didn't have this problem with 'Access 97,' using the exact same code. (The code does, in fact, delete a record from the one side of a '1 to many relationship.' The controls are bound to the table on the 'many' side.
The two tables have 'referential integrity' set, 'cascade delete,' and they are related by 'autonumber primary to foreign').
We eventually solved that problem by using a series of me.requery's, dbengine.idle's and doevents. (According to another newsgroup posting, perhaps another method would have been to NOT depend on the autonumber field, but, instead, create a "next Id" table).
But the main issue, and our root problem, STILL goes unresolved:
Every time we attempted to save the database while the
code was running, we received a "You do not have exclusive
access to this database and your changes will not be saved"
message. It pops up, and the #deleted appears in the boxes.
If we type: ? dbengine.systemdb, in the 'immediate' window,
'System.mdb' displays.
If, on the other hand, the design changes were saved without
any errors with the code running, ?dbengine.systemdb
displays: "c:\program files\common files\system\system.mdw.
The #deleted does NOT appear in the boxes -- & everything
works fine!
We have both 'Access 97' and 'Access 2000' on our machines. We already downloaded all the latest patches and updates from the 'Windows Update' site.
The 'Win 2000' Access program is intended to have
NO security, of any sort. From what the 'immediate' window says, I have a strong suspicion that sometimes the
program reads the 'Access 97' workgroup file (and fails!),
but also sometimes reads the Win 2000 workgroup file
(and then succeeds!)
Are the 'Access 97' and 'Access 2000 .mdw' files located in their correct locations?
How can we make the 'Win 2000' Access program always read
the Win 2000 .mdw file, ignoring the Access 97 files?
i. e. (C:\Program Files\Common Files\SYSTEM\system.mdw?)
Could it be a registry problem? Thanks in advance.
