Thanks Emmit & Razzak, I don't think I can use that as I will need to be able to modify & add rows to the connected database so a read-only doesn't help.
Jan ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 03, 2004 6:39 AM Subject: [RBG7-L] - Re: odbc > > At 08:00 AM 11/3/2004 -0500, Emmitt Dove wrote: > > >What you can also do is run with STATICDB ON, and > >then SCONNECT/SATTACH as required. This makes the > >SATTACH temporary, and is automatically removed > >when you disconnect the database. > > > And if you need to suppress that message: > > "Database Schema is Read-Only" > > You can use the following technique: > > DISCONNECT > SET STATICDB ON > SET ERROR MESSAGE 2495 OFF > CONNECT dbname > SET ERROR MESSAGE 2495 ON > RETURN > > That is your tip of the day! > > Very Best R:egards, > > Razzak. > >
