Hello everybody
Summary:
I have a problem with a VB application using DAO 3.6 or 3.51 that will not run only under administrator account.
Under a normal domain user account a Run-Time Error 3633 occurs when calling the CreateWorkspace method in the application.
Problem description:
My environment is Windows XP, I have DA0 3.6 installed on my system, SQL server 2000, Visual Basic 6.0
I have a small Visual Basic application that accesses both an SQL database and a Foxpro table.
Both are accessed using DAO 3.6 and their coresponding ODBC drivers.
I create 2 workspaces for each connection:
1) For the connection to the SQL database:
sConnectionString = "ODBC;DATABASE=MyDatabaseN
ame;"
Set wrkSql = CreateWorkspace("SqlWorksp
aceName", SqlUserName, SqlPassword, dbUseODBC)
2) For the connection to the Foxpro table:
sConnectionString = "ODBC;DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};" & _
"UID=;Deleted=Yes;Null=Yes
;Collate=M
achine;Bac
kgroundFet
ch=Yes;" & _
"Exclusive=No;SourceType=D
BF;DNS=;DA
TABASE=Loc
alDatabase
Name;" & _
"SourceDB=" + DataPathToThePhysicalFile + ";"
Set wrkEdi = CreateWorkspace("FoxproWor
kspaceName
", "admin", "", dbUseODBC)
The program run with no glitch on my developing system (Windows XP).
At the client's site - Windows 2000 Server used as a Terminal Server were all the users log in and do their work it also runs with no glitch under the administrator account.
If I log in as a normal domain user the program will through:
1) If a try to open first the Foxpro workspace - a Run Time Error 3633 with the message - Can't load DLL "?????L?"
2) If a try to open first the SQL workspace - a Run Time Error 3633 with the message - Can't load DLL "MSRDO20.DLL
There is a MSDN support article on this problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;260369
but it does not answert the question on why the program runs ok with administrator account and doesn't run ok with a normal account.
I have checked and the normal user seems to have access to all the required dlls for thsi project.
Please advise how could I solve this issue.
Thank you