Related Topics

Definition Error When Linking Odbc Table

Error Linking External Table
I'm trying to link to an ODBC table in access. When I do though, I get an error message saying 'The Operation Failed. There are too many indexes on the table 'My Table' Delete some of theseindexes and try again' There are currently circa 120 fields on this table.

The ODBC connection I have is read only and the table 'My Table' is the primary table of my database. Is there a way round this to select only the fields that I want on the table to come back into access?


Error Linking External Table
I'm trying to link to an ODBC table in access. When I do though, I get an error message saying 'The Operation Failed. There are too many indexes on the table 'My Table' Delete some of these indexes and try again' There are currently circa 120 fields on this table.

The ODBC connection I have is read only and the table 'My Table' is the primary table of my database. Is there a way round this to select only the fields that I want on the table to come back into access


ODBC - Call failed
I am getting a ODBC -- Call failed error
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect Syntax near 'dbo' (#102)
when running reports.

This is an access 07 application created on a windows 7 64 bit PC. I have 2 linked tables to a Microsft Dynamics views I created, I am linking them through ODBC connection. Everything works fine on my pc, but when another user tried to use it she gets the above error. Shes got a Winxp 32bit PC


Access 2007 Relationship between an ODBC linked table and a local table
I have an ODBC linked table with a 3-field combo key. I am trying to link to a local table using the relationships window. I can drag the first line fine, but when I try to drag the second key field, the error message "A relationship already exists.

Do you want to edit the existing relationship? To create a new relationship, click No." displays. I have never seen this when linking non-ODBC tables.


Importing and linking
There are a number of different ways to create and populate a table: -Create the table definition from scratch and then populate the table manually with data values; -Create the table definition from scratch and
then append data from some other electronic format to the table; -Import the table definition and data from another database or application (such as MICROSOFT EXCEL or a text file); -Create a link to an external data source. In this case, the data is not actually stored in your database file, but is accessible from within ACCESS like any other table. (pdf file, install Acrobat Reader to read this tutorial)


Linking between Access and an ODBC Database
I created a link between my Access database and an ODBC database. The wizard created a new table in Access based on the table in the ODBC database I wanted to import. So anytime that tablein the ODBC database is modified, the new table in my Access database will similarly be updated, correct?

But I need a table I created in Access to be also be automatically updated anytime someone enters information into the ODBC database - not just the table that was imported. How can I dothat? How can I automatically copy tables from the ODBC table into one of my own Access tables?


Linking between Access and an ODBC Database
I created a link between my Access database and an ODBC database. The wizard created a new table in Access based on the table in the ODBC database I wanted to import. So anytime that table in the ODBC database is modified, the new table in my Access database will similarly be updated, correct?

But I need a table I created in Access to be also be automatically updated anytime someone enters information into the ODBC database - not just the table that was imported. How can I do that? How can I automatically copy tables from the ODBC table into one of my own Access tables


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


Managing the Link to ODBC
I have been linking to ODBC tables with no problems& until now.

I have customer all over the place and need to start FTPing new frontends to them.

The problem is that using the link tool in Access is great but it has to be manually linked on their end.

So my choices are to get a good remote control package for my customers or programmatically link to ODBC table on load.
Which, I do not know how to do.

2 things, a good suggestion on remote packages, would be welcome, and how to runtime link to ODBC


Test for valid ODBC connection
I currently am storing the user's ID and Password for an ODBC connection in a table. I reference the User info and the connection works fine. Here is my dilemma.We have to reset our passwords every so often and if the user forgets to update their password in my database they will get the ODBC login prompt. I don't want this. I want to throw a simple error message if they have not updated their password, or the password does not work for the ODBC connection. Any tips on how to test? Currently to set up the ODBC I am deleting and re-linking the tables (see below code). Thanks in advance.

DoCmd.DeleteObject acTable, "TableName"
DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=[Connection];UID=" & strFDOPRD & ";PWD=" & strFDOPRDPass & ";" _
& "DATABASE=pubs", acTable, "TableName", "TableName


ODBC ERROR no number to report
I keep getting a ODBC Error on an existing db for a user when she tries to run a query. However, she can copy a query and import a table in the same db. I've checked the TNS files and they are where they should be. I've made all of the odbc connections in Administrative Tools as well as Access. What is wrong


Linked table to sql 2000 db
I am trying to user with an app they have. The have an access 2003 db that has some linked sql server tables. All the tables link fine except for one which shows #name after getting an ODBC error in all the fields. I even tried this with my dba account when linking and get the same error. I have seen this before and can't remember what causes it. (The table that is an issue does have a primary key on it


split db + odbc
I am working on a project for my group that involves creating a multi-user split db that has linked tables via odbc. Now the linking will be done with my credentials. When my users go to to use this db:

1. will they need their own odbc connection?
2. if so, will there be any issue between my info having created the link vs their info and their machine accessing it


ODBC -- call failed. | Oracle ODBC
I have an Access 2003 Database that resides on a virtual windows 2003 server that is giving me an error when I attempt to create a linked table or update any linked table that is using an odbc file dsn. The database being connected to is Oracle.

Here's the full error.

Now the weird thing is, the error is only occurring on a virtual machine while on my local development box, it works fine.

Both environments are using identical tnsfilename.ora files.

The failing server is running Windows Server 2003 with MS ODBC for Oracle v2.576.3959.000.
The dev box is running WinXP Pro with MS ODBC for Oracle v


SQL issue creating a table
I am trying to use SQL to create a table in my database with the Java DBMS I keep getting this error

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
So I think it is not in my java code but the issue is actually in my SQL query, I have tried several variations but I still can't seem to get it to execute .

CREATE TABLE someTable(key VARCHAR PRIMARY KEY(20), someField VARCHAR(20), someOtherField VARCHAR(500), someReallyBigField MEMO


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


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


Error linking MS Access to SQL Express
I am getting the following error when I try to link MS Access 2010 to a SQL Server Express 2008R2 table:
'idx_table name' is not a valid name. make sure it does not include invalid characters or punctuation and that is not too long.

Details:
- the table name is: italpasta-etp.etp.timehistory
- the connection: 64bit ODBC (test successful)
- I get the same error if I try to import the table
- both MS Access and SQL Server Express are new, 64bit installations (I don't know if that matters)

Anyone came across a similar issue


Changing ODBC Message in SQL Server From MS Access
By Default, when U link an Access Database to Sql Server, using ODBC, the error messages that ODBC poses back to clients is usually not easily understood by client. What step by stepprocedure do I need to take to change the error messages in ODBC, SQL Server and Possibly MS Access.


ODBC--call failed
Ive been trying to do a basic pass thought query. But have been receiving these two error messages

1.ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#102)
Error message

2. ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#208)

Basic Query
SELECT dbo_VC_Admin.app_num
FROM dbo_VC_Admin;
When trying to open the server table
a. ODBC--call failed. [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)

I dont have access to change my regedit:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engi nes\ODBC