an ODBC front end deployment

[ajetrumpet]

has anyone ever tried to deploy a package to someone that was to serve as a front end only to another ODBC source? i would like to try and distribute one single access database to my users where they can connect to the mysql backend and simply work with their data and the like this way.

i have another thread started in the web dev. forum here because i can't seem to get mysql tables linked through the link manager, but one thing i was wondering here about what i want to do is if these connections can even be established through code and ADO methods (possibly).

I guess the question is: can you connect to mysql and link the remote tables to the access database entirely with vb code? it would not make much sense to deploy an access solution to a user, and simply provide them with instructions (and thus login information for the remote db) whereby they have to set the connection and links manually. that would not make much sense, and it would be too confusing for them.


obviously i am new to the mysql connection thing, so if anyone has some BASIC articles on how to establish simple connections and using access as a front end i would appreciate the links. thanks all!!!

 

[DCrake]

Adam
If I can dig it out I have an app that lets the user view/connect to an existing DNS or create one on the fly to use laterly. If this is what you are looking for let me know.

 

[Banana]

Yeah -

When I deployed the application, I used an Install Creator package (there's also other free Installer programs) to package MySQL's ODBC driver & Access application so when the users installs it, it'd also install MySQL's ODBC driver (which is required on all client machine), while the application itself used DNS-less connections so I don't have to worry about setting up DSN or maintaining it as well.

 

[ajetrumpet]

Adam
If I can dig it out I have an app that lets the user view/connect to an existing DNS or create one on the fly to use laterly. If this is what you are looking for let me know.

i think that's exactly what im looking for. if you could get that to me, would be great!

 

[DCrake]

Will be tomorrow when I am in my other office. I know I have it in VB but it will be easy to convert to Access.