Donna Martin wrote: > In the newer versions, Access can > be locked at the record level, and does not effect changes made to > other records within the same table.
*If you are using the oledb driver with the correct settings, IIRC. Of course, that doesn't prevent something else from connecting to it with the wrong settings and locking on the page level. > Also, it can be set to compress > on close Can this be done with a database that is only accessed through ODBC or OLEDB? I would think that this is only something that could be set in the Access application. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4