I want to create a Microsoft Access Database to track the day to day operations of my business.?
What I’d like to know is can you access the database from more than one computer?
You can, but it is not good for this. Better is to use mysql or similar, then set up a web server on the central machine and use php to control it. This means everyone has use of it through the web browser, and nobody can do anything you do not provide in the web forms. It is much faster, and scales much better. If the company grows, it will make no difference to the database. Access does not scale well.
February 8th, 2010 at 12:30 pm
You can, but it is not good for this. Better is to use mysql or similar, then set up a web server on the central machine and use php to control it. This means everyone has use of it through the web browser, and nobody can do anything you do not provide in the web forms. It is much faster, and scales much better. If the company grows, it will make no difference to the database. Access does not scale well.
References :