Every week I am telling people that I am very excited about this new version of Microsoft Access 2007. Excellent SharePoint integration! Being busy writing a couple of pages how to create a custom authentication provider for WSS/MOSS 2007 with MS Access as an example for storing your user accounts, I was looking for the connectionstring we have to use for accessing that new version and the new extension (accdb). First place I looked at was www.connectionstrings.com but these guys are not yet up-to-speed with all of this I think :). Then I remembered that you can simply create a .UDL file and double-click it going through a small dialog allowing you to create your connection information. Piece of cake .. if you open the UDL file you will see that the connectionstring for Microsoft Access 2007 accdb databases is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\work\users.accdb;Persist Security Info=False
Cool! Back to the writing.. Btw.. loved the past week in Sweden. In total about 100 participants to the two events. Great! Great! Great! SharePoint is really rocking and getting the attention of everybody. Thanks Eva and also Göran for the very nice evening out and interesting talk.