Anyone recognise this error from VB5 ?

[Lil Dave]

1. First Error

3426 : This action was cancelled by an associated object.

It happens when the data control I am using trys to execute an db.rs.UPDATE command.

Its an Access 97 database, Visual Basic 5 and it worked this morning.

2. Second Error

Even when the data controls ReadOnly property is set to false, the application returns a :

3027 : Database or Object is read-only.

The first error has me baffled as it doesn't give me any clues of where to look for the fault.

Cheers Dave
aka Lil Dave

[Clunietp]

#1) A field name might be incorrect on one of your bound controls, or referencing a non-existent field

#2) The actual database file itself might be read only. Use windows explorer to find out

[JHausmann]

I've seen 3426's for just about every possible reason when using bound controls. (It's the main reason I only use the darn things to retrieve data)...

Possible causes of 3426:
bad field names
data type mismatch
incorrect command sequencing
Full moon

[Lil Dave]

Thanks guys, I have checked with Windows Explorer and its not ReadOnly there.

JHaussman ... most of the reasons you give there, are things I would expect VB to trap and send me an appropriate error message ... is that not the case all the time ?

I have, but will, recheck all the datafield names and data types ...

Another thing that might tip you of :

Why would it give me a VB generated 'Data Type Conversion' error when I click on one of the data control reposition buttons,

Cheers Dave

[Rad_Brad]

It may be giving you this error because your database is empty. I've run into that error a lot when first starting out with a new database. Just try entering in at least one record (in Access) and retry your program.

Your data conversion error may be because there is no information in the database and it is trying to convert what is there into the required data type.

Rad Brad

[Lil Dave]

Rad_Brad : the error is occuring when I do a db.rs.UPDATE command. There is data in the database and it looks like the data is formatted correctly ... but I can double check that.

Cheers Dave
aka Lil Dave

[lychew]

I've hit this Database or object is read only error.
That's because our company is using a centre workgroup information which means everybody shares the same system.mdw.
It's this situation similar to yours?? When ever you open a database by codes, it uses the default admin user. If the permission for the admin user it not set to administer and modify, it will come out this error. Hope this help.