What is happening to my records

[Scoty]

Hi all,
It's been a while since I have been to this forum but I don't know where else to turn. I have an access/vb backend/front end application that we use to order check copies from the bank. And some of my records are disappearing

<Situation>
1. I have no required fields on my table

2. I have the process set up to automatically collect the information from IBM PCOMM 4.31

3. I do not have the database directly linked in my program. I use an ODBC driver for access and just open my connection when I save.

4. There are no delete queries connected to this table

5. Multi user enviroment. (250 users)...this is not constant there are only 4 users who actually keep the database open all day. The rest just hit it to save then I close the odbc connection. (one reason why I went to the vb front end )

<Symptoms>
1. The records remain on the table for 1-30 days then just drop off.

2. It is not everyrecord every time

3. There are times when this occurs seq. record (but again it is not everytime) Ie. number 100 and 101 will be missing but 99 and 102 are still available

4. There seems to be no commonalities between the records that show up as missing.


I know this is a long post but if you took the time to read it thank you. If you have any suggestions thank you even more.

Thanks
Scoty :


&quot;Learn from others' mistakes. You could not live long enough to make them all yourself.&quot;
-- Hyman George Rickover (1900-86),

 

[WildHare]

There seems to be no commonalities between the records that show up as missing.

How could they show up if they're missing?...[Smile]

Seriously, this is odd - since there seems to be no pattern at all between the 'disappearances'. It's not time related (1 - 30 days?) Not value related (&quot;no commonalities&quot

Is the data engine a JET db? Do your users ADD records, or just edit existing ones that you get from the PCOMM?

Is there ANY way for your users to delete records, even unconsciously?

Under normal circumstances, bit rot should not affect Access databases stored in a cool, dry place for at least 14 years. There has to be a logical reason.

Remember, you're unique - - just like everyone else
Another free Access forum:

http://www.forumco.com/jmhare

http://www.jmhare.com

 

[Scoty]

Jim,
Thanks for the post. I realized how that read when I posted it but by then it was aready posted. So you got me.

1. I am using the ADO Data Control provided with MS VB6.0.
So it is using the 2-UseJet Setting. I use that Access Driver on the ODBC side.

2. As far as the &quot;Ooops&quot; Syndrome goes. I can't be a 100% sure on that. I could expect maybe 1-10 of those a month (we get about 40 requests a day) but to have 20 in a week come up missing Idunno? :-(

3. The 250 &quot;Hit/End&quot; Users just add. The 4 constant users do all the editting.

So I dont know. But it is killing me. My boss is on my back.

Is there anyway to &quot;Lock&quot; the table to allow edit but prevent deletions?

Thanks
Scoty :
&quot;Learn from others' mistakes. You could not live long enough to make them all yourself.&quot;
-- Hyman George Rickover (1900-86),

 

[Junior1544]

well, if this database is setup with multi user security, then you can make the &quot;250&quot; add users not have the abitility to delete, that would get rid of the &quot;oops&quot; factor there, and the same to the four if they don't need to delete either... that would totaly get rid of the user oops's... but then you are the only one able to delete... Just some idea's for you to think about...

--Junior Junior1544@yahoo.com
Life is change. To deny change is to deny life.

 

[Scoty]

Junior,
Thanks for your post. I am not using the workgroup security, simply because I don't have time to

a) Learn about it
b) support it once I have it in place

If any one nows how to lock deletes with code Please let me know.

Thanks
Scoty :

ps. love your emoticons &quot;Learn from others' mistakes. You could not live long enough to make them all yourself.&quot;
-- Hyman George Rickover (1900-86),