VBA Authorization in Win2k

[Just Me]

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.

 

[Frank Stone]

This is a share problem. Admin has all rights but users
and groups are given rights by admin. if users can't get
to it then they haven't been given the rights yet.
are they part of a group and the group hasn't been given
rights yet.
does the group have rights but not the users in the group
do the users have enough rights like no read/right/modify
rights. does the group.
is the access database password protected?
all these rights can be granted/revoked at the admin pc.
sounds like you got some snooping to do concerning rights.
wish i could be more spicific but rights can get tricking
perticularly if more that one person in IS is
granting/revoking. do you have documatation on this.