Recordset not updatable on 1 pc, works on another

[flaviooooo]

Hi,

I'm having a weird problem with a query. It links 4 tables together, and updates some fields.
The problem is that this query gets an error 'recordset not updatable' on 1 pc. On another one, it works fine.

I don't think it has anything to do with user rights, since I'm logged in with the same user twice.

Any ideas on what can be the cause of this?

Thanks in advance

 

[hymn]

Have you checked the references on that computer

Hope this helps
Hymn

 

[flaviooooo]

Yes, yes I have.
No references were missing. The only 3 references needed are DAO 3.51, Access 8.0 and Visual Basic for Applications.

It are the same dll's on both PC's.

 

[hymn]

What version of Access are you using

Hope this helps
Hymn

 

[flaviooooo]

The database is an Access 97 database. On both pcs however, Access 2003 is also installed (next to 97).

Both are installed in exactly the same way though (to our recollection that is...)


Strange thing is that it used to work fine on the pc, when only Access 97 was installed.

 

[flaviooooo]

I have resolved the issue!

In the query 'Distinctrow' was used. When I deleted that, everything worked fine.
I haven't got a clue why this would have made a difference, but it works now!

Thanks for the help

 

[hymn]

I'm Glad

Hope this helps
Hymn