accessblog (![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small} accessblog) wrote,@ 2009-10-29 16:10:00 |
|
How to relink Access tables faster
When you run relink procedure at application startup, and backend file is located on the network – the process can be much slower then relinking local file, even with very fast network. The trick is to open backend file before relink process and close it after. Sample code:
Dim dbData As DAO.Database
Set dbData = DBEngine.OpenDatabase(strFileName)
'Relink proc follows
...
dbData.Close
Set dbData = Nothing
