Packaging with ADO Controls

[Qamgine]

I have a program that contains an ADO DSN. I am trying to have the program on a server so that anyone on the network can run it directly from the server.

It uses an access database that I want stored on the server, but want everyone in the company to have access to via my program. I used ADO control and build a dsn connection string.

When I try to access the dsn by loading a form from a network pc I get file not found and a recordset error.

Any help is appreciated.

 

[Qamgine]

Never mind, I figured it out.

What I was trying to do was use the custom build to build the connection strings, when it should be done in the code using app.path instead of hardcoded paths.