Cannot open .mdb

  • Thread starter Thread starter dxmah
  • Start date Start date
D

dxmah

Happy holidays: I've been using Access 2002 for a while. This past week I
copied a .mdb folder from my home PC onto my flash drive to work on at work.
When I brought the flash drive back home to copy back onto my home PC, the
folder could not open. I've tried "compacting and repairing" and nothing
happens. Please advise.
 
dxmah said:
Happy holidays: I've been using Access 2002 for a while. This past
week I copied a .mdb folder from my home PC onto my flash drive to
work on at work. When I brought the flash drive back home to copy
back onto my home PC, the folder could not open. I've tried
"compacting and repairing" and nothing happens. Please advise.
Click to expand...

How are you trying to open it? What exactly happens when you try to open
it? Does it give an error message? Have you copied it back to your HD? Is
the file read only? Could user level security been added?
 
dxmah wrote:
Click to expand...
Happy holidays: I've been using Access 2002 for a while. This past week I
copied a .mdb folder from my home PC onto my flash drive to work on at work.
When I brought the flash drive back home to copy back onto my home PC, the
folder could not open. I've tried "compacting and repairing" and nothing
happens. Please advise.
How are you trying to open it? What exactly happens when you try to
open it? Does it give an error message? Have you copied it back to your
HD? Is the file read only? Could user level security been added?
Click to expand...
Hi Joseph:

Thanks for asking. Well, I've done this procedure several times (ie. copy
the .mdb file from my HD to a flash drive, take it to work using their PC
which also has Access 2002, then bring it back home to copy to my HD). Also,
I never directly copy the file back onto my HD (which really paid off this
time not to) but clicked on the file to open to verify the data from work
was still there - unfortunately an error message pops up "Microsoft Access
has detected corruption in this file...make a backup copy...tools to db
utilities to compact repair db...if you're trying to repair this corruption,
you will need to recreate the file or restore it". I've tried this several
times but the error message keeps popping up. Also could not open the backup
copy. No, there's no user level security on it nor read only file either.
Lastly, I do still have the original file on my HD, which I renamed luckily.
Getting very pessimistic this file is really corrupted but any suggestions
would be sorely welcome.

Best,
donald
 
dxmah said:
Happy holidays: I've been using Access 2002 for a while. This past
week I copied a .mdb folder from my home PC onto my flash drive to
work on at work. When I brought the flash drive back home to copy
back onto my home PC, the folder could not open. I've tried
"compacting and repairing" and nothing happens. Please advise.
Hi Joseph:

Thanks for asking. Well, I've done this procedure several times (ie.
copy the .mdb file from my HD to a flash drive, take it to work
using their PC which also has Access 2002, then bring it back home to
copy to my HD). Also, I never directly copy the file back onto my HD
(which really paid off this time not to) but clicked on the file to
open to verify the data from work was still there - unfortunately an
error message pops up "Microsoft Access has detected corruption in
this file...make a backup copy...tools to db utilities to compact
repair db...if you're trying to repair this corruption, you will need
to recreate the file or restore it". I've tried this several times
but the error message keeps popping up. Also could not open the
backup copy. No, there's no user level security on it nor read only
file either. Lastly, I do still have the original file on my HD,
which I renamed luckily. Getting very pessimistic this file is really
corrupted but any suggestions would be sorely welcome.
Best,
donald
Click to expand...

My guess is the USB port on your work machine may be USB-2 and your home
machine may be USB-1. Try copying the file to your hard drive (a different
directory than the original) and see if you can open it. I suggest that
even if it worked once via a USB-2 connection, I would not recommend it.
Copy the file into the hard drive use it then copy it back to the flash
drive.
 
Joseph Meehan said:
My guess is the USB port on your work machine may be USB-2 and your
home machine may be USB-1. Try copying the file to your hard drive (a
different directory than the original) and see if you can open it. I
suggest that even if it worked once via a USB-2 connection, I would not
recommend it. Copy the file into the hard drive use it then copy it back
to the flash drive.
Click to expand...
Hi Joseph (again): Well, it looks very dismal. For some reason, I cannot
even open this file at the work PC now!
The only response that happens is...nothing (ie. click on the file and
literally nothing, not even an error message). However, right clicking the
file does show 1.6mb in properties. I even took the liberty of copying the
orig file (which does not contain the newer information and has 1.48mb) from
my home PC onto the same flash drive and it opened at work. Interesting!?
Again, any advice would be appreciated on this problem.

Yes, you are right, my home PC has USB-1 and work has USB-2. I am planning
to add two more USB-2 ports on my home PC (since getting new printer
anyways) so in the future, use those ports for flash drive use (?)

Thanks again,
donald
 
dxmah said:
Hi Joseph (again): Well, it looks very dismal. For some reason, I
cannot even open this file at the work PC now!
The only response that happens is...nothing (ie. click on the file and
literally nothing, not even an error message).
Click to expand...

Try starting Access then opening the file from Access after it is copied
to the HD. If that works, then it would appear that the relationship of the
file type and Access has been lost or that Windows could not find Access.

Good Luck.
However, right
clicking the file does show 1.6mb in properties. I even took the
liberty of copying the orig file (which does not contain the newer
information and has 1.48mb) from my home PC onto the same flash drive
and it opened at work. Interesting!? Again, any advice would be
appreciated on this problem.
Yes, you are right, my home PC has USB-1 and work has USB-2. I am
planning to add two more USB-2 ports on my home PC (since getting new
printer anyways) so in the future, use those ports for flash drive
use (?)
Thanks again,
donald
Click to expand...


Access requires very very good high speed access to a file or
corruption is possible. I would not trust any USB port to handle that. In
fact, even a very good LAN is not the best idea, that is why split database
design is important. While I have not tried it, in theory, using a split
database might work for your work flow. It reduces the potential problem.
You can store just data on the file that is on the flash drive (tables only)
and have forms reports queries etc. on databases on each machine, but no
data on those machines (unless the data is static). However I would still
suggest that copying the file to the HD on each machine would be safer. How
about the briefcase? I have never used it and don't recall how it might
work with Access.
 
Back
Top