Web Programming or remote database access

peggypph

Registered User.
Local time
Tomorrow, 05:37
Joined
Jan 2, 2004
Messages
33
I have written several application using MS Access to access and run programs locally. But this time, my client want to implement the database in central office, and both local users and remote users (different country) will run an Access program to access and update the database. Pls. advise me how to design my Access Program with acceptable performance for remote user (broadband as the media), and can I use the same programming technique and tools as before?
Or it is suggested to host the database on Web.

I got no experience on writing Access Program under such Infra-structure. Does MS Access 2003 has fancy tools to help me? Or ADP or pages design?

Thanks for experienced and smart guys!
 
I can only share my own experience on this, be warned I am no expert.

I looked a different ways of doing this and finally settled on providing access through asp via a webserver which I set up in the office, to date it has worked very very well and I am very pleased with it. There are benefits as well to this type of access, using a web browser means it's cross platform but the bigger advantage over deploying a remote application to your clients is that when you want to make changes or updates you just need to make them on the server. We only have a standard UK broadband connection and it works fine, though we never have more than about 3 remote clients connected at once, I am not sure how many connection a set up like this can handle, perhaps somebody else on the forum could comment. To do it properly you will need a static IP address, although we don't have one instead we use DYNU.COM to resolve ours (once again this has served our purpose fine). Of course you don't have to use asp to connect in this way, you could use PHP, JS or aspx (asp.net). If you choose this method there are litteraly hundreds of free tutorials on the www and if you have reasonably solid grounding in access you will have little trouble tackling them.

The other way of course would be to create standalone application using vb or similar and utilise com control, I really don't know much about this except that there are several issues associated with this control and I also belief it is quite resource hungry (though don't quote me). You may also need to set up some sort of virtual network as well to use this method securely. I understand that .net is the way forward if you take this road (does not use com), though this might just be a microsoft advertising ploy, perhaps one of the .net guru's could comment.

There may be other methods these are the ones that I explored.

I replied as no one else had, I hope it helps a little and steers you in the right direction. Postback if you want any more info.

Keith
 
Problem starting an Access application from intranet

I also want to let users start an Access application by clicking a link on a intranet page.

The link looks something like this:
<a href="file://server/directory/accessapp.ADP">Access App</a>
This works fine. (user must have Access installed on local pc)

But when i try to open a *.ADE file with this link:
<a href="file://server/directory/accessapp.ADE">Access App</a>
The ADE application is opened twice by Internet Explorer 6.
Very strange. Is ther some workaround?

I rather use an ADE than an ADP because in an correctly configured ADE users cannot open the database window.
 

Users who are viewing this thread

Back
Top Bottom