By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

MS Access, locking linked txt-files..

P: 1
Hi,

I have an application in MS Access 2000 (using DAO 3.6) in which a table is linked to a text-file.

As I use

set rs = db.OpenRecordset("text-file-table")

it completely locks the text-file. I also cannot access it from Explorer.
It means I have to close the connection each time to let others access it:

rs.close

Normal MSAccess tables do not require the close-command.
Opening and closing the connection each time greatly slows down the application, as it is used by several users on a network.

(great link on performance-updates for MSA:
http://www.granite.ab.ca/access/performancefaq.htm )

Thanks!
Klaas
May 24 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.