Query Access97 to 2010

[Charlie Joe]

In Access 97 queries like -db execute ("any order")- are running very well, however same queries don't want to work in Access 2007-2010.
Any help, please ?



Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Multipart MIME Encoding Library using CDO
http://www.eggheadcafe.com/tutorial...a3-c383a737d43f/c-multipart-mime-encodin.aspx

 

[Charlie Joe]

Sorry, queries are from VB6, ADO, Aceess 2010
Thanks



Charlie Joe wrote:

Query Access97 to 2010
15-Jan-10

In Access 97 queries like -db execute ("any order")- are running very well, however same queries don't want to work in Access 2007-2010.
Any help, please ?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Migrating to VS.NET 2003: A Developer Perspective
http://www.eggheadcafe.com/tutorial...d8b-dcee506e7531/migrating-to-vsnet-2003.aspx

 

[Douglas J. Steele]

Access 97 used DAO 3.5.

Access 2010 uses DAO 4.0 if the database is an MDB, or the Microsoft Office
12.0 Access database engine if it's an ACCDB. Use the same connection
strings as for Access 2007, as shown at
http://www.connectionstrings.com/access-2007

 

[Charlie Joe]

Sorry, Doug, wrong answer, I know all your info.
Next it's my VB6 code:

Dim xDB As New ADODB.Connection, table as string
'OpenDB() in modADO.bas working together with clsADOConnect.cls
Call OpenDB(xDB, True, DataBase)
table = "s_ib"
xDB.Execute "Delete from " & tabla
table = "s_ibx"
xDB.Execute "Delete from " & table
'Here give error
xDB.Execute ("AddIBx")
xDB.Close: Set xDB = Nothing

AddIBx it's the query, located in Access
This query running fine with access97 !





Douglas J. Steele wrote:

Access 97 used DAO 3.5.Access 2010 uses DAO 4.
15-Jan-10

Access 97 used DAO 3.5

Access 2010 uses DAO 4.0 if the database is an MDB, or the Microsoft Offic
12.0 Access database engine if it is an ACCDB. Use the same connectio
strings as for Access 2007, as shown a
http://www.connectionstrings.com/access-200

-
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(no e-mails, please!)

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Web Service vs Web Workspace Part I
http://www.eggheadcafe.com/tutorial...b-3ca180f5bfdb/web-service-vs-web-worksp.aspx