Linking MS Access front-end to the back-end

Discussion in 'Databases' started by magnet-man, Apr 22, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. magnet-man

    magnet-man

    I have an Access database that has a front-end for forms and reports and a back-end for the tables. I have loaded the backend at \_database\route.mdb with a DSN of goldenbeequ_route. How do I link my front end to the backend on discountasp.net? The front-end will reside on my office computer. I have run into a brick wall.

    Post Edited (magnet-man) : 4/22/2005 9:47:30 PM GMT
     
    magnet-man, Apr 22, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    this is not possible.

    MS Access is designed to be a desktop database and you cannot connect to it over the Internet.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Apr 22, 2005
    #2
  3. magnet-man

    magnet-man

    Buce what if I change the back-end to sql?
     
    magnet-man, Apr 25, 2005
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    there are many ways to do that,

    you can consider using MS SQL upsizing wizard which comes with MS Access.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Apr 25, 2005
    #4
  5. magnet-man

    magnet-man

    Bruce, so if i change the back-end to sql, I should be able to keep my current front-end in access with a few minor changes. Is this correct?
     
    magnet-man, Apr 25, 2005
    #5
  6. Bruce

    Bruce DiscountASP.NET Staff

    no. not really.

    you probably need a real significant change to your access database to link to SQL server.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Apr 25, 2005
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page