当大小超过2GB时，哪种数据库可以代替MS Access? [英] What kind of database can replace MS Access when the size is above 2GB?

问题描述

请问我，当数据库大小大于2GB时，什么样的数据库可以代替MS Access数据库以脱机工作或在计算机上本地工作(与SQL Server相反)?还是我们必须将表分配给仅一个MS Access数据库之间的许多MS Access数据库?
非常感谢！

Could you please tell me what kind of database can replace MS Access database to work offline or locally on the computer (contrast to SQL server) when the database size is greater than 2GB? Or we must allocate tables to many MS Access databases intead of to only one MS Access database?
Thank you so much!

推荐答案

我将移至SQL Server:524,272 TB应该让您开心一会儿... MSDN [ ^ ]

认真地讲，您应该考虑在数据库大小变大之前就远离Access了-在那之前很长一段时间里它变得令人毛骨悚然...

I would move to SQL Server: 524,272 Terabytes should keep you happy for a while... MSDN[^]

Seriously, you should look at moving away from Access well before your database size gets that big - it gets creaky a long time before then...

我个人会不同意您不使用RDBMS的情况在这么大的数据上.使用mysql或sql express.

顺便说一句，您做出决定的原因是什么?

I would personally disagree with you not using RDBMS on data that big. Use mysql or sql express.

Btw, what''s the reason behind your decision?

如果您选择使用MSSQL Express，请记住，您只能使用4GB.除此之外，我必须同意其余的用于(MS/My)SQL的

If you choose to use MSSQL Express keep in mind you''re limited to 4GB. Other than that I have to agree with the rest go for (MS/My) SQL

这篇关于当大小超过2GB时，哪种数据库可以代替MS Access?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！