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
>
Longshot - do you have a local setting that might be overriding your
code i.e. something in ODBC/System or something like that?
p.s. The SQL code looks fine...
Let me try it with my own Access tables and see what happens...
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
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.
