What are the limitations of MS Access?

It's no secret: I do not trust Access. I don't think it should be used in a production environment for anything more than a personal website, and an unpopular one at that. If you're building a web site that you expect will be even remotely successful, you're only delaying the inevitable by using Access now. You will eventually be forced to upgrade to SQL Server (or something similar).

Sponsored Links:

Related Topics

Specifications and Limitations
Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum sizes and numbers of various objects defined in Microsoft Access databases.


Creating your first database
This tutorial guides you through building a simple, single-file database. In a single-file database, also known as a flat-file database, you put all your information into a single table. This is the simplest form of database to create, but it has some limitations and disadvantages. The most important of these limitations are that single-table databases are incapable of representing some real-world data and they create more work when it comes to data entry.


Developing Smart Tag Solutions with Microsoft Office Access 2003
Learn about an exciting new feature in Microsoft Office Access 2003: smart tags. With smart tags, you can extend your Access solutions by easily adding additional functionality for your users. There is also programmatic support for smart tags that allows you to automate setting or modifying smart tag settings.
In this article, we have explored the new smart tag feature in Access 2003. I have demonstrated how smart tags can allow you to extend your Access solutions by easily adding additional functionality for your users. You have seen how smart tags can be enabled individually or for all forms or datasheets. You have also seen in which file formats and for which objects smart tags are enabled and can be added. We also looked at some of the limitations of the smart tag feature in Access. However, it should be clear after trying some of the procedures in this article that the benefits of using smart tags in Access 2003 far outweigh any limitations.


Speedometer/Dashboard Chart
Realizing the charting limitations in Access, has anyone undertaken the task of creating a speedometer chart in access? Most of the tutorials I've found deal with Excel


password bypass
I have an issue where I have enabled the access security using the wizard which is fine as users use a shortcut which takes them through the password macro. But then if they quit > open access they can select the database through the 4 most recently opened which bypasses the password.

P.S. My limitations are that I am a user with no Admin credentials on a large company network so have no way of fiddling with xp os options.


How to display any Access table on the web
Do you want to know how to display Access data on the web. Many Access users have looked to Data Access Pages (DAPs) for a web solution. While DAPs provide a rich, easily generated UI, they have serious limitations and it has been hinted that Microsoft will be deprecating Data Access Pages in future versions of Microsoft Office.


Microsoft Access Database Specifications and Limitations
Microsoft Access provides users with one of the simplest and most flexible RDBMS solutions on the market today. Regular users of Microsoft products will enjoy the familiar Windows 'look and feel' as well as the tight integration with other Microsoft Office family products.


An Access Front-End to MySQL
Using ODBC, Access can connect with a MySQL database. A proprietary front-end to an open-source database? Microsoft and MySQL? Irreconcilable differences would seem to condemn such a union to a rapid divorce. Read on to see how, despite expectations to the contrary, this marriage can work. Why do it? TOC: An Access Front-End to MySQL; Preliminary Steps; Limitations; State of the Union.


Auto Keys not working
I am trying to create an Auto keys Macro, should fire by hitting CTRL + [some letter] with the submacro macro , but for some reason it is not working, nothing will happen, did Access 2010has some limitations, ( I didn't update to sp1 due to various bugs known.)


Surviving Subqueries
This article troubleshoots eight common errors and frustrations you encounter with subqueries. Learn techniques to avoid 8 common errors, frustrations, limitations, and bugs when using subqueries in Microsoft Access.


Using Visual InterDev with Microsoft Access
In Microsoft Visual InterDev version 1.0, you can create dynamic Web pages displaying live data from various types of databases, including Microsoft Access. This white paper gives an overview of the Internet features available with Microsoft Access 97 databases and some advantages of using Visual InterDev to display that data. It then describes how to connect to a Microsoft Access database and how to display its data in Microsoft Visual InterDev, and details some limitations of this functionality.


File import to MS Access 2007
I am trying to import both a Text file and also an Excel 2007 file into MS Access 2007. I keep getting error saying "search key not found". I deleted the first row containing Column Headers in Excel file and still the problem persists.

Is there any limitations on the file size. The records in Excel is 780k lines.


Access Limitations
I have an Access 2000 DB. I have a record for each pet linked to a grooming record. In the pet record there is a bound object frame for a picture of each pet. Each picture is about 25kb. At about 1000 records the db reached the 2gig limit and kept giving me "Invalid Argument" error. Shouldn't I be able to expect more than 1000 records. If not is there another product I can use. Or use something as a backend to a VB app. Cant afford SQL


Exporting Datasheet to Excel
When exporting a data sheet with 800,000 rows of data, 26 columns, Access will only export 65,000~ rows as if it thinks it has limitations of Access 2003 / Excel 2003.

Any ideas how I can "flip a switch" to get this to export properly


My tables are too big for Access...
Reaching the limits of Access. I have a simple concept. What makes it tough is that the 4 tables I am using are between 1.2 and 1.5M records in size. So when I run code that loops through these records, Access blows up. I already had one mdb file get corrupted because of this.

I have a list of service tickets by date. All I want to do is create a record set which pulls the first service ticket. I tried creating a record set then looping though the gigantic table (linked to a SQL Server database) but after about 449,000 records access gives me that you pushed me too far error and everything becomes invalid.

Is there a way to do this just using SQL and not VBA. I think there might be, but I am running into grouping problems when using Distinct. Or is there a way to deal with the size limitations with VBA


Move the tables in an Access database to a SharePoint site and link to them
If you have data in a Microsoft Office Access 2007 database, you can share it as lists on a Microsoft Windows SharePoint Services 3.0 site, where team members can interact with it. They can share and manage the content by using the features of a SharePoint site while they continue to use forms, reports, and queries from Access.
In this article
* Overview
* How data is moved
* Use the Move to SharePoint Site Wizard
* Limitations of migration
* Move to SharePoint feature is unavailable when you use earlier database file formats


Database Corruption & Repair
A Microsoft Access database may consist of data and indexes as well as the database objects: tables, queries, reports, forms, macros and modules. The best way to protect against loss of data and databases due to corruption is to backup your databases often. Microsoft Access provides a Compact and Repair utility to assist in recovering corrupted databases. However, these utilities have limitations and may not fully recover the database, its objects or its data management functions.


Summing Values of a Subquery
I am working on building a series of queries and reports based on a database so my associates can simply click on the reports and get important figures. I've run into a problem when it comesto aggregates based on a query with a subquery in it.

I'm used to using PHP and MYSQL to run queries and manage databases, so I'm new to Access syntax and limitations. I'm building these reports in Access 2010.

An example of the issue I'm running into can be seen with this query:


Application vs DoCmd
I have been reading some threads that Application is the new DoCmd. any opinions on the two? Any major limitations of one vs the other? I have my entire database written with DoCmds but if the majority agree that Application is more efficient, then I will update accordingly


Automatically updating matrix
I have a question about something I've been asked to do for my company.

We have 10 managers that on a regular basis are asked to sit in on 5 work sessions with employees. Managers are randomly assigned to give employees feedback based on this observation, with employees getting a max of 5 sets of feedback.

I am wondering if there is a way to automate this process with access. For instance, can I input all of the employees into one table, all managers into another, set a variety of limitations or rules (e.g. no manager gives the same employee feedback more than once) and have access automatically populate a matrix with employees and managers paired up across these sessions