Results 1 to 2 of 2
  1. #1
    mayja is offline Novice
    Windows 10 Access 2002
    Join Date
    Nov 2016
    Posts
    1

    Linking tables to mdb database on extern server

    Hello

    We had our own server in our network.
    We have two databases: one office database and one online database.
    Working with linked tables, as soon an appointment is placed in the office database, it is also placed by linked tables in the online database, so it will be visible for our employees on the road.



    For security reasons we like to place the online database with an hosting provider (extern server)

    I transferred the online database to this extern (windows) server and tried to link the tables from the office db to the new online db. I can see the online database (online.mdb) but as soon as i choose it, i get the message: this file is not a valid filename.
    Writing etc permissions are set to yes)

    Hope somebody can help.

    Thanks in advance

    Mayja

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    You have an infrastructure/network/permissions issue. The easiest way to resolve this with your provider is to use Excel or Word as your test case. When you link to a table it is in a file that is sitting in a folder somewhere. Put an Excel sheet or Word doc in that same folder. Then using the PC where you normally do your linking - go to that folder and attempt to open & edit & save that Excel/Word doc. If you can do that then you can link to it using Access. You should be able to double click and open the Access.mdb file in that remote folder too. If you can - then you can link to it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-23-2014, 10:50 PM
  2. A database with Linking Tables
    By djclntn in forum Queries
    Replies: 1
    Last Post: 03-14-2012, 05:04 PM
  3. Replies: 6
    Last Post: 03-12-2012, 07:34 AM
  4. Linking access database to tables in sql server is enough?
    By masoud_sedighy in forum SQL Server
    Replies: 6
    Last Post: 01-31-2012, 07:59 AM
  5. Linking Database tables and forms
    By shaileen.shah in forum Access
    Replies: 1
    Last Post: 02-16-2011, 03:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums