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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/