J
Jeff Clark
are you logging in as someone else and getting the wring copy?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
ante zoric
Jeff Clark said:are you logging in as someone else and getting the wring copy?
There is no copy of database, there is no loggin when you enter Windows or
database...
A
ante zoric
I have a BIG problem and it happens twice this week. All the records that
were added in the morning in two tables dissapear when computer is turned on
in the evening ?!?!? I can't believe ... These two tables have no relations,
i don't use DELETE statement anywhere in the code. Application is working on
single computer, there is no network environment. Records were inserted in
the tables 100% ... What's going on ? Database is Microsoft Access 2000, JET
4.0, ADO 2.7 +Visual Basic 6.0 code. Records were inserted with INSERT INTO
statement. I am using BeginTrans and CommitTrans statements.
MVPs please help !!!
Thanx
were added in the morning in two tables dissapear when computer is turned on
in the evening ?!?!? I can't believe ... These two tables have no relations,
i don't use DELETE statement anywhere in the code. Application is working on
single computer, there is no network environment. Records were inserted in
the tables 100% ... What's going on ? Database is Microsoft Access 2000, JET
4.0, ADO 2.7 +Visual Basic 6.0 code. Records were inserted with INSERT INTO
statement. I am using BeginTrans and CommitTrans statements.
MVPs please help !!!
Thanx
S
Sean
Please excuse me for thinking that maybe the records are NOT being inserted
for some reason.
I would make sure, by looking in the table, that the records are , in
fact, being inserted. use the eyes here...
Maybe even put a foreign key on so that you know that no other process is
deleting them.
for some reason.
I would make sure, by looking in the table, that the records are , in
fact, being inserted. use the eyes here...
Maybe even put a foreign key on so that you know that no other process is
deleting them.
B
Bruce M. Thompson
I have a BIG problem and it happens twice this week. All the records that
Take a record count prior to inserting your records (you can simply open the
table and note the number of records displayed at the bottom of the data sheet),
then take another record count after. If your record count appears properly
increased after the insert and you are looking for your new records at the "end
of a table", that might be where you are having your problem. New records will
not always appear at the "end of a table" as there really isn't an end or a
beginning. You might want to insert an autonumber field to incrementally number
your records - that way you can sort by that field to locate those that were
last entered. If your record count has not increased after the insert, your
records were not appended to the table. If your record count is increasing after
the insert, but has dropped again the next time you open the database, the only
explanation I could offer is that the records have been deleted.
were added in the morning in two tables dissapear when computer is turned on
in the evening ?!?!? I can't believe ... These two tables have no relations,
i don't use DELETE statement anywhere in the code. Application is working on
single computer, there is no network environment. Records were inserted in
the tables 100% ... What's going on ? Database is Microsoft Access 2000, JET
4.0, ADO 2.7 +Visual Basic 6.0 code. Records were inserted with INSERT INTO
statement. I am using BeginTrans and CommitTrans statements.
Take a record count prior to inserting your records (you can simply open the
table and note the number of records displayed at the bottom of the data sheet),
then take another record count after. If your record count appears properly
increased after the insert and you are looking for your new records at the "end
of a table", that might be where you are having your problem. New records will
not always appear at the "end of a table" as there really isn't an end or a
beginning. You might want to insert an autonumber field to incrementally number
your records - that way you can sort by that field to locate those that were
last entered. If your record count has not increased after the insert, your
records were not appended to the table. If your record count is increasing after
the insert, but has dropped again the next time you open the database, the only
explanation I could offer is that the records have been deleted.
A
ante zoric
I think the records were there because you can see the records in the
datagrid when you add new one. And table is small, I can't miss him. And
when the record is inserted application executes function PrintRecord(ID as
long) where ID is autonumber of the record. Application seek record in the
table and then print it, so record was in the table ! I read something about
the flushing transaction. Maybe RAM is the problem ? Or hard disc ? Or I am
insane ?! Thanx everybody, if I ever solve this mistery i let you know ...
datagrid when you add new one. And table is small, I can't miss him. And
when the record is inserted application executes function PrintRecord(ID as
long) where ID is autonumber of the record. Application seek record in the
table and then print it, so record was in the table ! I read something about
the flushing transaction. Maybe RAM is the problem ? Or hard disc ? Or I am
insane ?! Thanx everybody, if I ever solve this mistery i let you know ...