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
