MB Software Solutions wrote:
> (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
>
I did a "CD C:\downloads\timeclock\data" prior to my SQLEXEC above and
it works great then.....but why should I have to change directory to
that folder? Weird. I guess I can work around this if I must. It's
just kinda silly/kludgey, imo.
--
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.
