Need to make a web front end to MS Access

E

Exanimis

Limp Gawd
Joined
Apr 18, 2007
Messages
148
I am going to be starting a project for my office that involves the following.

I need to make a website that allows our customers to view information about their store such as contact, open/close times, access issues (for trucks) etc..

This will come from an Access database.

I would like to give a form option for them to submit changes.

Also, I would like to have higher level user views that allow a district manager access to all of the store information, not just one.


Any suggestions on the language to use and advice?


I am probably 50% proficient in C, Java, HTML, and DHTML. (only because its been long since I wrote code regularly)
I can learn programming languages pretty easily.

I was thinking ASP, and does anyone know good books or tutorials to get a crash course?
 
Why not use C, since you already know it?

Meanwhile, you shouldn't use Access for such an application -- it's not a multi-user database.
 
: / I can't really control what we use here. The company is so against change that they are using access 97' ...

I've started experimenting with ASP.NET so, we'll see where that goes.
 
If you already know C then you should be looking at php. You should be able to use your access database through a ODBC connector.

If you build your site using object based code it would be pretty easy to go back later and change to a true multiuser database.
 
Never, ever, ever, ever, ever, ever, ever, ever use Access for an application that has any chance of modifying data by more than one person at a time.*

There are so many better, free, just as easy to create applications that will address your needs out there, using Access in this manner is unforgivably stupid. There are zero valid reasons to do it.

*The only time you should even consider it is if you want to trash your data on purpose.:D

P.S. No, I'm not anti-M$. Access is a fine product, but not the right tool for the job. You might as well stick your penis into wall sockets to test household line voltages while you're at it. Any properly constructed MVC application will take at most four lines of changed code to go from Access to a database that can meet your needs.
 
You can create dynamic webpages using PHP as you are know language C learning PHP would be very easy you will find tons of articles and forums which will help you.
this will help you oopschool.com, w3schools.com and of-course Google.....
 
fri2219 said:
P.S. No, I'm not anti-M$. Access is a fine product, but not the right tool for the job. You might as well stick your penis into wall sockets to test household line voltages while you're at it.
Click to expand...

:D
Definitely the funniest thing I've read all day!
 
If you were using at least Access 2000 you could install a SQL server and fool them with an ADP. I'd almost rather use text files than Access 97 if the data were relatively small. :p
 
pxc said:
If you were using at least Access 2000 you could install a SQL server and fool them with an ADP.
Click to expand...
They'd be fooled until they got the bill for the SQL Server license, anyway.
 
Shark-MegaByte said:
:( Good people RUN from companies like that.

The North Korean government is so against change that they have no internet. Look how that's working for them...
Click to expand...


I will be running, but I am fresh out of college and nobody wants me because I'm not a "3-5" yet.

Also, yeah I loathe the computer system.

We have 25000 records in the store information database. Also, about 500 entries of manifests from pickups that day, translating into 10000 entries of Pickup history to tables for the stores. And more.

Anyway, i'm new and I already told them their database sucks balls and they know. Problem is the P and VP don't know anything about it and the others are all "Used" to it.


Also, none of these users will be able to modify anything the the database, the fields that they may be able to verify will be entered from the database into a form, then the form will be saved with any changes and reviewed and approved. (Then changed by an admin)


Thanks for the help so far guys.
 
You must log in or register to reply here.
Back
Top