Topics Search

ODBC Too many indexed

ODBC Too many indexed
Views: 41
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:

Similar posts...

 

bypass odbc connection

bypass odbc connection Icon
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?
 

ODBC 32 to 64 Bit connection error

ODBC 32 to 64 Bit connection error Icon
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
 

Connecting to database via ODBC

Connecting to database via ODBC Icon
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.
 

Access 2003 ODBC Question

Access 2003 ODBC Question Icon
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

ODBC Error Icon
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
 

Copy and Paste Data Into an Indexed Table

Copy and Paste Data Into an Indexed Table Icon
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.
 

Access Driver ODBC Driver Not Found

Access Driver ODBC Driver Not Found Icon
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.
 

ODBC connection for ACCDE

ODBC connection for ACCDE Icon
I created a data enter forms and works will linkedtable that by ODBC in Access 2007 .
Yesterday, I made a ACCDE and works well.
Today, I made a ACCDE from access application and does not appears a ODBC connect box.

Why ACCDE does not linke to ODBC? are there something I make changes?
 

Union of indexed Tables

Union of indexed Tables Icon
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?
 

Publish ODBC query results from LAN to website

Publish ODBC query results from LAN to website Icon
I have an access database with ODBC linked tables with a query Bob helped me to create. This ODBC connection is only available on my LAN because it uses specific ODBC engine .

How can I publish the output of this query to a hosting space that my developer can query for a website project?

The data needs to be published once a day