ACCESS CRASHES-DB now seems corrupt!

[kpalazzi]

I have an Access XP database that holds 7 ot 9 different programs - each program has its own set of tables, queries, forms and reports. All of them share a payment and commission structure so those fields are the same for each table and they also share modules that update these values.

After building all the tables, queries and forms for about 5 of the programs, I decided to to copy the same fields from one of the previous programs to the one I was working on to make things go faster.

I opened both tables in design view and highlight 10 or so fields, copy and pasted them to the new table. AT that point the fields didn't copy and I received and error report saying this is a Microsoft error and it gave me the option to report it. Then it creates a backup of my db and closes it, repopens it, runs compact & repair.

After this happened, any new tables I try to create, including the one I was working on when this happened does not enter new records correctly seems to be corrupt!

I tried creating a new database and importing all the objects that worked before and tried to create a new table but the same thing happens! The error seems to follow the data. What can I do to recover the the work I already did! Kimberly Palazzi
kpal29@hotmail.com

 

[annsolomon]

I feel your pain! I can't tell you how many times I went through the same scenario before someone screamed at me to COMPILE, COMPILE, COMPILE! Access seems to really get ornery when you do any copying/pasting unless you compile the database BEFORE you save the pasted object.