dxmah wrote:
>>> "Joseph Meehan" <(E-Mail Removed)> wrote in message
>>> news:E3hfh.3371$(E-Mail Removed)...
>>>
>>>> dxmah wrote:
>>> 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? --
>>>> Joseph Meehan
>>>>
>>>> Dia 's Muire duit
>>>>
>>> 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
>>
>> 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
>>
>> Dia 's Muire duit
>>
> 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).
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
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.
--
Joseph Meehan
Dia 's Muire duit
|
Similar Threads
