Best way to create a large Access databases.

35 pts.
Tags:
Database
Microsoft Access
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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:

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Opus
    Thanks Chatmaker, can I ask what the Microsoft SQL Server 2008 Express will do?
    35 pointsBadges:
    report
  • LL123
    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.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following