Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.win2000.security,microsoft.public.excel.programming
|
|||
|
|||
VBA Authorization in Win2k
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Authorization in Win2k
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. -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read- only Protect Folders and contents in WIN2K Server | Excel Discussion (Misc queries) | |||
Problem reinstallation MS Ofiice on new PC. Authorization Issue | Setting up and Configuration of Excel | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Using Round function on French and US Win2k | Excel Programming | |||
XL97/Win2K - lookup and return listing | Excel Programming |