Error 3146 - ODBC Call Failed....again!

[rookery]

I've posted this in another forum without much response so I'll try my luck in here as well. See:

thread183-465573

I know that there are many other similar threads on this subject but none of them seem to answer the problem.

I've got linked tables from SQL2K into my Access2K front-end. It seems to read the data OK, as I can scroll through the records, but I'm getting the afore-mentioned error message on the following command:

MyRs.Update

This only happens when I use this command with the:

MyRs.AddNew

method. It works perfectly fine when I use it in conjunction with

MyRs.Edit

method. I've tried linking the tables with a System, User and File DSN to no avail. I've also looked at the following link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;195225

which again doesnt actually tell you how to fix it. Can anyone shed any light on this matter....?

 

[nabiS2K]

rookery,

Is it possible that you do not have Insert access to the table(s) in SQL Server 2000?
God Bless,
Mike

Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)

 

[rookery]

Thanks for your reply Mike. Two points:

1) I dont know how to determine whether or not I have Insert access.

2) Considering I can update a pre-existing record does this kinda rule out this possibility?

Cheers.

 

[nabiS2K]

Nope. In SQL Server, each table has four access options. Delete, Execute, Insert, and Update. It is possible for you to edit if you have Update access, but the Addnew would fail if Insert access is denied.

You will have to contact you SQL Server Administrator to determine your rights on the table. He/she should know what to do. If not, let me know. God Bless,
Mike

Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)

 

[rookery]

There is no SQL Server Administrator I'm afraid. I'm an Access Developer trying to learn SQL. Both my Access F/E and SQL B/E are on the same machine at the moment. Would this have anything to do with it?

Please tell me how I determine/change the rights that I have to each table?

Cheers.