Geoff Flight wrote: > I would like to read the access tables using the SQLSTRINGCONNECT function, > however getting a connection string to work has eluded me. Being a relative > newbie to doing such things I wonder if some of you kind folk can point me > in the direction of a solution that does not include a DSN and help me > construct a elegant, working connection string.
I think SQLSTRINGCONNECT() is your ticket. However, I also thought I'd mention that there are different levels of DSN, not just system DSN which does require an admin to install. A user can install a user DSN (only installs for that user), and there's also a file DSN that I believe the user can run. If you go that route, change the name of the dsn so you are certain that you are loading the DSN you intend. Paul _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
