Share MDB over the Internet

Posted on 2003-03-06
Medium Priority
Last Modified: 2012-05-05
Hi everyone,

  I am trying to share a MS Access Database across the internet through an AccessPage frontend.

  The UNC naming convention seems to be working only for local networks. i.e. \\myhost\sharedfolder\db.mdb is valid, but http://www.mydomain.com/sharedfolder/db.mdb is not supported.

  Thus I am wondering if AccessPages are meant to be accessed over the Internet, or Intranet only? (this sounds really silly but i'm really frustrated) If it does have internet accessibility, what do i do with it?

  Thanks in advance for your help.

Question by:tox
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Expert Comment

ID: 8082083
Why can't you use \\www.mydomain.com\sharedfolder\db.mdb ??

www is just another hostname, and as long as there is a valid share, it should work intranet, extranet and internet.


Author Comment

ID: 8082732
simply won't work.

in this case, www.mydomain.com is interpreted as a local host name, and there's no way it can be resolved.

further more, \\xxx.xxx.xxx\sharedfolder\db.mdb (parsing ip address directly) will work only on local network, which is another evidence that your solution won't work.

still, thank all the same for giving me suggestions.


Expert Comment

ID: 8082795
From what I know, your MDB needs to be on a file server that CAN be accessed from the internet, if your page is being served to the internet (Outside the firewall). No?

Is there something I am misunderstanding?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.


Accepted Solution

KMAN earned 320 total points
ID: 8082822
This wouldn't be an issue if you are doing server-side calls with an ASP, then you could just use ADO instead of the Access ActiveX Control, used in an Access Page by defualt.  No?


Author Comment

ID: 8083536
well, it IS on a web server and can be downloaded directly. the problem is when i manually modify the data source path to "http://www.mydomain.com/...", i received an "invalid filename" error.

actually this problems has two parts:
  1. obtain the correct datasource i.e. correct naming
  2. data binding

for part 2, i think Access ActiveX Control is the default option since Office Web Component has to be installed on the client side.

also i want to make the accesspage accessible to IE browsers on MacOS. i tried the most up-to-date IE available for mac, but still it failed the version check ("IE 5.5 or higher is required to view this page, click here to download the latest version of Internet Explorer").

i am wondering if a patch is needed in this situation. besides, how do you refer to a local host in Mac? i don't think \\hostname\sharedfolder\sharedfile will work on Mac. that's the very reason i post this question just to avoid such problems.

please be noticed that i've increased the pointes. (that's all the points i have so far :(   )


Author Comment

ID: 8093796
i guess i'll use ASP instead of AccessActiveX controls. Thanks anyway, KMAN

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question