"Unknown variable" message where no variable has to be created, etc.

  • Thread starter Thread starter Ach
  • Start date Start date
A

Ach

I would be thankful if somebody could help me with two bizarre
problems that I never had with the previous versions (I'm now on VBA /
Access 2002) :

a) I inserted the following standard instruction in a module, and I
got an "unknown variable" message related to to dbUseJet :

Set mywrkJet = CreateWorkspace("wrkSWXData", "admin", "", dbUseJet)

b) When I erase the dbUseJet part, I get another message "Active X
component can't create object (runtime error 429)"

This is quite strange, as I reproduced exactly the code found in the
help.

c) I tried to load more modules in the "References", like the MS DAO
3.6 object library, but I get a message "Name conflict with existing
module, project or object library, etc.". I changed the name of my
module, of my functions etc., with the same result.

Does anybody have any idea ?
Incredible that one must have problems with basic things that were so
easy in the previous versions.

Seemlingly unrelated question : is anybody aware of an alternative to
Access and Visual Basic :-) ?

Tnx.
Alain
 
I have :

VBA
MS Access 10.0 obj library
OLE Autom.
MS ActiveX Data objects 2.1 lib
MS ActiveX Data objects (MultiDim) 2.7 lib
MS Jet and Replic. objects 2.6 lib
MS DAO 3.0 objects lib

But how could those components *not* be compatible, or be redundant
one with another ?

Many thanks anyway :-)

Alain
 
Is MS DAO 3.0 a typo? The only version of DAO that'll work with Access 2002
is 3.6

If you're still running into problems, look for the file dao360.dll on your
hard drive, and use regsvr32.exe to reregister it.
 
<<>Is MS DAO 3.0 a typo? The only version of DAO that'll work with
Access 2002 is 3.6 >>

Nope. No typo. So I unchecked 3.0 and replaced it with 3.6 and it
seems to work. Many thanks.

Funny : the "3.0" was the one installed by default.

Cheers !

Alain
 
Back
Top