K
katz
To the Microsoft MVP professionals!
I have a big serious problem, please help!
I already posted this problem on 03/05/07, Allen Browne responded, thanks I
appreciated.
I'm a developer using MS access since Access1. I used to work with IBM
mainframe CICS Cobol. Our databases are split and well optimized (I hope
so). My customers are pushing me to upgrade to Acc2003 from Access97. One of
my customer that I upgraded recently to Acc2003, called me that the database
is acting up. I told them to compact/repair and the trouble started. They
lost the key from the Customer and the Payments table and a few customers
were missing. Luckily I was able to track it down, because the missing
customers didn't take with them the payments from the payment table.
We also lost all the relationships, I did "show all" on the front end, back
end. It took me a few ours to put back all the relationships. The database
is not so big the front end is about 6MB and the tables about 73MB. The net
work is peer to peer, four fast Dell computers.
2) Yesterday, we got a call from another customer, that the last, about 150
records in the customer file show "error" in all the columns. I told them to
compact/repair and all the 150 records were deleted. The MSysCompactError is
no help at all, it only shows, a lot of lines with ErrorCode: 10 47,
ErrorDecription: Could not find field 'Description'., Table: Customer".
Another messages ErrorCode: 1063, ErrorDescription: "You cannot add or
change a record because a related record is required in table 'Customer',
Table: Invoice.
We are very concerned, because I don't know what is going to be missing
next.
It looks like the compact/repair, doesn't fix the problems it deletes
problems.
This Customer has a powerful Dell 2003 Windows server about 10 users.
The database is about 11MB and the tables about 32MB.
As I wrote before we never had missing records with acc1, acc2 and acc97.
I don't know why Microsoft does it to us developers. It seems they can't
understand that we don't need the fancy wizards. We need is, the triple SSS
Simple, Stable and Speed.
Please let me know if you have any suggestions. I can't even go back to
Acc97 anymore.
Concerned, Abe StarTech
I have a big serious problem, please help!
I already posted this problem on 03/05/07, Allen Browne responded, thanks I
appreciated.
I'm a developer using MS access since Access1. I used to work with IBM
mainframe CICS Cobol. Our databases are split and well optimized (I hope
so). My customers are pushing me to upgrade to Acc2003 from Access97. One of
my customer that I upgraded recently to Acc2003, called me that the database
is acting up. I told them to compact/repair and the trouble started. They
lost the key from the Customer and the Payments table and a few customers
were missing. Luckily I was able to track it down, because the missing
customers didn't take with them the payments from the payment table.
We also lost all the relationships, I did "show all" on the front end, back
end. It took me a few ours to put back all the relationships. The database
is not so big the front end is about 6MB and the tables about 73MB. The net
work is peer to peer, four fast Dell computers.
2) Yesterday, we got a call from another customer, that the last, about 150
records in the customer file show "error" in all the columns. I told them to
compact/repair and all the 150 records were deleted. The MSysCompactError is
no help at all, it only shows, a lot of lines with ErrorCode: 10 47,
ErrorDecription: Could not find field 'Description'., Table: Customer".
Another messages ErrorCode: 1063, ErrorDescription: "You cannot add or
change a record because a related record is required in table 'Customer',
Table: Invoice.
We are very concerned, because I don't know what is going to be missing
next.
It looks like the compact/repair, doesn't fix the problems it deletes
problems.
This Customer has a powerful Dell 2003 Windows server about 10 users.
The database is about 11MB and the tables about 32MB.
As I wrote before we never had missing records with acc1, acc2 and acc97.
I don't know why Microsoft does it to us developers. It seems they can't
understand that we don't need the fancy wizards. We need is, the triple SSS
Simple, Stable and Speed.
Please let me know if you have any suggestions. I can't even go back to
Acc97 anymore.
Concerned, Abe StarTech