Topics Search

Definition Error When Linking Odbc Table

Definition Error When Linking Odbc Table
Views: 32
Here's the issue : I'm using IBM iSeries drivers to link ODBC tables. This is usually working fine, this is actually working really fine with any table but one. Anytime I try to link that table, I get the following error message :
Invalid field definition 'SKPSEQ' in definition of index or relationship

Same table but in our QUA environment is a non issue : linkage works fine. I have ACCESS DBs with links to that table : I can run queries without a problem. If I try to export the linkage to another DB, I get the same error message.
Sponsored Links:

More topics

 

Error Linking External Table

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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.
 

Linking between Access and an ODBC Database

Preview
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

Preview
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

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
 

Managing the Link to ODBC

Preview
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

Preview
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