> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of MB Software Solutions > Sent: Wednesday, February 07, 2007 5:37 AM > To: [EMAIL PROTECTED] > Subject: Problem accessing Access 2K table from VFP9SP1 > > (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!" >
Michael: I don't see anything wrong, but when I have used ODBC with Access tables I remember some slight differences in the SELECT syntax. I would look to see if the syntax of your SELECT works in Access. Someone can correct me if I'm wrong, but the SELECT statement should be an Access statement and not necessarily a VFP statement. There are some differences. At least that's my recollection of when I did an application that worked with Access tables. Jeff Jeff Johnson [EMAIL PROTECTED] 623-582-0323 Fax 623-869-0675 --- StripMime Report -- processed MIME parts --- multipart/signed text/plain (text body -- kept) application/x-pkcs7-signature --- _______________________________________________ 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.
