Share MDB over the Internet

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.

  Tox
toxAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
KMANConnect With a Mentor Commented:
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?

K
0
 
KMANCommented:
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.

K
0
 
toxAuthor Commented:
\\www.mydomain.com\sharedfolder\db.mdb
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.

Tox
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
KMANCommented:
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?
0
 
toxAuthor Commented:
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 :(   )

0
 
toxAuthor Commented:
i guess i'll use ASP instead of AccessActiveX controls. Thanks anyway, KMAN
0
All Courses

From novice to tech pro — start learning today.