Jim Dettman
jimdettman at earthlink.net
Mon Jul 12 13:30:30 CDT 2004
John, <<When you open an Access DB, over a network, does it pull the whole DB over, or does it just open it, until the data is needed?>> Opens it and pulls data as needed. If Access/JET (MDB) all data is processed on the client side. Server acts only as a file sharing device. If ADP, data is processed on the server and only the result set is returned. <<They are trying to run this between offices, which are about 25 miles apart.>> Not a good thing to do if Access/JET. JET was designed for LANs, not WANs. Your asking for trouble. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark Sent: Monday, July 12, 2004 2:02 PM To: accessd at databaseadvisors.com Subject: [AccessD] Access over network When you open an Access DB, over a network, does it pull the whole DB over, or does it just open it, until the data is needed? This has been coming up quite a bit lately. Not so much for my programs, but for 'other' stuff. For instance we currently have an imaging program, which has a Access DB behind it. They are trying to run this between offices, which are about 25 miles apart. Thanks John W Clark -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com