Access installation requied to write to database with toolkit? AC_902

[BRW]

I am using the Database Toolkit to read and write data from/to an Access database located on the local PC. This PC does not have Access installed. The read and write functions "appear" to be working fine when I view the updated database on a PC that has Access installed but I receive an error after execution of every data write vi on the non-Access PC. Do I need Access installed on this PC to get by the error or should the writes work ok without it?

Thanks.

[TiTou]

Hummm this is surprising... can you post the error string you receive from the write to DB vi ?

Message Edité par TiTou le 10-05-2006 11:17 AM

[BRW]

"Number of rows with pending changes exceeded the limit". After further experimentation I installed Access on the local PC. This error still occurs. I am now thinking it is a mismatch between the record I am trying to write and the database itself.

[TiTou]

Ok, then does this mean you are about to solve the problem or do you need further help ?

"Number of rows with pending changes exceeded the limit" starting from this statement, if you are used to work with Access I assume it's OK for you... Personnaly I do'nt often use database toolkit so I can't really help you more

Hope you'll get through

Message Edité par TiTou le 10-05-2006 02:14 PM

[Crystal]

No, you don't need to have Access installed in order to write/read to a database with the toolkit.  Access is the UI for an underlying database engine called Jet.  Jet is part of Windows.  The database toolkit can communicate with Jet without the Access front end being installed.  As to the error you are getting, I'm not sure exactly what it means, I usually those errors can be taken at face value and you are exceding some limit on number of rows for the Jet database engine.  How many rows are you trying to write/update?  What datatypes are involved?

[BRW]

At the moment of error, only two records. The first record completes successfully with no error but the second fails.

[TiTou]

This sounds like the problem I had a few weeks ago. It was the first time I used the database toolkit and I had no experience with database.
After loosing a bunch of hours I noticed that I was unable to write twice in a row without closing and re-opening the connection to the database...

It was late so I didn't try to understand why - I know... this is not a professionnal behaviour - and I just coded so as to open/write/close for every value I had to add to the database. Now the system is running well in the custommer's factory.

If someone comes up with an explanation I'd be glad to learn 😉 !

[DavidJCrawford]

Can you post your code?

thanks

David

[BRW]

I don't have the application in front of me presently but I can post it this evening. Possibly TiTou could post his solution in the mean time.

Thanks for the help.

[TiTou]

here is my code. to connect to the database I use an *.udl file which was generated by someone who is used to work with database (I am not) so I can't tell you how to generate one. sorry bout that...