Contact Us |Home
 

Resource Dynamics, Inc.

 

Tele-Support HelpDesk Hot Tips

Index by Tip Id | Index by Description | Search Keywords | Search Text
GEN0000023 GEN0000023
MS Access Limitations

Question:

What is the MS Access limiations?

 

Answer:

MS Access 97: 

Max mdb file size: 1GB

Max objects in database: 32768

Max modules in database: 1024

Max object name length: 64

Max password length: 14

Max user/group name length: 20

Max users connected to database: 255

Max record length (without Memos and BLOBs): 2048

Max fields in table: 255

Max nested transactions: 7

 

MS Access 2000: 

Max mdb file size: 2GB

Max table size: 1GB

Max objects in database: 32768

Max modules in database: 1000

Max object name length: 64

Max password length: 14

Max user/group name length: 20

Max users connected to database: 255

Max record length (without Memos and BLOBs): 2048

Max fields in table: 255

 

MS Access 2003: (data n/a at this time)

 

For further information, check directly with Microsoft.

 

Copyright © 2003 Resource Dynamics, Inc. * Created with Tele-Support HotTips Publisher