Unrecognized Database Format

[doodle]

xl97, windowsxp
Happy Friday! (Except for me...)

I've really done it this time. I was working in an Excel Spreadsheet. I
had a VB form I wanted to export to another excel spreadsheet and while
exporting I accidently double clicked on my access database instead.

Now it is fubared. Won't open. Won't compact with Jet utility. Can't
import anything into new database.

Ideas? (Other than restoring from server and losing everything I did
this morning?)

-doodle

 

[Jeff Boyce]

You have an Excel spreadsheet.

You are trying to compact an Access database.

What's the connection?

Can you still open the Excel spreadsheet with Excel?

Can you delete the Access db and start over?

More info, please

Jeff Boyce
Microsoft Office/Access MVP

 

[David Cox]

Have you opened Access and then browsed to find the mdb file? I ask to
eliminate the possibility that it is only a shortcut that is f... (what you
said)
..

 

[Guest]

If I understand you correctly, your database may be totally trashed. Don't
feel bad as I once saw someone open an Access mdb file in Word and save it as
a Word document.

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping. There's a
slight possibility that the database is just a little corrupted and you can
recover it. Here's some good info:

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[doodle]

Thank you for your responses.

Yes, I tried to Browse for the .mdb file, it won't open.

I also tried to import an access form with the same name to try to
overwrite the VB form, no luck.

To give more detail, I created a form in Excel using VBA. I was in VBA
and attempting to export the form to another excel worksheet that
needed a similar form. Instead of double clicking on the Excel
worksheet to add the form, I double clicked on my Access database
(which happened to have a similar name).

About half a second after I did it, I realized what I had done and
prayed that somehow Microsoft had realized that I might be this stupid
and it would return some type of error. No luck. To answer your
question, the spreadsheet still works fine, because all I did was
export from it. The database, on the other hand, is toast, as far as I
can tell.

I suppose I will have to get my backup from the server and learn my
lesson on this one. Thanks for your responses.

-doodle