G
Guest
Hello again,
back last Thursday I made a post about and Access 2k database the will
periodically take a record and insert "#Delete" into each filed. I appreciate
the posts I got on this and tried all suggestions and read each article, and
followed the suggestions there as well. I repair and compact the db daily, I
have created a new db and imported the data into the new db. I have rebuilt
the data several times. I have checked all permissions for all users and
everyone has the same permissions and no one can open the database
exclusively. Yet at least twice a day I get the "#Deleted" record thing. Some
times it will happen after a person prints the work sheet and sometimes in
the middle of a entering a record, they need to look something up then come
back to the record they see the data but if you look at the record from
another machine or directly in the table you see the "#Delete". Does the size
of the table have a effect on it's preformance? example a table has 40 fields
would it work better to have 2 table of 20 fields or 4 table of 10 fields, or
does this not matter. Hope this makes since. I need help on this problem as I
am not getting much sleep having to rework this db every night. One more bit
of info the db is 1.4GB. Thank you in advance.
jmillerwv
back last Thursday I made a post about and Access 2k database the will
periodically take a record and insert "#Delete" into each filed. I appreciate
the posts I got on this and tried all suggestions and read each article, and
followed the suggestions there as well. I repair and compact the db daily, I
have created a new db and imported the data into the new db. I have rebuilt
the data several times. I have checked all permissions for all users and
everyone has the same permissions and no one can open the database
exclusively. Yet at least twice a day I get the "#Deleted" record thing. Some
times it will happen after a person prints the work sheet and sometimes in
the middle of a entering a record, they need to look something up then come
back to the record they see the data but if you look at the record from
another machine or directly in the table you see the "#Delete". Does the size
of the table have a effect on it's preformance? example a table has 40 fields
would it work better to have 2 table of 20 fields or 4 table of 10 fields, or
does this not matter. Hope this makes since. I need help on this problem as I
am not getting much sleep having to rework this db every night. One more bit
of info the db is 1.4GB. Thank you in advance.
jmillerwv