MYSQL Access and Web Pages

[twood5]

I use MS Access to access my tables and build forms, etc. Everything works great right now. I wanted to publish Access Web Pages to my Powweb account to allow my employees to post data to the tables online instead of me having to distribute a copy of the database forms to everyone. Can this be done? I cannot seem to be able to locate the currect "path" to tell the web page where the data source is.

Trisha

[Jade Dragon]

Access is not supported through powweb.

Also access as a web enviroment databse application is NOT recommended. It can only handle up to 10 current users without causing problems. and anything over 2-3 users on a complicated access DB will have bog time. (per Microsoft - search their site for the articles on this.)

I have used ASP & Access in the past before coming to powweb. Now I use PHP to connect to the DB, it is so much easier to use, modify and develop than ASP ever was.

JD

EDIT: also remember to connect your pages through SSL (powweb offers it free) to secure all transactions to your database if the info is confidential.

[twood5]

Okay, thanks.. Look like its back to the drawing board. I have only used Access and am very framiliar with it since its so graphical and easy to use. I am a bit stupid when it come to hard coding and such. Thanks you so much and any more advice is appreciated.

Trisha

[Jade Dragon]

When using PHP there are many "pre-made" applications to get you started. Let me know what fields you are requiring data for and I will help you find one.

sourceforge.net is a very good resource of (free) applications to get started with.

For example this one ProjectButtler (http://sourceforge.net/projects/projectbutler/) was designed to keep track of clients and appointments.

there are thousands off different applications you can download and custumize(sp?) to your preference.

Also getting a good resource book helps alot.

JD