Skip to main content
Participant
May 5, 2021 8:38 PM UTC
Answered

Help Connecting to My Access database

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 is closed to new replies. Start a new post to keep the conversation going.
    Nancy OShea
    Nancy OSheaCorrect answer
    Community Expert
    May 5, 2021 9:21 PM UTC

    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

    3 replies

    Nancy OShea
    Community Expert
    Nancy OSheaCommunity ExpertCorrect answer
    Community Expert
    May 5, 2021 9:21 PM UTC

    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. 

     

    Translate
    Nancy O'Shea— Product User & Community Expert
    strategypAuthor
    Participant
    May 5, 2021 10:01 PM UTC

    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? 🙂

    Translate
    Nancy OShea
    Community Expert
    Community Expert
    May 5, 2021 10:55 PM UTC
    Nancy O'Shea— Product User & Community Expert