Is there a way I can used the connection string that the ADO connection string created for me?
This is the code which I connect to an MS Access database:
Connection String: DBQ=C:\Retail4\Fred's Fishing
Store\recent.mdb;DefaultDir=C:\Retail4\Fred's Fishing Store;Driver=
{Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS
Access;FILEDSN=C:\FFStore\Data\Retail
Manager.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;PWD=freds108;
SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;
I use ADO Connection, then I choose connection String, build and selected MS OLE DB Provider for ODBC Driver, next data link comes out select again connection string, then build again, created a DSN....very tedious work compared to creating connection to a sql server database.....
I can run query, browse the tables at the data explorer, but I want to use the tables on form using the connection string. Does anyone know how to do this? Or do I need to used the SQLCONNECT() or SQLSTRINGCONNECT() functions?
Thanks...