Is it a good ideal to use Microsoft Access to build a database program for a company? Using the package on thier Local intranet to enable all computers have access to the package at any time.

@Adeniyi,

Your question is not a yes/no response. I currently manage a database system via the internet for over 120 users. Its been working perfectly for three years now.

Due to some limites feature in Microaft Access, a lot of programming and data manipulation has to be done when we need to add more features to the system, but its still fast, easily deployable and does its job well.

If I may ask, what kind of system are you really looking forward to building with it

@Adeniyi

I happen to be on the oracle website today and I just thought I post you these links

Links confirming the Oracle has the #1 choice for RDMS

http://www.oracle.com/database/number-one-database.html


Link to download the free developer edition of oracle software

http://www.oracle.com/technology/products/database/xe/index.html

Thanks Juintade,

If I may ask, what kind of system are you really looking forward to building with it

Just to store the daily sales and to give reports at the end of the day

Just to store the daily sales and to give reports at the end of the day

ASP with MS Access backend will do that very well.

thayts creating a GUI interface with ASP u can also use that ooo i can build one for you using PHP and MySQL well just use ACCESS if thats what you want to do cos it will be very good for just that you mentioned.

beware of the limitations of ms access.

http://databases.aspfaq.com/database/what-are-the-limitations-of-ms-access.html
http://www.databasedev.co.uk/access_specifications.html

Go through these links and use google to find out more before you decide on using access

If your application is a small one you will find Access to be a good platform but note the following:
. Access, like most desktop databases has a limiting size of about 100mb per database. This will be a problem if your database is growing.
. Anyone knowing the whereabout of your database can easily go into it directly and manipulate values. This could compromise your data integrity.
Enjoy.

I hope you have now decided whether you are going to use Access or not.

With reference to the quote below, if by any chance you decide you want to host and make it available for internet users, one security step with took was to look for an hosting that did store our database on a server that was not directly connected to the internet, hence we we could only access the Database as in a whole through ftp download and the apges connects to the database through the connection page

@tomX:

If your application is a small one you will find Access to be a good platform but note the following:
. Access, like most desktop databases has a limiting size of about 100mb per database. This will be a problem if your database is growing.
. Anyone knowing the whereabout of your database can easily go into it directly and manipulate values. This could compromise your data integrity.
Enjoy.

. Anyone knowing the whereabout of your database can easily go into it directly and manipulate values. This could compromise your data integrity.
Enjoy

Is there any way at all to protect MDB file

You can protect the MDB file by giving it a password.
Keep in mind the following

-Access Databases don't grow beyond 1GB
-They behave strangely when they're more than one connection at a time.
-They work only on windows. If you're developing a web based app, your server has to be running windows
-They can easily be corrupted (PHCN took power when you are running an insert,delete e.t.c)

If you really want a light-weight database why don't you go for alternatives like

Sqlite:feather-weight,very fast and stable with small footprint
Firebird embedded server: High concurrency with rich stored procedure and trigger language.
mySql embedded server

If you really want a light-weight database why don't you go for alternatives like

Sqlite:feather-weight,very fast and stable with small footprint
Firebird embedded server: High concurrency with rich stored procedure and trigger language.
mySql embedded server

Thank so much I really appreciate your contribution

Can MDB data be transfered to to all those one you mentioned

While MS Access will probably do what you need it for, it does not scale well. And, does not handle concurrent access by users well. As already mentioned, just consider its limitation when you are making a decision. Personally, I would go with mySQL.

Can MDB data be transfered to to all those one you mentioned

There are some tools that can do that. The one I can remember now is IBEasy http://www.marc-grange.net/telecharger_en.htm

a direct download is available here
http://www.marc-grange.net/cpt_en.htm

It's a good free gui front-end for administering firebird databases. It allows you to import MDB files
ie converting them to firebird databases. Your data remains intact.