Access database source connection

DRGAGI 146 Reputation points
2020-12-15T20:50:30.587+00:00

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?
48454-snap1.jpg

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,725 questions
{count} votes

6 answers

Sort by: Most helpful
  1. Karen Payne MVP 35,421 Reputation points
    2020-12-15T22:01:16.24+00:00

    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

    48512-a1.png

    Main form

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

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.