Read_Only Kinks Ira Solomon <isolomon[ at ]solomonltd.com> 12/8/2008 4:31:33 PM I have a standard frontend/backend setup. Now the user wants a front end in which he can write some reports and queries. I need to link that backend as read-only. Is there a simple way to do this? Right now the system is in 2003 so I owuld like to know how do this this in DAO and ADO. Thanks.

Re: Read_Only Kinks John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/8/2008 5:25:06 PM On Mon, 08 Dec 2008 11:31:33 -0500, Ira Solomon <isolomon[ at ]solomonltd.com> wrote: [Quoted Text] >I have a standard frontend/backend setup. Now the user wants a front >end in which he can write some reports and queries. I need to link >that backend as read-only. Is there a simple way to do this? >Right now the system is in 2003 so I owuld like to know how do this >this in DAO and ADO. >Thanks. And the problem being...? You can link a read/write frontend to a read-only backend. -- John W. Vinson [MVP]

Re: Read_Only Kinks Ira Solomon <isolomon[ at ]solomonltd.com> 12/13/2008 9:06:06 PM I just haven't found the syntax. In the current system it goes through the tables in the backend and links the tables with no trouble. But this is read/write. I haven't been able to to find where I put in a "readonly" parameter. On Mon, 08 Dec 2008 10:25:06 -0700, John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote: [Quoted Text] >On Mon, 08 Dec 2008 11:31:33 -0500, Ira Solomon <isolomon[ at ]solomonltd.com> >wrote: > >>I have a standard frontend/backend setup. Now the user wants a front >>end in which he can write some reports and queries. I need to link >>that backend as read-only. Is there a simple way to do this? >>Right now the system is in 2003 so I owuld like to know how do this >>this in DAO and ADO. >>Thanks. > >And the problem being...? > >You can link a read/write frontend to a read-only backend.

Re: Read_Only Kinks John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/13/2008 11:38:15 PM On Sat, 13 Dec 2008 16:06:06 -0500, Ira Solomon <isolomon[ at ]solomonltd.com> wrote: [Quoted Text] >I just haven't found the syntax. >In the current system it goes through the tables in the backend and >links the tables with no trouble. But this is read/write. >I haven't been able to to find where I put in a "readonly" parameter. Hit it with a sledgehammer: set the Windows security on the backend folder to read only for the users you want to lock. -- John W. Vinson [MVP]