Online Interface/database

[topper]

I was wondering if it is possible to create a mobile accessible web page that allows a user to fill in fields. When they are finished they click on submit, this would then populate an Microsoft Access Database. Is this possible and can anyone give me some ideas as to where to start. Could this be done with PHP or does access have this capabilities?

Thanks!

 

[fearoffours]

I'm sketchy on the exact details, but yes this is possible with either ASP or PHP.

There's an example in a thread on the utter access forums. (You'll need to sign up to get access to download the example).

 

[wiklendt]

on a similar thread, i have been asked by my client whether it is possible to set up a licencing system. basically, membership to the professional organiseation would mean free use of the databse, but only while membership is current to the association.

can i create a licencing thing? and would it be best to send a licence to each user to 'unlock' for each year on re-subscription, and to 'lock' the databse (only certain setions) when membership expries?

 

[Banana]

wiklendt, what you want to do is look at user level security (there's countless threads here).

Basically, create a new group called "Members" and keep existing "Users". Give the groups "Users" no rights to modify any data but perhaps view only select queries and give the necessary privilege to "Members". You would then create a module in the database that looks at the user's subscription and verify whether they've paid the fee, and move them to "Users" group if necessary and vice versa upon receipt of payment.