error in winXP

  • Thread starter Thread starter Victor
  • Start date Start date
V

Victor

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)
------------------------------------------------
 
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)
| ------------------------------------------------
|
|
 
Hi Alick,

I answered 8 hours ago but now I repeat because I don´t
see my message in the newgroup.

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?

Victor
-----Original Message-----
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",
|
Click to expand...
dbDriverNoPrompt,True, "ODBC;DATABASE=Master;UID=sa;pwd=;
 
I am sorry. I forgot say you about the error.
It is open 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

Regards
 
Hi Alick,

Other time to give you more information:

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.

Could you know what was the change?

Thanks,
Victor
-----Original Message-----
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",
|
Click to expand...
dbDriverNoPrompt,True, "ODBC;DATABASE=Master;UID=sa;pwd=;
 
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]>
| Sender: "Victor" <[email protected]>
|
| Hi Alick,
|
| Other time to give you more information:
|
| 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.
|
| Could you know what was the change?
|
| Thanks,
| Victor
|
| >-----Original Message-----
| >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)
| >| ------------------------------------------------
| >|
| >|
| >
| >.
| >
|
 
Back
Top