How can I access Access2000D.B. from anywhere over the internet?

[razzzle]

I have a contact information database that I would like to view and update from any internet connection available using my laptop or any computer while I am on the road.

The database is in Access2000 form and I have DAPs created.
I also have plenty of web space available via internet, intranet, and peertopeer networks. All are highspeed.

My plan is to store the db on the

http://www and

access it through daps using an http path. So I now have the db at

http://www.xxx.net/dbfolder/xxx.mdb

and the DAPs are at

http://www.xxx.net/dbfolder/xxx.htm.

Everything works fine if I first download the db then go to the DAP. I wish I did not have to download the db everytime I need to access it.

Plan B would be to store the db at my office server(Windows Small Business Server 2000) and access that network from a remote connection or store at home(XP Pro) and access the home system from a remote connection.

Is there a simple solution to this. I am not very technical but do understand basic principles of programing.

Any help would be appreciated.
Thanks
Razzzle Dazzzle

 

[Pipewelder]

I only dabble in access but here is what I have done. I have a website domain that costs me about $10.00 per month. The domain host allows unlimited access database connections and frontpage extensions. Throug active server pages and frontpage forms I can view records, add new records and edit existing records. Here are some example pages that are linked to underlying databases.

http://www.weldinginspectionsvcs.com/FillerMetalLookupByType.asp

http://www.weldinginspectionsvcs.com/ferrousPnumberLookup.asp

You can even set it up to match only part of a field as used here

http://www.weldinginspectionsvcs.com/type_or_grade_string.asp

. Enter 316 (A type of Stainless Steel)

This is all something that I have done with no formal training so this may not be the best way to do it. This was all learned using the help files that came with frontpage.

More than likely with the resources you listed above this should be doable using active server pages and your company server.

Hope this helps

Gerald Austin
Iuka MS

 

[81818181]

We use Windows Terminal Services, which is similar to PC Anywhere, excpet that multiple people can connect simultaneously.

This is a stop-gap measure, until I can upgrade Access to SQL Server, write CGI scripting, and spend lots of money, as I barely understand all that stuff.

If you are the only one that needs to connect, then load PC Anywhere on the database machine, make it the host, then load PC Anywhere on your remote machine, then connect on. You will need the IP of the databse machine. It is quite efficient, as it is only keystroke upload, and video download.