Client/Server

[jami]

Can you please explain me that is it possible to do following:

Can I place an .mdb file on internet (http://myserver.com/database/
test.mdb) and access it from my pc using MS Access as client and how?

Regards,

Kafeel

 

[Guest]

I believe the answer is "no" - you can not do that.

You could build a web front end to a database - and then use a browser to
connect to that web.

Or you could use a virtual private network (VPN) to remotely connect from
your remote PC to a distant PC/server that has Access on it. In light
applications I use the commercial GoToMyPC.com service....you can check out
their web site about their product. All the major corporate firewall makers
tend to have VPN solutions too for working with their product.

 

[Lucas Kartawidjaja]

I don't really recommend it. You can actually set it up that way, but you
would need to make sure that the MIME type (.mdb) is supported by the IIS, I
don't know from the top of my head if by default it is supported in all IIS,
I know that it is supported in IIS 5 by default.

However, when you try to get the file by using a web browser, it will ask
you whether or not you want to open or save the Access file. If you choose
to open it, the file will get copied over to your temp internet files folder
and the Access client will try to open the file from the tem internet files
folder. It will be fine when you are viewing it, but if you save it, it
might not go back to your server.

I think NetworkTrade proposed solutions is the best, try to create a web
application on the front end and access the Microsoft Access on the back
end. Or alternatively, instead using the web, try to use an FTP server -
download the MS access db to the local machine, make any modification and
upload.

Thank you
Lucas