hi guys!
        I wana know about the disadvatages and adv. of using access as backend db.

Regards
Umair Rathore

__________________
Don\'t express ur emotions, let the Emotions express themselves

Advantages of Access:
MS Access is one of the widely used database because it is easy to use and can be installed on most PC.
Extremely low cost compared to SQL Server or Oracle
                    
Disadvantages of Access:
Access is not meant for creating scalable solution with a large number of users
Lack several features (triggers, stored procedures (i.e. complex Stored procs), views (i.e. index/materialized views) available in client/server databases.

FYI: I learnt a short time ago Access does do Stored Procs, see Google for more info

Wind is your friend
Matt

Access does permit views (queries) and stored procedures. I have posted some sample stored procedures for Access 2000 some time back in another issue.

Access is not thread safe, I think. It is not safe also. Hackers can guess the name and path and steal the database as such.

You know one of the most famous google based hacking attempt.Type

shop filetype:mdb

into google. This will give you a list of access databases used in various shopping carts which you can download also.

Ahhh - thats where I'd heard it. I couldnt find your post...

Wind is your friend
Matt

here is my post.

http://p2p.wrox.com/topic.asp?TOPIC_ID=17981