Charlotte Foust
cfoust at infostatsystems.com
Wed Apr 21 11:53:06 CDT 2004
In an MDB, if you don't specify the primary index when you link the table, it won't be updateable at all, even if it has a primary key. Charlotte Foust -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Wednesday, April 21, 2004 8:27 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] What am I forgetting? - SQL Permissions Just an addendum to this. If any table lacks a primary key, you won't be able to insert rows from Access (at least ADP filetype; I haven't checked the MDB file type). Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Monday, April 19, 2004 9:18 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] What am I forgetting? - SQL Permissions 1) Right click on the name of any table, sproc, or view. 2) Choose "All Tasks" 3) Choose "Manage Permissions" As a general rule, you should not allow users access to the tables themselves. Inserts, Updates, and Deletions should all be handled through sprocs and views. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows Sent: Monday, April 19, 2004 7:56 AM To: Dba-SQL Subject: [dba-SQLServer] What am I forgetting? - SQL Permissions First of all, I am an SQL Novice, just kind of feeling my way thru things. I have just recently set up my SQL Server 2000, and tried to run an Access 2002 database against the SQL tables. Links are fine, I can view all the data, but I cannot remember where I adjust the settings to allow me to add or delete from the tables. I am suffering from a severe case of brain dead / spring fever (it was in the mid 80's here today) TIA Jeff Barrows Outbak Technologies, LLC Racine, WI www.outbaktech.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com