access db corrupt in specific directory

Hi experts, here's a strange (at least for me) problem:

The problem occurred when i copied an access db (about 630 mB) from a local disk to a specific directory on the server. The local db was not corrupt but the copy on the server was. The copy of the local db to a another directory on the server was not corrupt. but when i move the correct db from the 'other' directory to the specific directory, it is corrupt again.

so:

db on C:\ copy to ......server\DirA\Dirb                        -----> copy is corrupt
db on C:\ copy to ......server\DirA                                -----> copy is not corrupt
drag db from server\DirA    to ......server\DirA\DirB  -----> moved db is corrupt

any ideas? Is this a windows- or access issue???
corhavemanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Kelvin SparksConnect With a Mentor Commented:
The other thing to keep in mind is the total length of the directory path name and filename. TRhese should not exceed 255 characters. Access can have problems resolving anything longer than that.


Kelvin
0
 
Kelvin SparksConnect With a Mentor Commented:
Are the user rights the same on both? Is there any compression on one and not the other?

Kelvin
0
 
Gustav BrockConnect With a Mentor CIOCommented:
Try to copy the file back - from the "bad" directory DirB to a "good" directory.

If it still is bad, something happens to the file during the initial copy.
If it is good, something happens when Access connects the file in the "bad" directory DirB.

In any case, this sounds like a file server issue not related to Access.

/gustav
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
I've seen that happen with buggy NIC drivers.  Also, check anti-virus on the server and turn it off as a test.

Last, zip the DB, copy and un-zip.  See if it still gives you a problem.

Jim.
0
 
Gabriel CliftonConnect With a Mentor Commented:
Backup all of the files in the "bad" directory. Delete the bad directory, recreate it and try copying files to the directory.
0
 
corhavemanAuthor Commented:
Hi Guys,

For some reason the problem solved itself a few days later. I have have no idea what caused the problem. Thanks for the suggestions. I divided the points.
0
All Courses

From novice to tech pro — start learning today.