|
Adeniyi G. (m)
|
Is it a good ideal to use Microsoft Access to build a database program for a company? Using the package on their Local intranet to enable all computers have access to the package at any time.
|
|
|
|
|
|
juintade (m)
|
@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 G. (m)
|
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 |
|
|
|
|
|
babasin (m)
|
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. |
|
|
|
|
|
smartsoft (m)
|
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 because it will be very good for just that you mentioned.
|
|
|
|
|
|
|
|
@tomX (m)
|
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.
|
|
|
|
|
|
juintade (m)
|
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 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.
|
|
|
|
|
|
Adeniyi G. (m)
|
. 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 |
|
|
|
|
|
IG
|
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
|
|
|
|
|
|
Adeniyi G. (m)
|
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 |
|
|
|
|
|
Bossman (m)
|
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.
|
|
|
|
|
|
IG
|
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.htma direct download is available here http://www.marc-grange.net/cpt_en.htmIt'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. |
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
