Topics Search

ODBC Too many indexed

ODBC Too many indexed
Views: 38
I am trying to like to a table in an AS400 and I am getting the message:

"The operation failed. There are too many indexes on table. Delete some of the indexes on the table and try the operation again."

1) I know the structure of the table, i.e. Name, Fields, etc.
2) I do not need all of the items in the table
3) This will be a read only connection to I am not really worried about indexs being compete

4) How do I see/get/read the information from the table I need
Sponsored Links:

More topics

 

bypass odbc connection

Preview
I have a MS Access 2007 database that contains a union query that merges 5 different odbc connections. If one connection is down I receive an 'ODBC--call failed' error and the query is unusable.

Is there a way to have the database verify connection and if it cannot connect to one or more odbc, to simply by-pass the odbc(s) and use the others?
 

Copy and Paste Data Into an Indexed Table

Preview
We have created a split database which allows my manager to update the data in the table on a weekly basis. The table is indexed in order to speed up time it takes to search for the records from the front end. Every week we have to add records to the access table from an excel spreadsheet. My manager likes to copy and paste the new records into the existing table. If we continue to add records to the indexed table via copy and paste, will the table automatically stay indexed or will this slow the response time down.
 

Copy and Paste Data Into an Indexed Table

Preview
We have created a split database which allows my manager to update the data in the table on a weekly basis. The table is indexed in order to speed up time it takes to search for the records from the front end.

Every week we have to add records to the access table from an excel spreadsheet. My manager likes to copy and paste the new records into the existing table. If we continue to add records to the indexed table via copy and paste, will the table automatically stay indexed or will this slow the response time down.
 

ODBC 32 to 64 Bit connection error

Preview
We currently run an ODBC connection to Access that is stored on a network drive. We are currently upgrading from a 32 bit computer to 64 bit. Before I simply imported the registry from computer to computer to save time on setting up numerous ODBC connections. Whenever I import onto the new 64 bit system it is importing into the 64 bit ODBC and not into the 32 bit odbc. When I test the connection it is fine but whenever I run the access report it gives the following error:

ODBC--connection to 'database' failed

I am almost certain that it is before the two ODBC connections. My question is will I have to recreate the Access report for 64 bit or is there a way to import on a 64 bit machine to the 32 bit ODBC?

I am not a database guru and limited knowledge of Access and ODBC so please bare with me
 

Union of indexed Tables

Preview
If I have 26 tables that contain the same fields/strucuture. The 26 tables are all indexed by the same fields (with duplicates).

If I create a Union Query to create one single table containing the data of the 26 tables, will the resulting tables automatically be indexed by the same fields?
 

Connecting to database via ODBC

Preview
I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for all of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.
 

Connecting to database via ODBC

Preview
I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.
 

Access 2003 ODBC Question

Preview
I am supporting a legacy Access 2003 application with ODBC connections to several Oracle tables. My customer is upgrading to Oracle 11g which does not support ODBC. Is there any way I can create a connection string or otherwise link to an external Oracle table without ODBC?
 

ODBC Error

Preview
I am importing data into MS Access using a ODBC connection.

it was working fine earlier but now when I try to open the ODBC connection table, it gives me the error as below!

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.tbl._ActiveDir_AD
 

Access Driver ODBC Driver Not Found

Preview
In ODBC Data Source Administrator (%windir%\system32\odbcad32.exe), clicking "Configure." button will pop up an error message box:
Microsoft ODBC Administrator
ODBC Administrator
The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC driver could not be found. Please reinstall the driver.