asked on

Operation must use an updateable query

dear all,
can anyone tell me why every time after i open any report then my ado become read only mode..

top urgent!!!

my report procedure:

With CrsRpt
.ReportFileName = App.Path & "\Report\1.rpt"
.PrintFileODBCSource = GV_ODBC$
.PrintFileODBCTable = "mytablename"
.ParameterFields(0) = "CompanyName;" & GV_COMP$ & ";true"
.ParameterFields(1) = "UserName;" & GV_USER$ & ";true"
.Action = 1
end with

after report showing .. all my adodc.recordset become not updateable
eg:
adodc1.recordset.update

not only my adodc...
i cant even create new database
eg:\
dba.Execute "Select * into [Temp_table] from " & tblname

runtime error '3027'
cannot update. database or object is read only

thanks

anaadoul

i'v run into this trouble before but in ASP
it was solved by the folloing

right click on the database
click the security tab

make it everyone full control

hope it works

---------------------------------
There Are 10 Kind OF People
Those Who Understands Binary AND Those Who Don't

delphikit

ASKER

hi anaadoul,
thanks for reply...

i am using DBF table...and Crystal report 8.5 with VB6

Sethi

This is because you are passing the name of the table as record source to the report and the report is holding the table and would not allow and editing options on that table. There are two ways to workaround this problem:
1. Use recordset as a source to the report
2. Set the report variable to nothing before making any changes to the respective table.

delphikit

ASKER

dear Sethi,
i cannt understand your anwser...
can u give me some example...

thanks

delphikit

ASKER

dear all,
my ODBC connect was

z$ = "ODBC;DATABASE=" & GV_ODBC$ & ";UID="";PWD="";DSN=" & GV_ODBC$

GV_ODBC is DSN name

dont know why ,... after opening report... all my table locked...

Sethi

What Reporting tool and Database are you using and are you comfortable with ADO?

delphikit

ASKER

dear all,
i'm using crystalReport compoment, and DBF table,....
i am do updating, insert and delete mode with Ado b4 i open any report...
but once i open report, all the DBF table locked...

using crystalReport 8.5

thanks

Sethi

Sorry, no idea about DBF. I assumed Access as your backend

delphikit

ASKER

dear all,
anyone can slove my problem? top urgent
i willing to give more points

thanks

anaadoul

what happens after you close the report is the table still locked?

---------------------------------
There Are 10 Kind OF People
Those Who Understands Binary AND Those Who Don't

delphikit

ASKER

dear all
thanks for everything..

problem solved... cos of ODBC driver
before = "driver of Microsoft dbase (*.dbf)

should use "Microsoft FoxPro VFP driver (*.dbf)

ASKER CERTIFIED SOLUTION

amp072397

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial