Access on the Web

[needadvice]

I have an existing Access Database with one remote user. That user complains that his connection is too slow. I'm looking into the possibility solving this problem by putting the Application on the Web.
I have no experience at this. Can someone give me an idea of what is involved?
Thanks

 

[ssatech]

Needadvice,

There are third-party software's out on the web that can do this.

e,g. ASPRunner (

http://wwww.xlinesoft.com)

Just go and Google to search.

Otherwise, maybe learning ASP to get your database up.

 

[alvechurchdata]

That user complains that his connection is too slow. I'm looking into the possibility solving this problem by putting the Application on the Web.

Surely the user's connection will still be slow when the database is on the web. He might even find that performance is slower because of the overhead of the web server.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[fneily]

The web deals with "pages" written mostly in HTML. Access has an Object called Data Access Page the will create the code in HTML and XML to display your data. However, if you want to transfer data between pages such as you do in forms, you have to write it in VBScript or JavaScript using cookies. These pages are stored outside of the Access application, so you have to be aware of which storage area each page is on. It can be done, but there's quite a learning curve to place an Access application on the web. Then, as I found out with the State of Maryland, the IT department in charge of the server won't know anything about XML and will want it to be written in ASP.

 

[wdverner]

it would involve a complete overhaul to put it on the web, even then it may not answer the issues of slowness.

How does the user access the DB? You may want to put the DB local on his PC, which does away with network issues etc.

You can then set your Backup SW to remotely access the folder and backup.