I'm using Windows 2000 and Office 2000. In Excel I'm using VBA code to
get data from an Access database (DOA OpenDatabase). As long as the
drive is an Administrative drive and I log on as an Administrator it
works fine. But if I log on as anything other than an Administrator I
get an error (3051 I believe) stating the MS Jet database engine
cannot open the file because it's already opened exclusively or I
don't have permission to access it. I know it's not already open.

Also if I sign on as an Administrator and make the drive
non-Administrative I get the same error. The only time it works is
when both the drive and the user are Administrative.

Just to make sure it wasn't a share problem I set Everyone to Full
Control but still have the same problem. It seems that when I access a
file through VBA, Windows thinks it's an unauthorized user trying to
access the file.

I need to have other users be able to do this and I really don't want
to make them all Administrators! Does anyone know how to correct this
situation?

I don't know if it matters or not, but the drive is FAT32 rather than
NTFS.

Thanks in advance for any help.