Access database source connection

Question

Hello, i made a Access database connection with a source from access file from my desktop. What i need is to change source from desktop to dataset that i have on form, any suggestion?

Answer 1

Hello,

Okay what I have should work with a .mdb but have not worked with them in about 20 years, moved to .accdb and stopped with MS-Access accept for forum questions. With that in mind you might be able to get what you want from the a code sample in one of my GitHub repositories.

Login form

Main form

Loaded data from MS-Access into a ListBox, could also be any control you care for.

To download the three projects where one has an encrypted database so that if outside of the app a password is still needed.

Download instructions

• Make sure to have the current version of GIT.
• Create a temp folder e.g. C:\GitTemp
• Create a batch file, insert the commands below
• Run the bat file
• Three projects are downloaded to place into your Visual Studio solution.

  Batch file

  mkdir code
  cd code
  git init
  git remote add -f origin https://github.com/karenpayneoregon/WorkingWithAccessDatabases
  git sparse-checkout init --cone
  git sparse-checkout add ConfigurationLibrary_vb
  git sparse-checkout add LoginFrontEnd
  git sparse-checkout add LoginLibrary
  git pull origin master
  :clean-up
  del .gitattributes
  del .gitignore
  del .yml
  del .editorconfig
  del *.md
  del *.sln

That's all I have.