Jim Lawrence
accessd at shaw.ca
Fri May 22 12:28:50 CDT 2009
Hi Gustav: My first major conversion project was over 10 years ago when a client was trying to get some decent performance out of an Access/Oracle application. They were initially using the query/link/pass-through technology and they had all but given up on the project... I tried out the ADO-OLE method and had stellar results. I did briefly work with ODBC but found that unless the application was supported locally it was too difficult to try and get a client to install the driver... through the phone or via email. On the other hand ADO, with its remote capabilities, is built in to all Windows systems. Hardware Performance has dramatically improved in the last 10 plus years so some of the issues of the past are irrelevant now but I have never looked back. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, May 22, 2009 12:29 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Linked to SQL Server in a domain Hi Jim That is not my experience. We had several apps running at clients for years using A97, ODBC and the SQL Server prior to 2000 (version 7? Can't remember) without a single issue. So at least in some cases ODBC works. /gustav >>> accessd at shaw.ca 22-05-2009 07:00 >>> Hi John: I have been working with MS Access to ADO-OLE to MS SQL/Oracle DBs since 1997 and Access does not work with ODBC. There is a simple and stupid way to up date an old Access MDB to a MS SQL BE using connection/links. This system actually works fine for delete, add and update... but as soon as you start grabbing recordsets of data for reports, subforms or start rolling out a new application to a remote desktops the whole system grinds to a halt. At that point you have reached the end of the usefulness of the ODBC connections. Unfortunately there is no short cut, the client and you just have to bite the bullet and go straight ADO-OLE... It is not that difficult but the nice gui interface within Access can not do it. Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com