V
Victor
Hi Alic,
This mail is answering to the attached mail (see the last
part), to add more information of the problem. This
information have been answered on the old mail but I have
not received response.
I tryed with the DBEngine but the error it is the same.
I installed 3 days ago the MDAC 2.7 without results.
I have checked the system and I have the msjet40.dll sp6
(4.0.6218.0). Should I install the SP3 for access97? or
shoul I install the sp8?. Does access97 use msjet40?
It is opened the typical errror windows saying Microsoft
have detected a problem and it must be closed (translation
of spanish):
AppName: msaccess.exe
AppVer: 8.0.0.3512 ModName:dao350.dll
ModVer: 3.511608.0
Offset:00016216
I have installed the office xp and after that, the code
works without problems.
After remove the office xp, the code continues working
very well.
Thanks,
Victor
----------------------------------------------------
Hi Victor,
Based on your message, I have some suggestions:
1. Try to use DBEngine.CreateWorkspace instead of
CreateWorkspace
2. There could be some COM object files registered
improperly or not
registered at all. You can download the latest MDAC from
http://www.microsoft.com/data and install it on the
Windows XP computer.
Additionally, since you are using DAO, you need to
download Jet 4.0 SP3 or
later from that web link as well. Install Jet 4.0 SP3 or
later on the
problematic WinXP machine.
How To: Obtain the Latest Service Pack for the Microsoft
Jet 4.0 Database
Engine
http://support.microsoft.com/?id=239114
In adtion, is there any error message you received?
Please feel free to reply to the threads if you have any
concerns or
questions.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and
confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Victor" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| I have a access application (ACCESS97) working as client
| of a SQL Server 2000.
| The following vb code gets the name of the bases in the
| SQL Server that start with some letters included in the
| variable 'IdentificadorBaseDatos'. When this code is
| executed in win2000 or win98 works properly. But in
winXP
| an error windows is open closing the application.
|
| what should I check?
|
| Thanks
| Victor
|
| -----------------------------------------------
| Set wrkODBC = CreateWorkspac
| ("EspacioTrabajo", "Admin", "", dbUseODBC)
|
| Set db = wrkODBC.OpenConnection("ConexionName",
|
dbDriverNoPrompt,True, "ODBC;DATABASE=Master;UID=sa;pwd=;
| SN=" & Odbc)
|
| InstSql = "Select sysdatabases.* from sysdatabases WHERE
| name LIKE '" & IdentificadorBaseDatos & "%'"
|
| Set Rs = db.OpenRecordset(InstSql, dbOpenSnapshot,
| dbExecDirect)
| ------------------------------------------------
|
|
..
This mail is answering to the attached mail (see the last
part), to add more information of the problem. This
information have been answered on the old mail but I have
not received response.
I tryed with the DBEngine but the error it is the same.
I installed 3 days ago the MDAC 2.7 without results.
I have checked the system and I have the msjet40.dll sp6
(4.0.6218.0). Should I install the SP3 for access97? or
shoul I install the sp8?. Does access97 use msjet40?
It is opened the typical errror windows saying Microsoft
have detected a problem and it must be closed (translation
of spanish):
AppName: msaccess.exe
AppVer: 8.0.0.3512 ModName:dao350.dll
ModVer: 3.511608.0
Offset:00016216
I have installed the office xp and after that, the code
works without problems.
After remove the office xp, the code continues working
very well.
Thanks,
Victor
----------------------------------------------------
Hi Victor,
Based on your message, I have some suggestions:
1. Try to use DBEngine.CreateWorkspace instead of
CreateWorkspace
2. There could be some COM object files registered
improperly or not
registered at all. You can download the latest MDAC from
http://www.microsoft.com/data and install it on the
Windows XP computer.
Additionally, since you are using DAO, you need to
download Jet 4.0 SP3 or
later from that web link as well. Install Jet 4.0 SP3 or
later on the
problematic WinXP machine.
How To: Obtain the Latest Service Pack for the Microsoft
Jet 4.0 Database
Engine
http://support.microsoft.com/?id=239114
In adtion, is there any error message you received?
Please feel free to reply to the threads if you have any
concerns or
questions.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and
confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Victor" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| I have a access application (ACCESS97) working as client
| of a SQL Server 2000.
| The following vb code gets the name of the bases in the
| SQL Server that start with some letters included in the
| variable 'IdentificadorBaseDatos'. When this code is
| executed in win2000 or win98 works properly. But in
winXP
| an error windows is open closing the application.
|
| what should I check?
|
| Thanks
| Victor
|
| -----------------------------------------------
| Set wrkODBC = CreateWorkspac
| ("EspacioTrabajo", "Admin", "", dbUseODBC)
|
| Set db = wrkODBC.OpenConnection("ConexionName",
|
dbDriverNoPrompt,True, "ODBC;DATABASE=Master;UID=sa;pwd=;
| SN=" & Odbc)
|
| InstSql = "Select sysdatabases.* from sysdatabases WHERE
| name LIKE '" & IdentificadorBaseDatos & "%'"
|
| Set Rs = db.OpenRecordset(InstSql, dbOpenSnapshot,
| dbExecDirect)
| ------------------------------------------------
|
|
..