[AccessD] Linking to a Dbase File

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





More information about the AccessD mailing list