Skip to main content
Participant
May 5, 2021
Answered

Help Connecting to My Access database

  • May 5, 2021
  • 1 reply
  • 526 views

Forgive me if this has been asked a ton already. I have not used Dreamweaver in years but am trying to boot up an old sites that connects to an access db. I installed the database extension (still not sure why that was removed) and while it does show my connection file, when I expand it it accesses nothing. The tables menu is blank. I am trying to use a user DSN like I did in the old days but cannot get it to connect.

 

Any advice on if I am missing a new way of connecting to my access db or what I may be missing? 

Thanks!

    This topic has been closed for replies.
    Correct answer Nancy OShea

    Access db is woefully inefficient and not suitable for use the web.  Sorry.

    Use server-side data like MsSQL,  MySQL, Maria or even a JSON data file.  But don't attempt to use Access. 

     

    1 reply

    Nancy OShea
    Community Expert
    Nancy OSheaCommunity ExpertCorrect answer
    Community Expert
    May 5, 2021

    Access db is woefully inefficient and not suitable for use the web.  Sorry.

    Use server-side data like MsSQL,  MySQL, Maria or even a JSON data file.  But don't attempt to use Access. 

     

    Nancy O'Shea— Product User & Community Expert
    strategypAuthor
    Participant
    May 5, 2021

    Thank you for that. Haha any interest in letting me hire you to convert my access file to SQL and helping me establish the proper connections on my winhost account? 🙂

    Nancy OShea
    Community Expert
    Community Expert
    May 5, 2021
    Nancy O'Shea— Product User & Community Expert