J
Jeff
I'm sorry if I am appearing noobish, but I'm a C programmer that
inhereted access because I'm the only "computer guy" in the office. Now
I've found some problems that I fear maybe a corrupt database.... and I
haven't the faintest of clue where to start when it comes to fixing
this problem.
Here is what happen:
About a week ago the registrar came to me to ask if I could help her
add a record to her training database. She told me that her and her
fellow registrar had MS Access lock-up on them while they where both
editing records. We will call the records the were editing StudentA and
StudentB. And after the lockup Access would not let her add StudentB.
The query:
SELECT * FROM Student WHERE (((Student.SSN)="123-45-6789"));
Returns the record for StudentA. Since 123-45-6789 is StudentA's SSN
that is fine, but
SELECT * FROM Student WHERE (((Student.SSN)="987-65-4321"));
where 987-65-4321 is StudentB's SSN still returns the record for
StudentA.
I deleted both records by using the delete commands:
DELETE * FROM Student WHERE (((Student.SSN)="123-45-6789"));
DELETE * FROM Student WHERE (((Student.SSN)="987-65-4321"));
and then I re-added StudentA. But I still have the same problem. Only
now when I select for StudentB's SSN (who's record has not been
re-added).
SELECT * FROM Student WHERE (((Student.SSN)="987-65-4321"));
I get a record that returns with all feilds reading "#Deleted" (even
the SSN feild)
So this sounds corrupted to me, but I am not a database admin and I
haven't a clue where to begin.... Any Ideas?
inhereted access because I'm the only "computer guy" in the office. Now
I've found some problems that I fear maybe a corrupt database.... and I
haven't the faintest of clue where to start when it comes to fixing
this problem.
Here is what happen:
About a week ago the registrar came to me to ask if I could help her
add a record to her training database. She told me that her and her
fellow registrar had MS Access lock-up on them while they where both
editing records. We will call the records the were editing StudentA and
StudentB. And after the lockup Access would not let her add StudentB.
The query:
SELECT * FROM Student WHERE (((Student.SSN)="123-45-6789"));
Returns the record for StudentA. Since 123-45-6789 is StudentA's SSN
that is fine, but
SELECT * FROM Student WHERE (((Student.SSN)="987-65-4321"));
where 987-65-4321 is StudentB's SSN still returns the record for
StudentA.
I deleted both records by using the delete commands:
DELETE * FROM Student WHERE (((Student.SSN)="123-45-6789"));
DELETE * FROM Student WHERE (((Student.SSN)="987-65-4321"));
and then I re-added StudentA. But I still have the same problem. Only
now when I select for StudentB's SSN (who's record has not been
re-added).
SELECT * FROM Student WHERE (((Student.SSN)="987-65-4321"));
I get a record that returns with all feilds reading "#Deleted" (even
the SSN feild)
So this sounds corrupted to me, but I am not a database admin and I
haven't a clue where to begin.... Any Ideas?