Table loses primary key setting

[ClemsonSeth]

Hello:
I've got an Access database running on a server with 10 or so users.
In the last couple of days, I've had a probem twice that I was finally able to diagnose as a table having "lost" a primary key setting.

The autonumber field that I had designated as the PK was no longer set as a PK.

Anybody seen this and know of how to prevent it from happening?

Thanks!

-Seth

 

[LonnieJohnson]

Are there any "make-a-table" queries involved in your application?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[ClemsonSeth]

There are no Make-Table queries.

I do have lots of 'append' and several 'delete' and one 'update'.

-Seth

 

[markphsd]

I've had the same problem. I'm looking for a solution. Please post one here if you find it. I'll do the same.

Mark P.

Bleh

 

[ClemsonSeth]

Mark:
Not sure that I have found a solution, but I have found some more info on the subject. Follow the link below - it is a bit confusing, so here is my interpretation of all of it...

http://www.utteraccess.com/forums/s...m&olderval=1&oldertype=m#Post372323&bodyprev=

If this link doesn't work, go to utteraccess.com and search for "Primary Key Lost Count" - that should get you there.

First, I am updating the service packs on all users and the server.

http://support.microsoft.com/default.aspx?kbid=239114#2

Also, I am following the decompile procedure. I'm not sure if this is more applicable to the front end or back end, but I am doing both.

Hope this will work - I'll post here with more info.

-Seth