Yesterday morning we seemed to have a power glitch and it caused the "file is not an Access database or needs to be repaired" message to show up for my back end file. (Using Access 2000 on a network with the front end MDE and the back end MDB both on the network - about 9 users) Ran the repair but it did not "repair". It changed the property of the primary key in my main Client table to Indexed(Duplicates OK) and it was an AutoNumber field. Yikes! Broke all the table relationships in the process.
We restored from a backup and lost a little bit of data in the process.
However, a little bit later I noticed the the size of the back end MDB file had ballooned to 750 MB and later in the day jumped to 1.4 GB. Scary! I ran a compact and repair and it brought it back down to 750 MB and has seemed to run okay for the past 48 hours.
Today I took a copy of the back end and tried to import the tables into a clean database. It doesn't like that Client table. It will import the rest just fine.
Next step.....I exported the Client table from the copy into Excel and then reimported it into my clean database. The total size of the new database backend is now 5MB. That sounds more like it!
Now the problem........the ClientID which is an Autonumber field in the present database comes in from the Excel as a Number field instead of Autonumber and Access obviously won't let you change the data type. I need to preserve all the current numbers in the ClientID field but also need Access to continue to Autonumber as new clients are added. I know I've read warnings about using AutoNumber...I guess this is why.
Any suggestions? Thanks!
We restored from a backup and lost a little bit of data in the process.
However, a little bit later I noticed the the size of the back end MDB file had ballooned to 750 MB and later in the day jumped to 1.4 GB. Scary! I ran a compact and repair and it brought it back down to 750 MB and has seemed to run okay for the past 48 hours.
Today I took a copy of the back end and tried to import the tables into a clean database. It doesn't like that Client table. It will import the rest just fine.
Next step.....I exported the Client table from the copy into Excel and then reimported it into my clean database. The total size of the new database backend is now 5MB. That sounds more like it!
Now the problem........the ClientID which is an Autonumber field in the present database comes in from the Excel as a Number field instead of Autonumber and Access obviously won't let you change the data type. I need to preserve all the current numbers in the ClientID field but also need Access to continue to Autonumber as new clients are added. I know I've read warnings about using AutoNumber...I guess this is why.
Any suggestions? Thanks!
