G
Guest
I have a database that essentially consists of one table and 3 forms that are
linked to each other with buttons (I couldn't fit all of the questions on one
page, so I created 3 pages, with command buttons to switch back and forth
from one to the others.)I am the ONLY user (it is not even on a network -
it's on my harddrive.)
When I make changes on more than one form (for the same record), I get a
message that says another user had made changest to the record, and do I want
to save my changes and overwrite the other user's changes, or drop my
changes? If I save the changes, they do not always take, and sometimes I get
gibberish (like corrupt data) in the field. Or I will get a #Error in the
field. Then the entire record is no good, and I get a Jet-Data Base Engine
ODBC Driver error message. The record is then un-usable (the system locks up
with this error message when I try to access it.)
HELP!
linked to each other with buttons (I couldn't fit all of the questions on one
page, so I created 3 pages, with command buttons to switch back and forth
from one to the others.)I am the ONLY user (it is not even on a network -
it's on my harddrive.)
When I make changes on more than one form (for the same record), I get a
message that says another user had made changest to the record, and do I want
to save my changes and overwrite the other user's changes, or drop my
changes? If I save the changes, they do not always take, and sometimes I get
gibberish (like corrupt data) in the field. Or I will get a #Error in the
field. Then the entire record is no good, and I get a Jet-Data Base Engine
ODBC Driver error message. The record is then un-usable (the system locks up
with this error message when I try to access it.)
HELP!