How to make attached SQL Server table read-only? KitenutDave 30.11.2005 21:46:08 At the SQL Server database, the users have full add/delete/edit permissions, but I need the tables, when attached to an Access database, to be read-only. How do I do this? I'm attaching the tables in code using DSN-less connect strings -- don't know if that matters or not.

Re: How to make attached SQL Server table read-only? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 30.11.2005 22:53:49 Try creating pass-through queries, instead of linked tables. Pass-through queries are never updatable. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "KitenutDave" <KitenutDave[ at ]discussions.microsoft.com> wrote in message news:223A9971-73C3-4F7A-9165-C2BCA0B28CFE[ at ]microsoft.com... [Quoted Text] > At the SQL Server database, the users have full add/delete/edit > permissions, > but I need the tables, when attached to an Access database, to be > read-only. > How do I do this? > I'm attaching the tables in code using DSN-less connect strings -- don't > know if that matters or not. >

Re: How to make attached SQL Server table read-only? KitenutDave 30.11.2005 23:22:02 Excellent -- that works like a champ. Thanks. "Douglas J. Steele" wrote: [Quoted Text] > Try creating pass-through queries, instead of linked tables. Pass-through > queries are never updatable. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > > "KitenutDave" <KitenutDave[ at ]discussions.microsoft.com> wrote in message > news:223A9971-73C3-4F7A-9165-C2BCA0B28CFE[ at ]microsoft.com... > > At the SQL Server database, the users have full add/delete/edit > > permissions, > > but I need the tables, when attached to an Access database, to be > > read-only. > > How do I do this? > > I'm attaching the tables in code using DSN-less connect strings -- don't > > know if that matters or not. > > > > >