-
Access
Is there a new Access that can house more than 2.0million MB?
Trying to submit a case to management on why Access is not a valid backend tool for us and we should use MS SQL as backend and then can use Access as a frontend.
-
It isn't a record size it is a database size. I have seen Access databases with over 2 million records. I know of one that has over 10.
As long as the overall database size does not exceed 2GB, Access will take it.
Having said that I will say this: Those kinds of numbers will drastically increase search and processing times.
-
-
Yes I know it is not a record size but a space size. I have 56 separate Access databases because of the size of data we get each month. And they are all puzzle pieced together. I am trying to get them to invest in sql server because they use access like a giant storage bucket and they complain when the queries have to be run over night or reports take forever.
-
There is an interesting, and insightful, dialog in a series of posts here that may help in sorting out Access, MySQL and SQL Server.
http://www.access-programmers.co.uk/...d.php?t=190649
There are also interesting facts and comments here
http://www.techrepublic.com/blog/10t...y-shouldnt/386
Especially Albert Kallal's post.
Last edited by orange; 10-17-2011 at 08:25 AM.
Reason: more info
-
What's the sort of database with such a giant amounts of data? Just curious :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules