[RESOLVED] Microsoft Access 2000

[stankfunk]

Recently an Access .dbf file has become unaccessable (no pun intended). The error reads "invalid path or check that name is typed correctly". This file resides on a mapped drive on an NT server. I get the same message when I go directly into it on the server. Has this file been corrupted? There have no recent changes besides a thorough defrag of the server. Any ideas? Thx.

[Lowland]

It sounds like a permissions problem. Check permissions on the file, container and parent folder, and make sure you can access. One small change of permissions can cause this, especially if changes have been propogated to sub-folders.

Good luck

PS - check your mapped drive too. See if an Administrator (NT/Win2k Defined) can access this file

------------------
Any clanvestites? Or looking for Scotland sites?
Come visit www.lowlandgroup.co.uk (http://www.lowlandgroup.co.uk) and see what we do - jump to our community site from us

[maverickhowell]

Another trick is to set the file up as an ODBC data source (via control panel) and see if you can access (again no pun intended) from there.

Alternatively try accessing the file by doing a mail merge with it from Word and check what error you get from it there (if any).

Lastly the best test for permissions problems is to try accessing the file whilst it is located on a FAT drive because you then have no FILE permissions to deal with only NETWORK permissions. If the file still won't open (making sure you have at least READ access to the file from the network to the file on the FAT drive) then the problem is down to the file and not the program, OS or permissions.

NOTE: DBF files are FOXpro or DBase files not Access file, which should have an MDB entension.

I hope this helps! :)

[jeffsr]

Check your drive mappings. Make sure they haven't changed.