ADP -> MDB?

[mkrausnick]

I inherited a small Access application in ADP format. Now the boss wants to evaluate the application for use in a different environment. In her brain, it's "copy the application to a CD so I can look at it at home". Not so easy with a SQL Server back end.

I've DTS'ed the database into an MDB, but I can't connect the MDB back end to the ADP front end. I gather from reading other posts here that ADP supports only a SQL Server back end. So the question is, can I / how do I convert the ADP front end into an MDB front end so I can link it to the MDB back end?

I apologize if this is a dumb question, but I don't do too much Access.

Thanks,

Mike Krausnick
Dublin, California

 

[danvlas]

You could install SQL Express or MSDE on your boss's computer and place a copy of the database there.
Then, change the connection and let her play...

HTH


Daniel Vlas
Systems Consultant

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