Info on Access to Web

[dragongunner0351]

Hello all, I am looking for some good resources to asssit me in having my DB accessed via the web. I want to keep if on my local network but also be able to add/sub data from any web browser any help will be greatly appreciated.

 

[BuilderSpec]

Hi

Create ASP web pages to do the access and updates so anyone with a browser can update view amend. More complicated stuff do in access looking at the same database.

You say the web as opposed to the network. In this case your DB will have to be on the web and you should try and do all the access on the web , if you have a local network copy then you need some method of updating one database with the other.

I use dreamweaver for my online db access pages.. then use them on the network too.

Regards

BuilderSpec

Hope this helps!

Regards

BuilderSpec

 

[fneily]

A couple of options:
First, forget what you know about how an access form transfers data to another form. With Data Access Pages (DAP), you're creating WEB PAGES. Thus to transfer data from a page to another you need to write cookies. The language you'll be using will be VBScript or JavaScript. Remember, you're coding in the Internet Explorer environment, NOT ACCESS.
Also, I've found most IT departments aren't familiar with the XML produced by DAP's. So they'll tell you to rewrite it in ASP or something. DAP's been around for about 6 years, yet few IT people have learned it.

Put up a Citrix server (

http://www.citrix.com).

Then your clients can just login remotely and your Access database can just be stand alone.

If you don't like the Citrix server idea, I would say you could learn SQL or MySql quickly (relatively speaking) and use it to access your Access.

You could split your database You would place the BE on the server. You would then make a replica of your FE. You would do this as many times as needed (one for each user). The replicas would then go on each individual client. They then have access to the same data (the tables on the server), but they can do their own individual work (creating forms, queries, etc.). Then once a week or whatever, you can sync the different FE's.

For references to DAP's, look at:

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

or:
msdn.microsoft.com\library - Then on the left, expand Office Solution Development, Microsoft Office XP, Access 2002, Technical Articles

 

[dragongunner0351]

Thank you for the replies I will look in to both replies