G
Guest
I have an app I am converting from an MDE to an ADE. The app is split into a
front end executable (.mde) placed on multiple clients. Each is linked to a
jet database (.mdb) on a server. To allow for differing database locations
when deploying to customer sites, I have a 'relinking' function that uses DAO
to interrogate and adjust the connection string in each tabledef.
A frequent need I encounter is to link to different databases depending on
the network a client happens to be connected to. My customers work in
multiple school districts, all using my software but each having their own
database and specific pathing to it. It would also be a benefit to me if I
could allow a user to work in a local database from home and then connect to
a school database when at work. I have facility for transferring data via
diskettes or other media.
I am converting the database from Jet to MSDE/SQL Server. I am converting
the executable to use ADO instead of the predominant use of DAO in the
current version.
I need an ADO replacement for the relinking function...or...a reasonable way
to change the currentproject.connection from one thing to another. I need
this because I have to adjust the connection when installing a site. I would
like it for the other reasons I stated. I don't think the File>Connection
menu function is available because a) I deploy using the runtime version of
Access, b) I don't ship source, I will deploy a compiled .ade and c) I have a
lot of clients who could never correctly adjust the connection anyway.
Is there a way to build this app without an implied connection to any
database and then set the currentproject.connection to a specific value when
the application is loaded? I think I need to be able to do this so I can
continue to use bound forms. I know I can open whatever connection I like, I
just don't know how to cause that connection to be the one assumed by the
application. Is there a way to adjust the connection strings in each table
like I have been doing with the DAO model?
As always, any and all help will be appreciated!
Thanks,
Jerry
front end executable (.mde) placed on multiple clients. Each is linked to a
jet database (.mdb) on a server. To allow for differing database locations
when deploying to customer sites, I have a 'relinking' function that uses DAO
to interrogate and adjust the connection string in each tabledef.
A frequent need I encounter is to link to different databases depending on
the network a client happens to be connected to. My customers work in
multiple school districts, all using my software but each having their own
database and specific pathing to it. It would also be a benefit to me if I
could allow a user to work in a local database from home and then connect to
a school database when at work. I have facility for transferring data via
diskettes or other media.
I am converting the database from Jet to MSDE/SQL Server. I am converting
the executable to use ADO instead of the predominant use of DAO in the
current version.
I need an ADO replacement for the relinking function...or...a reasonable way
to change the currentproject.connection from one thing to another. I need
this because I have to adjust the connection when installing a site. I would
like it for the other reasons I stated. I don't think the File>Connection
menu function is available because a) I deploy using the runtime version of
Access, b) I don't ship source, I will deploy a compiled .ade and c) I have a
lot of clients who could never correctly adjust the connection anyway.
Is there a way to build this app without an implied connection to any
database and then set the currentproject.connection to a specific value when
the application is loaded? I think I need to be able to do this so I can
continue to use bound forms. I know I can open whatever connection I like, I
just don't know how to cause that connection to be the one assumed by the
application. Is there a way to adjust the connection strings in each table
like I have been doing with the DAO model?
As always, any and all help will be appreciated!
Thanks,
Jerry