ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open database from Excel (https://www.excelbanter.com/excel-programming/315740-open-database-excel.html)

José

Open database from Excel
 
I have a module where I open an access97 database and it works fine. Im
using the following code:

Dim DB As DAO.Database, RS As DAO.Recordset, strSQL As String
Set DB = DBEngine(0).OpenDatabase("C:\db1.mde", False, False)

At the moment I covert this database to access2002 and this code doesnt
work. Whats happened?
Please I need help
José


Myrna Larson

Open database from Excel
 
Have you asked your question in the Access groups? You might get a better
answer there.

On Wed, 3 Nov 2004 22:33:09 -0800, "José"
wrote:

I have a module where I open an access97 database and it works fine. I’m
using the following code:

Dim DB As DAO.Database, RS As DAO.Recordset, strSQL As String
Set DB = DBEngine(0).OpenDatabase("C:\db1.mde", False, False)

At the moment I covert this database to access2002 and this code doesn’t
work. What’s happened?
Please I need help
José




All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com