ODBC Call Failed

[ninash]

Hi all

I am using an Access database as a gui to enter data into an SQL database.

Everything is fine except for the following.

There is one table that within the access database I can read the tables data and display it correctly within the form but if I go into the table to view the raw data it shows an odbc error.

Has anyone any idea what could be causing this?

Tony

 

[SQLSister]

MAybe you need to refresh the link on that table.

Questions about posting. See faq183-874

 

[ninash]

Hi
I have deleted and reconnected the table but still is show an odbc error

any further ideas
tony

 

[ninash]

Hi
further to this thread

I am no longer getting the ODBC error
But this has been replaced with a deleted record report....

The record is safe in the SQL database but the access database is showing a deleted record

I really am stuck

Not the start I hoped for in SQL

tony

 

[tlbroadbent]

Does the table have a primary key, unique index or timestamp column?

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm

 

[ninash]

Hi Terry,

Yes all of the forms I am using have primary keys and relational linking fields.

the relationships are also in place between the tables and from what I can see in the SQL Database they are being filled in correctly and should be working fine... But the odbc connection still keeps bugging out when I enter data then move to another record.

Tony

 

[SQLSister]

Wait, befoire you were talking about viewing and now you are talking about entrering data. Have you checked the permissions? Perhaps you do not have poermission to do anything except view.

Questions about posting. See faq183-874

 

[ninash]

Yes SQL Sister

I have rights to read, write and light the blue touch paper.

I have to have full access rights due to designing the gui for the system.

About the only thing I can think of is that it might be an old odbc driver on the system controlling the access database (a citrix server). However I don't have access to that server and my IT department can be very slow.

tony

 

[ninash]

Hi All

Thanks for your input but I have discovered what was causing it and found a solution.

Cause... A field in the table required input of which I was unable to provide (ole object, data will be provided by PDA input)

Solution.. Not to access the table directly, by using a select query to retrieve the data I need for the form only the ODBC error is stopped.

again I thank you for your input and hope if anyone has this problem that my solution helps them too.

Tony