GregoryWest
Registered User.
- Local time
- Today, 01:38
- Joined
- Apr 13, 2014
- Messages
- 161
What I would like to do is code my VBA so that it is as installation independent as possible. Right now the FE is Access 2013, and I would like the BE to be any one of Access 2013, MySQL, Postgresql, SQLServer, Oracle, DB2. Is there a way I can keep 99% of the installation specific code in the ODBC creation?
The end goal, is to take my code, put it in its directory set up the ODBC link to what ever BE database server and DB. Run the program, have it create all the required tabled, indexes and views automatically. Also have the updates to the program automatically update the DB schema as required. I do not need help with the actual SQL to update the schema, but more how do I write code so that the program does not need to know things like the URL/IP of the DB server etc.
The end goal, is to take my code, put it in its directory set up the ODBC link to what ever BE database server and DB. Run the program, have it create all the required tabled, indexes and views automatically. Also have the updates to the program automatically update the DB schema as required. I do not need help with the actual SQL to update the schema, but more how do I write code so that the program does not need to know things like the URL/IP of the DB server etc.