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

Insert into Teradata table via MS Access ODBC occasionally fails

P: n/a
I'm creating a front-end for some Teradata user maintenance tables in
MS Access. I've started having problems in occasionally not being able
to insert or update records in these tables. I've been able to create
the Teradata tables, link to them via ODBC and then insert or update in
MS Access. However, in subsequent sessions have not been able to do so.
In another instance a colleague created tables, I was able to make
entries. She had to drop the tables and re-create them. After
re-linking to the new tables I was not able to insert/ update. I'm
using the same ODBC connection setting and process. I've had lots of
ODBC problems before, but I'm stumped on this one.

Any ideas?

Thx,
Nolan

Dec 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
no*********@gmail.com wrote in news:1165450897.919658.50930@
80g2000cwy.googlegroups.com:
I'm creating a front-end for some Teradata user maintenance tables in
MS Access. I've started having problems in occasionally not being able
to insert or update records in these tables. I've been able to create
the Teradata tables, link to them via ODBC and then insert or update in
MS Access. However, in subsequent sessions have not been able to do so.
In another instance a colleague created tables, I was able to make
entries. She had to drop the tables and re-create them. After
re-linking to the new tables I was not able to insert/ update. I'm
using the same ODBC connection setting and process. I've had lots of
ODBC problems before, but I'm stumped on this one.

Any ideas?
When I was a kid working at a store I could never get the hang of how to
make the bell ring and the drawer open on those NCR things. Is that still
required for Terradactyl?

--
Lyle Fairfield

http://www.ffdba.com/toyota/BurlingtonToyotaLease.htm

(just a sad story - read if bored)
Dec 7 '06 #2

P: n/a
"Lyle Fairfield" <ly***********@aim.comwrote
When I was a kid working at a store I could never
get the hang of how to make the bell ring and the
drawer open on those NCR things. Is that still
required for Terradactyl?
Maybe your hammer was too lightweight, or the handle on your crowbar wasn't
long enough. I've heard of people having trouble determining the proper
quantity of nitro to use to open a safe, too.

But, on the other side of the employment picture, there's nothing quite like
the sound of "ka-ching" to brighten up a sales clerk's day.

Larry
Dec 7 '06 #3

P: n/a

no*********@gmail.com wrote:
I'm creating a front-end for some Teradata user maintenance tables in
MS Access. I've started having problems in occasionally not being able
to insert or update records in these tables. I've been able to create
the Teradata tables, link to them via ODBC and then insert or update in
MS Access. However, in subsequent sessions have not been able to do so.
In another instance a colleague created tables, I was able to make
entries. She had to drop the tables and re-create them. After
re-linking to the new tables I was not able to insert/ update. I'm
using the same ODBC connection setting and process. I've had lots of
ODBC problems before, but I'm stumped on this one.

Any ideas?

Thx,
Nolan
I've discovered that while using the Linked Table Manager to relink
doesn't resolve the problem, dropping the ODBC-linked table and
recreating the ODBC connection will allow me to again add rows to the
Teradata tables for some amount of time. I can also write an insert
query in VBA that will allow me to insert rows. I can use these
work-arounds, but I'd like to see if there is some setting I need to
change to allow the Teradata ODBC connection to function properly.
I've never seen this behavior in any other database ODBC connection.
I'd like to understand what is happening here so I can address this
situation in the future.

Thanks in advance for any (useful) assistance anyone might be able to
provide.

Nolan

Jan 10 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.