How to use currentDB instance with Microsoft access project

  • Thread starter Thread starter Pham Huu Hoa
  • Start date Start date
P

Pham Huu Hoa

Dear Sir/Madam

I have a small software that I developed 3 year ago, and
then, now I want to upgrade it to Microsoft Access Project
but the problem is that I have to change a lot of code in
module. my modules use CurrentDB variant of DAO to access
current database. But they don't work with Access Project.

Please help me to reuse it, How can I use CurrentDB
instance in Microsoft Project.

I am look forward your reply.

Best Regards
Pham Huu Hoa
 
Set a reference to DAO. From the VB Edit window, click Tools - References,
then find and select DAO.
 
You for all intensive purposes have to upgrade your recordset code from DAO
to ADO.

You can't use the JET engine (DAO) with a ADP project, and it would not make
sense to do so.

In a ADP project there is not a currentDB object as such. All temp tables,
and record operations occur on the server side.

So, either you dump the use of the ADP project, and use ODBC via linked
tables to the server, or your change your DAO recordset code to ADO.

You could try and actually set a reference to the DAO 3.6 Object library,
but you cannot use current db to establish a connection to a remote sql
server. You have to set up DSN and build your dao connection object. You
can also code a DAO object with a DSN-less connection, but really, you want
in this case to move that code to ADO (since then you can use a connection
object).

If you must keep all that old DAO code, then you *can* use currentdb and DAO
reocrdsets if you used linked tables to sql server in place of NOT using a
ADP project.
 
Back
Top