SQL Server vs Access


  WELCOME TO AeroHOST - a premium web hosting service featuring SQL or Access online database systems 

SQL server hosting online: Access vs SQL.

Put your data on-line with Active Server pages (ASP and ASPX) : Start with Access and migrate easily to SQL server when website traffic demands increase: 

We have created a simple Microsoft Access database demonstration using SQL commands that will query an on line MS Access database consisting typical example records. The field values are populated with sample data so that you can deliberately search for records at the beginning, middle or end of the database in order to test the speed.

Please click HERE to try the demo out for yourself.



LOAD BALANCED SERVERSload balanced rack servers Windows Server operating system with IIS

MySQL is a powerful relational database system

asp.net framework for developing website architecture

PHP is a powerful scripting language

MS SQL Server high-end relational database

Visual Studio - desktop environment for ASP.net development

FrontPage web authoring

MS Access relational database

osCommerce engine powers our free shopping cart

real-time statistics help with search engine optimization
Statistics Demo

All our website hosting plans accommodate on-line Access database systems. Microsoft Access will easily handle most requirements, but if you need a truly powerful system for large traffic demands, we also offer MS SQL server. Access users can easily migrate to SQL when the site traffic warrants it. Please visit our site home page for further information ....

If you have any questions about how to set up your database, please contact us

The Microsoft Access 97/2000 is a full-featured multiuser relational database management system that designed for the Microsoft Windows operating systems (such as Windows 9x, Windows 2000 and up). Access 97/2000 is extremely visually oriented and easy to use. It makes extensive use of drag-and-drop and visual design for queries, forms, and reports. Access 97/2000 comes with an integrated development environment (IDE), including incremental compilation, a fully interactive visual debugger, breakpoints, and single step-through. These capabilities combine to make Microsoft Access an extremely powerful platform for developing client-server database solutions.

The maximum database size is 1 GB, but your database can include linked tables in other files, and its total size is limited only by available storage capacity. Number of characters in a Memo field can be up to 65,535 characters when entering data through the user interface or can be up to 1 GB when entering data programmatically.

Here are the general Access 97/2000 characteristics:

Access Object Maximum sizes/numbers
No. of concurrent users 255
No. of fields in a table 255
Database size 1 GB
No. of characters in an object name 64
No. of characters in a password 14
No. of characters in a user name or group name 20
No. of characters in a table name 64
No. of characters in a field name 64
No. of characters in a Text field 255
No. of characters in a Memo field 65,535 / 1 GB

SQL Server 7.0/2000
SQL Server 2000 Enterprise Edition on the Windows 2000 DataCenter can support up to 32 CPU and up to 64GB physical memory (RAM) on a computer!

How Fast Is Fast? SQL Server 2000 can handle 709,220 transactions per minute! SQL Server 2000 has further established its position as the fastest database in the world. With a performance rating of 709,220 transactions per minute (tpmC) and price/tpmC of $14.96 US, a 32-node Compaq ProLiant DL760-900-256P system exceeded the previous record, which was also held by SQL Server 2000.
Another benchmark test demonstrated support for 25,200 simulated concurrent users and performed CRM transactions at the rate of 2,024 business processes per minute. These results were achieved on a 24-processor Unisys ES7000 database server and yielded average response times between one and two seconds.

How do I convert an .MDB to SQL Server?

For Access 97: The Access Upsizing Wizard Free download:


It preserves database structure including data, indexes, defaults, and so on, and automatically converts Access validation rules and defaults to the appropriate SQL Server equivalents. It also maintains table relationships and referential integrity after upsizing.

For Access 2000: (Upgrading to an .ADP file) The upsizing wizard is built in to the Access runtime. You can choose to create an .MDB with SQL Server tables linked, or to an .ADP file. Provides all the functionality of the Access 97 upsizing wizard.

These are the general SQL Server 97/2000 characteristics:

SQL Object Maximum sizes/numbers
Connections per client Maximum value of configured connections
Batch size 65,536 * Network Packet Size
Bytes per short string column 8,000
Bytes per text, ntext, or image column 2 GB-2
Bytes per index 900
Bytes per primary key 900
Bytes per foreign key 900
Bytes per row 8,060
Clustered indexes per table 1
Bytes in source text of a stored procedure Lesser of batch size or 250 MB
Columns per index 16
Columns per primary key 16
Columns per foreign key 16
Columns per base table 1,024
Columns per INSERT statement 1,024
Columns per SELECT statement 4,096
Database size 1,048,516 TB
Databases per instance of SQL Server 32,767
Filegroups per database 256
File size (data) 32 TB
Files per database 32,767
Identifier length (in characters) 128
Nested stored procedure levels 32
Locks per connection Max. locks per server
Nested subqueries 32
Nested trigger levels 32
Objects in a database 2,147,483,647
Nonclustered indexes per table 249
Parameters per stored procedure 1,024
REFERENCES per table 253
Rows per table Limited by available storage
Tables per database Limited by number of objects in a database
Tables per SELECT statement 256
UNIQUE indexes or constraints per table 249 nonclustered and 1 clustered
Triggers per table Limited by number of objects in a database


online database