John W. Colby
jwcolby at colbyconsulting.com
Mon Apr 4 18:17:40 CDT 2005
Rocky, Understanding the answer to this question requires understanding that JET runs on the workstation, NOT the server. JET knows how to ask for pieces of a file (an MDA/E/B) and any file server that can be used with Windows knows how to open a file and return a piece of that file. That is really all that the "server" does with an Access MDB BE. Jet, running on the workstation says "Hmmm.... It seems I need 3,940 bytes of data starting at offset 3,487,128", which is exactly what it tells the file server - "please open the file "MyBE.MDB", move to location 3,487,128 and return the next 3,940 bytes". JET knows that the data it asked for is 100 records from table X. All the server knows is that someone (some program) asked for X bytes starting at location Y in file Z. More or less of course. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Monday, April 04, 2005 10:33 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Can you run an mdb back end on Linux? Dear List: Can you run an mdb back end on a Linux-based server with WinXP on the clients? MTIA Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com