I
Ira
I created an application in MS Access using Pass Through Queries and
DNS free Logons to an ODBC MYSQL Database. I am modifying the QueryDef
to provide the parameters for my queries. I am also having the users
login at runtime and set the server, database, user and password pn the
fly for all linked tables abd pass through queries.
I figured out how to do everything. I have two problems:
1: Minor, I must put a copy of the application of each users computer
instead of allowing them to use a central copy on the server.
2. If I modify the pass-through queries using the QueryDef and modify
the login info, Microsoft puts up a nasty message telling the users a
virus had altered the program. I am signing the applications with a
Digital Certificate I generated myself using Selfcert. I cout set the
security to low but I do not want to do that.
Do you have any solutions to these problems. Is there a way to do this
without self-modifying the code, which is what I am doing. It seems
that there should be a better way of doing this but I have not found
anything.
DNS free Logons to an ODBC MYSQL Database. I am modifying the QueryDef
to provide the parameters for my queries. I am also having the users
login at runtime and set the server, database, user and password pn the
fly for all linked tables abd pass through queries.
I figured out how to do everything. I have two problems:
1: Minor, I must put a copy of the application of each users computer
instead of allowing them to use a central copy on the server.
2. If I modify the pass-through queries using the QueryDef and modify
the login info, Microsoft puts up a nasty message telling the users a
virus had altered the program. I am signing the applications with a
Digital Certificate I generated myself using Selfcert. I cout set the
security to low but I do not want to do that.
Do you have any solutions to these problems. Is there a way to do this
without self-modifying the code, which is what I am doing. It seems
that there should be a better way of doing this but I have not found
anything.