I'll bet you are using Access2000 Right?
1) Try using an OLE-DB data source, instead of ODBC.
2) Try making an MDB with linked tables to your real MDB, and use that as
your ODBC source.
At 11:03 AM 2/20/01, S. R. wrote:
> > All of a sudden my access database has started opening up in exclusive
>mode,
> > although when I look at the options on it, its set by default to open in
> > shared mode. I get an error in CF that it can not open 'unknown'. When I
> > close the database some of my queries give me this error:
> >
> > Error Diagnostic Information
> > ODBC Error Code = S1000 (General error)
> > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> > query.
> > The error occurred while processing an element with a general identifier
>of
> > (CFQUERY), occupying document position (7:1) to (7:48).
> >
> >
> > Any suggestions?
> >
> >
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/2001
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
