Lawrence Mrazek
lmrazek at lcm-res.com
Wed May 2 16:30:38 CDT 2007
Thanks Jim. Good idea regarding the snapshot query. I haven't had much experience working with dbase, other than straight imports and I'm a bit leary of messing something up! Larry Mrazek LCM Research, Inc. www.lcm-res.com lmrazek at lcm-res.com ph. 314-432-5886 mobile: 314-496-1645 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, May 02, 2007 3:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Linking to a Dbase File AFAIK, simply linking to a table will not cause corruptions. May I suggest however that you immediately create a QUERY that pulls the fields needed (or the whole table for that matter) and then set the Recordset Type property of the query to Snapshot. A snapshot is a read-only recordset and going through a query that is set to snapshot will absolutely prevent any write backs to the data table, at least for anything using that query. There are "corruptions" and then there are inadvertent writes which are, of course also "corruptions". A snapshot query will prevent the second type of corruption. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek Sent: Wednesday, May 02, 2007 4:30 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Linking to a Dbase File Hi: Can simply linking to a Dbase table cause corruption on the dbase table? All I need to do is query the table, no adds/updates or deletes. (I'll have to join the table with a local Access table, that's all). Anyone have any experience with this, or any tips? I can read the dbase file using oledb, but then I can't join it to the local Access table. Thanks in advance. Larry Mrazek LCM Research, Inc. www.lcm-res.com lmrazek at lcm-res.com ph. 314-432-5886 mobile: 314-496-1645 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com