Using Access Data Bases on My Web Site

15 pts.
Tags:
Access
Database
Web development
I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By Catagory? Pertinent data fields would include Title, Author, Catagory, Extract Description, Graphic Address, etc. I would like to put a graphic picture of the cover image with the extract information to dress up the presentation.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The best way to get something that will work for you is to design it and build it yourself.

I would recommend not using Microsoft Access. Microsoft Access makes an OK single user database, but it more than one person will be accessing it at a time performance will begin to degrade. I would recommend looking at either MySQL or Microsoft SQL Server Express. Personally I would use Microsoft SQL Server Express.

SQL Server Express is a free version of Microsoft’s SQL Server database product. It contains most of the features and it’s only limit is that it only uses a single processor, 1 Gig of RAM and databases of up to 4 GB in size which should be plenty for your uses.

Most hosting providers will offer a service which gives you access to either a Microsoft SQL Server or MySQL database. If Microsoft SQL Server is offered it will be the full SQL Server edition not the free Express edition so it will be very powerful.

If you don’t have anyone on staff who can design this database for you it should only take a database professional a few hours to design the database for you.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following