New Access Database template

I have already blogged about new database template in Access, but original post on team blog was gone (thanks to my reader motioning this!). Jeff Conrad has it in his Access 2007 FAQ. The idea is: if you want to have new database created with predefined settings – you can make a Blank.accdb database and put it in Program Files\Microsoft Office\Templates\1033\Access.

And one more link to Office online article: Create a custom blank template.

Same applies to Access 2010.

Relink password-protected database

If you need a function to relink Access tables – there is a good-old Relink Access tables from code. And if your backend database is password-protected you have to modify 2 lines in this procedure to supply password.

Declare password:

Public Const cPassword As String = "MyPassword"

Open database:

Set dbLink = DBEngine(0).OpenDatabase(strDBPath)

Replace with:

Set dbLink = DBEngine(0).OpenDatabase(strDBPath, False, True, ";pwd=" & cPassword)

Set Connect property:

.Connect = ";Database=" & strDBPath

Replace with

.Connect = ";Database=" & strDBPath & ";PWD=" & cPassword

Using Terminal Services with Access applications

A good article from FMS: Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet