Jan,
The database wouldn't be read-only - just the schema in your main database.
You would have full access to the SATTACHed tables and data.
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. > >
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
