Query Access97 to 2010


Ad

Advertisements

C

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/tutorials/aspnet/2be6a5b6-6b81-4e78-ad8b-dcee506e7531/migrating-to-vsnet-2003.aspx
 
Ad

Advertisements

C

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/tutorials/aspnet/db8e1051-8670-4f43-91db-3ca180f5bfdb/web-service-vs-web-worksp.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top