MS Access Issues - Scalability / Indexing / Transactions

Question

A few questions on MS Access databases -

Size: are there access database size limits? I ask that we have an access database with a few simple tables. The db size is about 1 GB. When I make a request for this, I see that it takes 10 minutes to work.

With proper indexing, MS Access will be able to handle this or there are fundamental limitations to the technology.

This is MS Access XP.

In addition, does MS Access support db transactions, commits and rolls back?

Answer 1

, . , 1 , , .

, . Microsoft Artic le.

, , .

Answer 2

-

: 2 .

: JET.

, , , , , SQL Server Express.

Answer 3

, " " .

. , , , , "" , ​​ SQL Server, ORacle, DB2, MySQL ..

EDIT - . http://www.blueclaw-db.com/vb_transaction_processing.htm Access. -, .

Answer 4

Access - 2 . , , , , , .

, SQL Server Compact, , , SQL Server Express, "" SQL Server, SQL Server. 4 .

, Access, .

Answer 5

, XP, Access 97 . , .

Answer 6

, SQL Server , Oracle, Access, -.

VLDB - 40 . , , . - SQL Server.

, Access 800 . Access . , . .

, SQL Express, .

Answer 7

Access , ACE/Jet ( .accdb,.mdb .mde) MS Access RAD . Access, ACE/Jet ( ) : SQL Server Express SQL Server Compact Edition MS, MySQL, ..

reagrds ACE/Jet, , . , DAO: , DAO , - . , SQL DCL: BEGIN TRANSACTION, COMMIT TRANSACTION, ROLLBACK TRANSACTION .., , DAO, . . SQL DCL , Access ANSI-92; ADO , ADO . .:

Microsoft Jet SQL Access 2000

Answer 8

Jet , Access. VB - ( ).

1 MDB, , , , . , , SQL. SQL WHERE , -

WHERE Year([MyTable].[MyDate]) = 2002

WHERE MyTable.MyDate Between #1/1/2002# And #12/31/2002#

If you have stability issues (i.e. periodic damage), the problem that needs to be resolved is usually a human error, hardware problems, or software problems (for example, AV software that interferes with Jet's internal write operations).

But a key factor is how fast the ICBM is growing. If you extrapolate historical growth rates and approach 2 GB for 5 years, I would say that you need to quickly accelerate. If you like 10 years more, you should probably do it. If it's 20 years old, then, not so much.