MS Access - Project Macro

[Phil_b]

I have recently made a database and through MS Development Tools have been able to bundle it with Access Runtime. We are using MSDE as a backend and when I install the 'package' created by MS Project on another computer it says that it cannot find the SQL Server database.

This will mean (i believe) I will have to write a macro to reference the external SQL database (MSDE)?

If anyone has knowledge of this or/ and can point me in the right direction it would be appreciated.

Phil

 

[daherb]

you might want to add this post to the macro section of the site

 

[Phil_b]

I thought that but Im not sure I even need a macro. My knowledge of how to make a runtime project that has been distributed connect to a remote SQL database is not something im familier with.

My question is pretty general (so I put it here) as I dont know of any specific solution.

 

[Pat Hartman]

I haven't done this so I can't give you specifics, but you would need to tell the packaging wizard that it needed to also include MSDE as part of the installation. MSDE is not installed by default.