error en winXP

[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)
| ------------------------------------------------
|
|

..

 

[Alick [MSFT]]

Hi Victor,

It could be the Dao360.dll file was not properly registered on Windows XP
computer, when you install Office XP, it registered the file correctly and
then the application can use it normally. To manually register the file, we
can try:

In the start -> run box type:

regsvr32 "<path_to_dao>\dao360.dll"

Please feel free to reply to the threads if you have any questions or
concerns.



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
|
| 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)
| | ------------------------------------------------
| |
| |
|
| .
|
|
|

 

[Victor]

Hi Alic,

I am using Dao350.dll (3.51) because I remember to have
problem with the Dos360 with access97. is it true?. In any
case in the reference of access I have marked the Dao 3.51
and I had registered without better results.

Sincerely,
Victor

-----Original Message-----
Hi Victor,

It could be the Dao360.dll file was not properly registered on Windows XP
computer, when you install Office XP, it registered the file correctly and
then the application can use it normally. To manually register the file, we
can try:

In the start -> run box type:

regsvr32 "<path_to_dao>\dao360.dll"

Please feel free to reply to the threads if you have any questions or
concerns.



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
|
| 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=;

 

[Alick [MSFT]]

Hi Victor,

I am not sure, however, it can be installing Office refreshed/re-registered
some component that helps to make the application work again. Access 97
uses DAO350.dll, DAO360.dll is for Access 2000, sorry for the confusion.

Please feel free to reply to the thread if you have any concern or question.


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
|
| Hi Alic,
|
| I am using Dao350.dll (3.51) because I remember to have
| problem with the Dos360 with access97. is it true?. In any
| case in the reference of access I have marked the Dao 3.51
| and I had registered without better results.
|
| Sincerely,
| Victor
|
| >-----Original Message-----
| >Hi Victor,
| >
| >It could be the Dao360.dll file was not properly
| registered on Windows XP
| >computer, when you install Office XP, it registered the
| file correctly and
| >then the application can use it normally. To manually
| register the file, we
| >can try:
| >
| >In the start -> run box type:
| >
| >regsvr32 "<path_to_dao>\dao360.dll"
| >
| >Please feel free to reply to the threads if you have any
| questions or
| >concerns.
| >
| >
| >
| >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
| >|
| >| 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)
| >| | ------------------------------------------------
| >| |
| >| |
| >|
| >| .
| >|
| >|
| >|
| >
| >.
| >
|

 

[Guest]

Alic,

Do you know what other components should I check the
register. As my application is for production in several
client computer, it is not a soluction to install office
xp in all of them and after that remove it.

Sinceraly,
Victor

-----Original Message-----
Hi Victor,

I am not sure, however, it can be installing Office refreshed/re-registered
some component that helps to make the application work again. Access 97
uses DAO350.dll, DAO360.dll is for Access 2000, sorry for the confusion.

Please feel free to reply to the thread if you have any concern or question.


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
|
| Hi Alic,
|
| I am using Dao350.dll (3.51) because I remember to have
| problem with the Dos360 with access97. is it true?. In any
| case in the reference of access I have marked the Dao 3.51
| and I had registered without better results.
|
| Sincerely,
| Victor
|
| >-----Original Message-----
| >Hi Victor,
| >
| >It could be the Dao360.dll file was not properly
| registered on Windows XP
| >computer, when you install Office XP, it registered the
| file correctly and
| >then the application can use it normally. To manually
| register the file, we
| >can try:
| >
| >In the start -> run box type:
| >
| >regsvr32 "<path_to_dao>\dao360.dll"
| >
| >Please feel free to reply to the threads if you have any
| questions or
| >concerns.
| >
| >
| >
| >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
| >|
| >| 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=;

 

[Alick [MSFT]]

Hi Victor,

For this issue, the first thing/component we need to check is the
dao350.dll registration.

Manually register the DAO360.DLL

1). Go to Start, Search, All Files and Folders, type regsvr32.exe in the
Search box. The file is located in Windows\system32 folder by default.

2). Bring up another Find box and search for the DAO350.dll file which is
located in Program Files\Common Files\Microsoft Shared\DAO folder by
default.

3). Drag the DAO350 file over on top of the REGSVR32 file to register it.

Or use command line:

regsvr32 "<path_to_dao>\dao350.dll"

Based on the error, there aren't other certain components we can check,
usually crashing issue may related to the whole system, sometimes it is
possible one process interferes the normal operation of the other process.
But for this issue, it is clear it is related to dao350.dll file, the first
thing we need to check is: make sure the file is registered properly and
the dll file is not corrupt (we can replace it with a fresh new one from
other working computer)

AppName: msaccess.exe
AppVer: 8.0.0.3512 ModName:dao350.dll
ModVer: 3.511608.0
Offset:00016216

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: <[email protected]>
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| Alic,
|
| Do you know what other components should I check the
| register. As my application is for production in several
| client computer, it is not a soluction to install office
| xp in all of them and after that remove it.
|
| Sinceraly,
| Victor
| >-----Original Message-----
| >Hi Victor,
| >
| >I am not sure, however, it can be installing Office
| refreshed/re-registered
| >some component that helps to make the application work
| again. Access 97
| >uses DAO350.dll, DAO360.dll is for Access 2000, sorry for
| the confusion.
| >
| >Please feel free to reply to the thread if you have any
| concern or question.
| >
| >
| >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
| >|
| >| Hi Alic,
| >|
| >| I am using Dao350.dll (3.51) because I remember to have
| >| problem with the Dos360 with access97. is it true?. In
| any
| >| case in the reference of access I have marked the Dao
| 3.51
| >| and I had registered without better results.
| >|
| >| Sincerely,
| >| Victor
| >|
| >| >-----Original Message-----
| >| >Hi Victor,
| >| >
| >| >It could be the Dao360.dll file was not properly
| >| registered on Windows XP
| >| >computer, when you install Office XP, it registered
| the
| >| file correctly and
| >| >then the application can use it normally. To manually
| >| register the file, we
| >| >can try:
| >| >
| >| >In the start -> run box type:
| >| >
| >| >regsvr32 "<path_to_dao>\dao360.dll"
| >| >
| >| >Please feel free to reply to the threads if you have
| any
| >| questions or
| >| >concerns.
| >| >
| >| >
| >| >
| >| >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
| >| >|
| >| >| 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)
| >| >| | ------------------------------------------------
| >| >| |
| >| >| |
| >| >|
| >| >| .
| >| >|
| >| >|
| >| >|
| >| >
| >| >.
| >| >
| >|
| >
| >.
| >
|