Security error on opening a database from Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P. Scaram - 22 Mar 2006 15:50 GMT

I forward you a problem where after an upgrade to Windows XP and Office 2000
opening an MS Access database from Word using DAO 3.6 it returns to me a 3033
security error.
We did not have that problem with Windows 98 , Access97 and DAO 3.5. So i
believe is some enhanced security issue which needs to be addressed. I
enclose the previous communication with Mr Epson and the code.

I also checked the user level security for User Service1 and it has open
rights on the database.
Also the file VAMVK396.mdb in XP administration has full control rights.

Note also that inorder to enhance security we have followed the procedure of
importing the objects into another database under a different owner from
Admin. The owner and user with Administrator rights is now MasterUser. I
tried to create the workspace with the MasterUser but it still returned the
same error

If there is a correction on the code or a workaround please let me know.

Thank you very much in advance.

P. Scaram" <PScaram@discussions.microsoft.com> wrote in message
news:D8891F74-6DFA-48B4-A7B2-8194FBC8C0AF@microsoft.com...

> In the MSWord document I changed the reference to DAO 3.6 and the memory
> problem went , but I get a security errror 3033 when I try to open the
> database. "You do not have suffucient rights to use the object
> "\\prlnnt800srvr\users\common\advice\vamvk396.mdb. The administrtor or
> owner
> must grant you the necessary rights".
>
> This is a new problem related to Office 2000 or Windows XP ?
> Note that we do not yet use access2000 but access 97, until all PCs are
> upgraded to Office 2000.
> The code is as follows
>
> DBEngine.SystemDB = "\\prlnt800srvr\USERS\COMMON\ADVICE\VAMVAKAS.MDW"
>
> Set oWorkSpace = DBEngine.CreateWorkSpace(Name:="JetWorkSpace", _
> UserName := "Service1", Password:="onlyforus", _
> UseType:=dbUseJet)
>
> Se oDatabase = OpenDatabase
> ("\prlnt800srvr\USERS\COMMON\ADVICE\VAMVK396.mdb")
>
> On this command I get the security error 3033.
>
> I checked the user Service1 in MSAccess and it has open rights on the
> database.
> Also the file has VAMVK396.mdb has full control rights.
>
> I would be grateful if you could help.

Reply to this Message

Jezebel - 22 Mar 2006 22:25 GMT

Is this code running in Word VBA? -- And if so, have you checked the
validity of the project's DAO reference?

> I forward you a problem where after an upgrade to Windows XP and Office
> 2000
[quoted text clipped - 51 lines]
>>
>> I would be grateful if you could help.

Reply to this Message

P. Scaram - 27 Mar 2006 14:28 GMT

Yes it runs on Word vba.
For your information I solved the problem by inserting
oWorkspace.opendatabase instead of opendatabase on its own.

This did the trick and the command was somehow refreshed. I think this has
happened to me before in word programming.

Philip

> Is this code running in Word VBA? -- And if so, have you checked the
> validity of the project's DAO reference?
[quoted text clipped - 54 lines]
> >>
> >> I would be grateful if you could help.

Reply to this Message