Microsoft odbc microsoft access driver cannot open any more databases

Examples of connection information include server location, database name, logon ID, password, and various ODBC driver options that describe how to connect to the data source.

This information can be obtained from the administrator of the database to which you want to connect.

Machine data sources store connection information in the Windows Registry on a specific computer. You can use machine data sources only on the computer they are defined on.

There are two types of machine data sources — user and system. User data sources can be used only by the current user and are visible only to that user. System data sources can be used by all users on a computer and are visible to all users on the computer and system-wide services. A machine data source is especially useful when you want to provide added security, because only users who are logged on can view a machine data source and it cannot be copied by a remote user to another computer.

File data sources also called DSN files store connection information in a text file, not the Windows registry, and are generally more flexible to use than machine data sources.

For example you can copy a file data source to any computer that has the correct ODBC driver so that your application can rely on consistent and accurate connection information to all the computers it uses. Or you can place the file data source on a single server, share it between many computers on the network, and easily maintain the connection information in one location.

A file data source can also be unshareable. An unshareable file data source is contained on a single computer and points to a machine data source. You can use unshareable file data sources to access existing machine data sources from file data sources.

In a module, you can define a formatted connect string that specifies connection information. A connect string passes the connection information directly to the ODBC Driver Manager, and it helps simplify your application by removing the requirement that a system administrator or user first create a DSN before you use the database.

Is there a way i can increase the size limit? Any suggestions would be appreciated. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :.

Cancel Submit. Previous Next. Gina Whipp Volunteer Moderator. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. If you have reached the limit, Gina is right it may not be recoverable. I thought both would be compatable. Jeanette Cunningham. In reply to MochaTrpl's post on February 26, Friday, March 12, AM. User posted ya it willn't affect me using Oledb. But because of performance we are using ODBC connection.

Monday, March 15, AM. Use OleDb instead. User posted Ya if we use Oledb this error is not coming. But the performance wil lag. Like if we reach some limit we can close tat object and open the connection newly or any other property to avoid such error. User posted But the performance wil lag.