Have you looked at the ADO connection method?
oneillci <[EMAIL PROTECTED]> wrote:
oneillci <[EMAIL PROTECTED]> wrote:
Hi,
I have an Access 2000 application that links to a MS Sql Server database.
I don't want to use an ODBC connection to connect to the database. Is
there any way in Access to connect to the database using a connection
string and VBA code and not an ODBC connection that has to be set up?
Where would I have to put that code - at the top of each form?
All input is appreciated.
Thanks,
Ciaran
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access training |
| Microsoft access training course | Microsoft access programming | Microsoft access tutorial |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
