VB & Access Application software

I have written an application software using vb6 and access as backend database. I created the setup package using vb6 deployment and packaging tool. I tested the software in one my test machine removing the office application and visual studio. I used access 2000 for devleopment. when i wanted to install that in my client pc which runs access 97. it gives me errro message that you must use an updatable query. So my program is not running there. Please tell me what to do now? where as in my test machine i removed even the office and tested it and it worked fine.


Please help me

Popel

Some info on why this error occurs in web-based apps here

http://www.dougscode.com/forum4/topic.asp?TOPIC_ID=5

In your case make sure the windows logged-on user has write permission to the mdb file.

U can update the setup or install package file with Adding MDAC2.8...Hope it's helpful..

my employee run the software setup from CD. and when i convert the DB from Access 2000 to 97 or when i burn the cd it made the mdb files as read only. So when ever it is trying to insert any data into table it generates the error as cannot run an updateable query. I remove the read only property and now saw the software is running fine.

Anyway thanks again for your great help

THx for giving the answer,afaruq!!