Best way to create a large access databases.
I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live with it.
Software/Hardware used:
Access
Software/Hardware used:
Access
ASKED:
November 25, 2009 7:40 PM
UPDATED:
November 30, 2009 7:02 PM
Answer Wiki:
Hmm... let's just throw this out and see if it works for you.
If you want to use Access because you love the forms and VBA, you can always link Access tables to more heavy duty backend databases.
If you haven't got a "heavy duty backend database", then you can download MySQL for free without support.
If your database is under 4GB then you can download Microsoft SQL Server 2008 Express for free.
If you aren't attached to Access - it's just the only database you have - then the free version of Microsoft's product probably makes sense - along with the free express versions of their languages.
I downloaded Microsoft's product. The download took less than an hour over my wireless connection. The install took about 30 minutes. It didn't ask me any technical questions that I can recall. It fired up the first time without a hitch. I immediately tested it using only Excel as a frontend. Again - everything worked as expected the first time.
References:
<a href="http://dev.mysql.com/downloads/">MySQL Downloads</a>
<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx">Limitations of SQL Server Express</a>
<a href="http://www.microsoft.com/express/sql/default.aspx">Information about SQL Server 2008 Express</a>
<a href="http://www.microsoft.com/express/sql/download/">Download SQL Server 2008 Express</a>
<a href="http://itknowledgeexchange.techtarget.com/beyond-excel/">My Blog on Excel and Databases</a>
To see all answers submitted to the Answer Wiki: View Answer History.
Thanks Chatmaker, can I ask what the Microsoft SQL Server 2008 Express will do?
I totally agree with Charmaker. You might get “Database File Size” issue in Access if you have a huge database. In Access 2003, .mdb “Maximum Capacities” is 2G.