The intranet uses one of 2 .mdb's as a recordsource. The ODBC connection has to be manually switched to point at the .mdb for the day. They are alternated because they need to be compacted & repaired daily, and something about the intranet connection causes an .ldb to be open all the time, so it's not possible to c & r the one that is the current ODBC connection. This is using A97 and Windows NT 3.51.
The question: I would like to automate this whole process. I know how to automate the c & r, etc., but have no idea how to change the ODBC connection. Presumably this involves an API call or, worse, writing something in C++? Which I don't know at all.
Can anybody help with this? Thanks!
The question: I would like to automate this whole process. I know how to automate the c & r, etc., but have no idea how to change the ODBC connection. Presumably this involves an API call or, worse, writing something in C++? Which I don't know at all.
Can anybody help with this? Thanks!