Andy Davies wrote:
> try:
> Provider="Microsoft.Jet.OLEDB.4.0";Driver={Microsoft Access Driver
> (*.mdb)};Dbq=C:\downloads\timeclock\data\arx_active.mdb;Uid=Admin;Pwd=;")
>
>
Tried this below, but it fails with AERROR reporting: "[Microsoft][ODBC
Driver Manager] Data source name not found and no default driver specified"
i =
SQLSTRINGCONNECT([Provider="Microsoft.Jet.OLEDB.4.0";Driver={Microsoft
Access
Driver(*.mdb)};Dbq=C:\downloads\timeclock\data\arx_active.mdb;Uid=Admin;Pwd=;])
I'm trying to go with a DSNless connection so that SQLSTRINGCONNECT can
be all that I need and no configuring anything special on the client PC.
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
