R
roadsign71
Hi, I have a database that has a SQL back end and an Access front end. In
part of the database, you can sign up clients to events. There is no problem
intially saving a record of this, but if you try and go back in and change
the status of certain items like wheter they've paid, or if they're
confirmed, then it won't save the chages. The error reads:
This record has been changed by another user since you started editing it.
If you save the recor, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
The problem is that the 'Save Record' button is greyed out and you can only
'Copy to Clipboard' or 'Drop Changes'... neither of which saves the record.
I am the only person with the database open, so there's no way it could be
being changed by another user.
Also (this may be a total separate problem), but when I try and delete
records from the front end, I get this error:
The Microsoft Jet databse engine stopped the process because you and another
user are attempting to change the same data at the same time.
Once again, this makes no sense because I am the only user with the database
open. The only way I can delete records is to go in through the back end and
delete them. Please let me know if you have any ideas, or if you need more
inforation to help figure this out.
Thanks,
Andrew
part of the database, you can sign up clients to events. There is no problem
intially saving a record of this, but if you try and go back in and change
the status of certain items like wheter they've paid, or if they're
confirmed, then it won't save the chages. The error reads:
This record has been changed by another user since you started editing it.
If you save the recor, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
The problem is that the 'Save Record' button is greyed out and you can only
'Copy to Clipboard' or 'Drop Changes'... neither of which saves the record.
I am the only person with the database open, so there's no way it could be
being changed by another user.
Also (this may be a total separate problem), but when I try and delete
records from the front end, I get this error:
The Microsoft Jet databse engine stopped the process because you and another
user are attempting to change the same data at the same time.
Once again, this makes no sense because I am the only user with the database
open. The only way I can delete records is to go in through the back end and
delete them. Please let me know if you have any ideas, or if you need more
inforation to help figure this out.
Thanks,
Andrew