how can I reference the My Documents folder in a database connection string in VB 2008?

I am building a VB 2008 application that interfaces with a MS Access
database. I wish to change the connection string so It looks in the user’s My Documents folder rather than the current directory.

The problem is that the My Documents directory will be in a different place depending on the user’s OS and setup. Is there a way to code the connection string so that it goes to the my documents directory wherever it may be?

connectionString=”Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|\studentSurvey.accdb”

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Tags:

This entry was posted on Tuesday, March 30th, 2010 at 3:35 pm and is filed under Connection string. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

«
»

One Response to “how can I reference the My Documents folder in a database connection string in VB 2008?”

  1. Kevin Says: April 16th, 2010 at 8:21 pm

    Doing a quick Google search using the following keywords will give you all sorts of good URLs for information:

    VB 2008 “My Documents” folder

    And here are a few links to start you off with:

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.vb.database&tid=016a74cc-ec8c-4a37-8f54-3ed9e5f5f8e3&cat=&lang=&cr=&sloc=&p=1

    http://dotnetref.blogspot.com/2008/05/finding-my-documents-folder-in-vbnet.html

    http://www.thescarms.com/dotnet/SpecialFolders.aspx

    http://www.developerfusion.com/code/251/special-folder-paths/

    .

Leave a Reply

 
About - Contact - Privacy Policy - Terms of Service