 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2005Lost primary key
One of my tables has lost its primary key twice in the past 24 hours. The key is still there, but it lost its designation as Primary. Took me a while to figure out what happened (update queries suddenly stopped working), but after I did I put it back, and a couple of hours later it was no longer the primary again. Needless to say, this is pretty spooky. (Access 2003, Jet 4 SP8 backend) ANY idea what could have happened??!! Are you running queries that delete the primary key index from the table?  SignatureKen Snell <MS ACCESS MVP> > One of my tables has lost its primary key twice in the past 24 hours. The > key is still there, but it lost its designation as Primary. Took me a [quoted text clipped - 6 lines] > Needless to say, this is pretty spooky. (Access 2003, Jet 4 SP8 backend) > ANY idea what could have happened??!! Absolutely NOT! > Are you running queries that delete the primary key index from the table? > [quoted text clipped - 8 lines] > > Needless to say, this is pretty spooky. (Access 2003, Jet 4 SP8 backend) > > ANY idea what could have happened??!! What type of table is this? (linked vs. local, Jet vs. ODBC, etc.) How are you determining that the PK is gone? (Look in Access GUI, iterating tabledef's indexes by name, iterating tabledef's indexes by primary property) How are you resetting the PK? (GUI, code) > Absolutely NOT! > [quoted text clipped - 13 lines] >> > backend) >> > ANY idea what could have happened??!! It's a linked Jet table from an Access front end, and it just happened again. I can tell when it happens when a form which has been fine for months suddenly starts being not updateable. That now leads me to look at the back end, and the table definition no longer shows Primary for what should be the primary key. I then put it back again with the GUI, and it's fine... for a while. None of my queries EVER do anything with indexes. Yoicks! > What type of table is this? (linked vs. local, Jet vs. ODBC, etc.) > [quoted text clipped - 21 lines] > >> > backend) > >> > ANY idea what could have happened??!! Kevin, This sounds really bizarre. I've never heard of a Primary Key index disappearing on its own. That leads me to suspect some kind of corruption that may only get worse. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > It's a linked Jet table from an Access front end, and it just happened again. > I can tell when it happens when a form which has been fine for months [quoted text clipped - 32 lines] > > >> > backend) > > >> > ANY idea what could have happened??!! Yeah, well sometimes bizarre 'r us. Shudda seen what Word did to me yesterday with a table of contents! I'm going to rebuild the table from scratch and see what happens. BTW, this has happened on both the client's machine and my own. > Kevin, > This sounds really bizarre. I've never heard of a Primary Key index [quoted text clipped - 47 lines] > > > >> > backend) > > > >> > ANY idea what could have happened??!! > Yeah, well sometimes bizarre 'r us. Shudda seen what Word did to me > yesterday with a table of contents! LOL... Word can do some really strange things. > I'm going to rebuild the table from scratch and see what happens. BTW, this > has happened on both the client's machine and my own. If you are copying the database back and forth from yourself to the clients, you may also be copying corruption back and forth -- assuming it is corrupted. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > It's a linked Jet table from an Access front end, and it just > happened again. I can tell when it happens when a form which has [quoted text clipped - 4 lines] > > None of my queries EVER do anything with indexes. I don't suppose anybody/anycode is running a make-table query on the table in question in the back-end database? SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) No such luck. The primary key didn't disappear again on Friday, so I'm waiting to see what happens Monday. > > It's a linked Jet table from an Access front end, and it just > > happened again. I can tell when it happens when a form which has [quoted text clipped - 7 lines] > I don't suppose anybody/anycode is running a make-table query on the > table in question in the back-end database? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.