Access Project with local MDB

[CylonLove4Life]

Is there anyway I can convert my MDB to an Access Project, but still reference some tables stored locally, in MDB's?

Also, what is the command to convert an MDB into an Access Project?

 

[danvlas]

Access Project works natively ONLY with SQL Server, not with Access (Jet) databases.

You can work with other databases via ADO connections, recordsets and commands. But not the way you're accustomed with in Access Mdbs.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[CylonLove4Life]

Thanks.

Do you mean that I can issue SQL Queries using ADO - even to a local MDB - just that I can't use bound controls and the like?

(My objective is to speed up a legacy Access database. The Access database is now being used as a front end to SQL Server, but keeps some temporary data in local MDB. I thought that converting it to an ADP might speed things up, as the connections to SQL Server currently are not persistent.)