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

I'd wager good money that it's your network. There's probably a bad NIC
(network interface card), router, switch, hub, computer, or even wiring
causing bad or malformed packets. It doesn't even have to be a computer using
the database. Get someone to run a sniffer to see if they can spot a problem.

Access could be used as a network stress-test tool. If often finds problems
which other programs seldom notice.

Oh! Hopefully no one is using the database over a wireless connection.
Access does NOT play well with wi-fi.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jmillerWV" wrote:

> 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

Thanks for the reply. I will look into the network problem. Know any good
sniffer programs out there? No wi-fi I don't trust it yet.
jmillerwv

"Jerry Whittle" wrote:

> I'd wager good money that it's your network. There's probably a bad NIC
> (network interface card), router, switch, hub, computer, or even wiring
> causing bad or malformed packets. It doesn't even have to be a computer using
> the database. Get someone to run a sniffer to see if they can spot a problem.
>
> Access could be used as a network stress-test tool. If often finds problems
> which other programs seldom notice.
>
> Oh! Hopefully no one is using the database over a wireless connection.
> Access does NOT play well with wi-fi.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "jmillerWV" wrote:
>
> > 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