run out of memory error 2004 on CreateWorkSpace command with Windo

[P. Scaram]

Hello Sir/Madam,

A client of mine upgraded from Windows 98 to Windows XP. In a Word document
we use the createWorspace command to connect to an access database to update
a record with a value from the word document. We use the library DAO 3.5
Object Library.
At the create workspace command we get an error 2004 run out of memory. The
same code was working fine on Windows 98 with Office 2000.
The problem appeared when we installed windows XP.
We have windows XP Version 2002 (SP2) and Office 2000 9.0.3007.

Is there a way to fix that , I just thought maybe using DAO 3.6. ?
If there isn't how can use another technique to access the access database
without Workspace command,or in a way to access less memory, note the
database we want to update is already open in windows.

Thank you in advance

P. Scaram

 

[david epsom dot com dot au]

Yes, you can just use DAO 3.6.

Or, you can apply the service packs to Jet 3.5/DAO 3.5.
You should apply the service packs anyway, and this is
just a timely warning that you haven't done so yet.

(david)

 

[P. Scaram]

thank you for your prompt answer , I will try it as soon as possible.

we are planning to upgrade to office 2000 sp3 for the problem access2000 has
with importing forms, will that cover the DAO 3.5 upgrade you mention , or
something extra is required

P. Scaram

 

[david epsom dot com dot au]

Office 2000 uses DAO 3.6, and probably won't fix DAO 3.5.

If you are using DAO 3.5, you should download and apply
Jet 3.5 SP3, or check the Jet/DAO file versions to see
if you have the most recent versions.

(david)

 

[P. Scaram]

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.

 

[david epsom dot com dot au]

I'm not sure about this. I think you should repost this as a
new question in microsoft.public.access.security

(david)