Database disappeared when i accidentally exported it 2 split file

B

boon

Hi,everyone.i have a big problem here.i accidentally exported my table to my
split file and now when i try to open the table,it shows "the microsoft
office access database cannot find the input table or query 'filename'.Make
sure it exists and that it's name is spelled correctly." What is wrong with
the thing?Did i delete the database accidentally?If so,how do i retrieve it
back?Hope to hear from you guys soon.Have a nice day
 
J

John W. Vinson

Hi,everyone.i have a big problem here.i accidentally exported my table to my
split file and now when i try to open the table,it shows "the microsoft
office access database cannot find the input table or query 'filename'.Make
sure it exists and that it's name is spelled correctly." What is wrong with
the thing?Did i delete the database accidentally?If so,how do i retrieve it
back?Hope to hear from you guys soon.Have a nice day

Please explain just what you did. You cannot "export a table to my split file"
- you can export it to the frontend database, or you can export it to the
backend database (you could even do both).

If you exported it to the backend (the file will normally be named with a _BE
suffix), then the frontend won't know that it's there until you tell it. Open
the frontend and select File... Get External Data... Link; navigate to the _BE
file, and select the newly imported table. Does this resolve the problem for
you?

John W. Vinson [MVP]
 
B

boon

I also don't know how to explain it exactly.Will gt back to you once i find
out a way to explain.Thanks alot.Have a nice day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top