PDA

View Full Version : iam creatingwebsite that is linked to Access database



glory
09-23-2004, 03:40 AM
Iwant to view the database online and also write into the database online .and also create queries.The website is for real estate company

SteveF
09-23-2004, 04:18 AM
Yup you can do that!

Search the net and you will find many sites for many different languages that will do that for you - with Access the ASP language works well

ahiggins
10-29-2004, 03:32 PM
Keep in mind Access will work OK for reading with multiple users connected at the same time but it has issues with writing. When you go to write back to access it locks the entire database which then causes problems with anyone trying to view from this database. So you will need to plan to program around that or move up to a more robust database environment.

Since this is the foundation of your site you need to make sure it will support your future traffic growth.

Good Luck
Andy Higgins
http://www.Contevo.com

godzilla
11-16-2004, 11:16 PM
Since this is the foundation of your site you need to make sure it will support your future traffic growth.
http://www.Contevo.com
if you plan to have more than 1000 records and more than 50 instant accesses you need something more robust than Access. Remeber Access is fast to deploy but has draw backs: it was designed for rapid deployment, easy use, short term and small size db's. Finally, do not forget that one MAJOR issue with Access is the exponetial grouth of the DB size over time and stability issues originating form it.

In general, do not use Access in any of applications destined to heavy use by public, unless you have no other choice .