ODBC Failure?

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

Dear all,

I am having this form on employees' particular, which was created on Ms
Access 2000. However, the tables are linked to Ms SQL 2000 via ODBC.

The form is displayed using Dataview, with a checkbox on every employee's
record to specify their employment type, be it full-time or part-time.

The problem I am facing is that whenever I tried to check or uncheck on the
respective checkbox, I am prompted with an ODBC failed error message,
followed by:

[Microsoft][ODBC SQL Server Driver][SQL Server]Update permission denied on
object 'tblEmployee', database 'ABCCompany', owner 'dbo'. (#229)

apparently, it is a permission issue. I tried to grant the respective users
with the necessary permissions, to the extend of giving them administrator
rights but to no avail..

and to make things more complicated, it works prefectly fine on the computer
I logged on to!

as such, I granted them with the exact security configuration I have but the
error is still there.

can someone advise on what are the workarounds for this sorta problem?
 
I have had similar problems in the past, and it turned out
to be the field settings in the sql back end.

"Bit" fields can be declared "allow nulls" which
effectively changes the field from two state to three
state. My problem was that I had several bit fields, and
they were not all the same. Making all the fields the
same, and then relinking the table fixed my problem.

Guess its worth a try
 
Back
Top