Primary key lost

[Pietro]

Hi,

It happens that some problems occur in my database then when i open the
be i receieve the famous error message "This databasee is in an
inconsistent...", then i compact and repair the be i get another message that
says that i should check the tables...
When i check the tables i find out that all primary keys are lost, so i
should do them again.
Do we have any solution for this ?

 

[John W. Vinson]

Hi,

It happens that some problems occur in my database then when i open the
be i receieve the famous error message "This databasee is in an
inconsistent...", then i compact and repair the be i get another message that
says that i should check the tables...
When i check the tables i find out that all primary keys are lost, so i
should do them again.
Do we have any solution for this ?

See if you can prevent the corruption in the first place. See
http://www.granite.ab.ca/access/corruptmdbs.htm
for common causes and cures.

 

[Arvin Meyer [MVP]]

No solution other than you are doing something that is corrupting your
database, and need to figure out what that is so you can stop doing it. I
could waste both of our times and make a bunch of wild guesses, but it might
be better if you can describe what's causing the problems you are having,
first.

Keep in mind, that almost all problems occur because of something during a
write to the data. So if a form is open and has been edited, and there is a
problem in the network between that open form and the database, you can
corrupt it.

 

[a a r o n . k e m p f]

Jet does this. Jet is a crappy database.

Move to SQL Server, Access Data Projects-- and you won't have this
problem any longer.

 

[James A. Fortune]

Jet does this. Jet is a crappy database.

Move to SQL Server, Access Data Projects-- and you won't have this
problem any longer.

That sounds like a bot answer. Do you use a bot sometimes?

architecture
compact and repair
ODBC
bug
corruption
network
error

If so, does it look for certain words? Does it start at certain times
of the night? You made a lot of posts in a very short time. If not,
are you using a database or text file to get those posts out so quickly?

See:

http://en.wikipedia.org/wiki/Internet_bot

James A. Fortune
(e-mail address removed)

 

[Tony Toews [MVP]]

If not,
are you using a database or text file to get those posts out so quickly?

Hmm, maybe he's using the Newsgroup Answers MDB - I designed the MDB
to assist frequent newsgroup answerers, such as MVPs, in quickly
locating and pasting in their favourite snippets of answers.
http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[James A. Fortune]

Hmm, maybe he's using the Newsgroup Answers MDB - I designed the MDB
to assist frequent newsgroup answerers, such as MVPs, in quickly
locating and pasting in their favourite snippets of answers.
http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

Tony

Maybe that's it. It didn't look like he even had time to type some of
them, much less put them through his brain.

James A. Fortune
(e-mail address removed)

 

[John W. Vinson]

Maybe that's it. It didn't look like he even had time to type some of
them, much less put them through his brain.

Very short circuit-path there: Any question in... bash JET and recommend
SQL/Server out.

That's of course a good recommendation in some cases - I have two clients
using SQL - but Aaron's pretty clearly got an idee fixe on the subject.

 

[a a r o n . k e m p f]

Tony;

You don't know a single thing about the internet, or how newsgroups
work.. so why don't you STFU and stop trying to take credit for
everything.

Next thing we know, Al Gore will be trying to take credit for
inventing the internet again.

-Aaron

 

[a a r o n . k e m p f]

John;

Well congrats on using SQL Server, let me guess you use linked tables
and have 100,000 lines of VBA code (stuff that should be done in
sprocs, for example).

Oh, you want to loop through some records and fire SQL, we better do
that in VBA!!!!

(DOING IT IN SQL LEADS TO BETTER PERFORMANCE, SCALABILITY AND
MAINTAINABILITY)

-Aaron