Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Location
    Sydney, New South Wales, Australia
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link to backend by FTP (MSAccess 2002)

    Subject edited by HansV to be more descriptive than 'MSAccess'

    I have placed an MSAccess database on my FTP site.
    Attempting to link a front-end database to it fails.
    Within MSAccess, I have created a new FTP site, and can find the FTP database. When I select the file (in an attempt to link) an error message appears "This is not a legal file name"
    Is this possible? I want several people to be able to share and update the data.
    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link to backend by FTP (MSAccess 2002)

    FTP is the acronym for File Transfer Protocol. It is a method for uploading and downloading complete files. it doesn't provide for linking a frontend database to a backend database.

    You could connect to a backend database using terminal server software, but performance will probably be nail-bitingly slow.

    A more common way of working with a remote database is to use a SQL Server or MySQL database on a server PC, with a web interface.

  3. #3
    New Lounger
    Join Date
    Jan 2005
    Location
    Sydney, New South Wales, Australia
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to backend by FTP (MSAccess 2002)

    Thank you Hans. If I set up a VPN, would it be possible to have a shared back-end database with several users running MSAccess front-ends?
    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link to backend by FTP (MSAccess 2002)

    It should be possible in theory, but unless all users have a very dependable very high-speed internet connection, it will be painfully slow. And you should make very frequent backups, for Access is very sensitive to interruptions in the connection to the backend, so the risk of the database becoming corrupt is higher than on a LAN.

  5. #5
    New Lounger
    Join Date
    Jan 2005
    Location
    Sydney, New South Wales, Australia
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to backend by FTP (MSAccess 2002)

    Thanks again Hans. I shall attempt to set up SQL Server. I have a developer copy and I saw some discussion in this forum. I really appreciate the help, it has saved me wasting a lot of time.
    Regards, mccer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •