error 3015

[Dundee Lad]

I am having serious trouble opeining a database I have built.

When I log on I receive an error message isn't an index table in the table. Look in the indexes collection of the tabledef object to determine the valid index names

can anyone help, please

 

[Dugantrain]

Sounds like you have some corruption going on. Try to import all of your objects into a new, blank database, hopefully that'll work. If not, you can try using the Jet Compact Utility which you can download from Microsoft.com (I don't have the direct link on hand, you'll have to find it). If that doesn't work, then hopefully you have a back-up on hand.

 

[Dundee Lad]

unfortunately the backup is the same! I have tried copying into a blank database too but this does not work either?

 

[Dugantrain]

Did you copy/paste your objects? If so, try to import them via the File->Get External Data route. Also, are you able to open the database at all? If so, then it's probably one single object (maybe a system table) that is corrupted and you can probably figure out a way to get around this; if not then the db is corrupt and you probably have a bigger issue on your hands. I don't mean to lecture, but when you're dealing with Access, you're eventually going to be dealing with corruption and the best/only safeguard is to back-up routinely. Trust me, a company's sensitive data plus Access will eventually equal a very hard lesson learned.

 

[Dundee Lad]

I trust you dugantrain, I think I have just learned my lesson!

thanks for your help anyway