By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Linked Table Issues

P: 2
I have a linked table in my database.
When you open the database you are unable to add records.

soon as you re-import the table it all works fine again.

anyone know why??

It works if i jsut click "add new record" and dont enter any data, but as soon as i do i get

ODBC -- insert on a linked table "businesses" failed.
[Microsoft][ODBC Driver Manager] SQL data type out of range (#0)

anyone have a clue as to why??

This is taking far too long!!
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: 13
I don't believe the Linked table can be updated ie it can only contain data from what it is linked to.

If you put the linked table data into another table using a make-table query, you can add/update that without affecting the original source
Dec 18 '07 #2

Jim Doherty
Expert 100+
P: 897
I have a linked table in my database.
When you open the database you are unable to add records.

soon as you re-import the table it all works fine again.

anyone know why??

It works if i jsut click "add new record" and dont enter any data, but as soon as i do i get

ODBC -- insert on a linked table "businesses" failed.
[Microsoft][ODBC Driver Manager] SQL data type out of range (#0)

anyone have a clue as to why??

This is taking far too long!!
You can add to and update linked tables except ISAM text files the driver of which doesnt support What is your backend datasource Access, MS SQL Server, MySQL Oracle??

Jim
Dec 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.