Linking to an access database hosted on asp for an application - Thanks

Discussion in 'Databases' started by Bruce, Feb 2, 2006.

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

    Bruce DiscountASP.NET Staff

    are you referring to a desktop application (on your local computer)? or a web application?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Feb 2, 2006
    #1
  2. Garyr

    Garyr

    Hi Bruce , thanks for responding, the application is a desktop application on my local PC

    Gary
     
    Garyr, Feb 2, 2006
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    You cannot connect to a remote MS Access database over the Internet.

    MS Access is designed to be a desktop database. It is not meant to be a database server that allows multiple connections.

    I suggest you consider either

    1) DOwnload the database to your local computer

    or

    2) upsize your database to MS SQL.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Feb 2, 2006
    #3
  4. Garyr

    Garyr

    Hi, new to the forum so any help would be appreciated,

    I have an application written in visual basic that access an access database via odbc, I have now uploaded the database to \_database\mydatabase.mdb using the ftp and all is fine, the database is there. My problem now is that I am trying to link the application to this hosted database, and I'm struggling..

    If anybody has some guidance that would be great.........

    Also if anyone knows thatan application that currently works fine via the normal odbc links to normal local/network drives , will NOT work when linked via ODBC to the hosted database that that would be good to hear (well not that great, becasue looking to host the database), to save me wasting time,

    Cheers

    Gary
     
    Garyr, Feb 2, 2006
    #4
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