(This is probably an easy one for most of you...I hope!)
I'm trying to simply read data from Access tables. I verify that i
establish a connection to the MDB, yet the SQLEXEC fails, and when I
look at AERROR() it seems to be looking for the MDB file in the current
directory rather than what's specified in the connection string.
Here's my code:
i = SQLSTRINGCONNECT("Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\downloads\timeclock\data\arx_active.mdb;Uid=Admin;Pwd=;")
WAIT WINDOW i
WAIT WINDOW SQLEXEC(i,"select Firstname,MI,Lastname from
arx_active.Employees")
What am I doing wrong? Thx...
--Mike
--
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: [email protected]
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.
