Forum Home
Press F1
Thread ID: 69403	2006-05-31 08:13:00	Access and queries	pico (4752)	Press F1

Post ID	Timestamp	Content	User
459377	2006-05-31 08:13:00	Hi all, Just ran into something today. If I want to restrict users from editing the data in a table in an Access DB can I just create a query that displays all the table data? I noticed that when I try to delete records in a query that it didn't update my table. If this is so then it would be a useful way to restrict users from corrupting data. Thanks	pico (4752)
459378	2006-05-31 08:44:00	I think what you came across today was (maybe?) a record locking conflict which prevented the records from being deleted. With multi-user databases it is preferable to have pop-up and modal forms that guide users down the correct paths to prevent them inadvertently corrupting the data, rather than relying on having an open but hidden form in the background that locks all the records. Control and integrity can be further achieved by setting the record lock properties on the relevant forms as well as setting whether users can edit or delete data through that form. Andrew	andrew93 (249)
459379	2006-06-01 10:56:00	As I understand it, tables are the base or foundational objects in a relational database. When you create a query, it is a new object that is built from tables but exists independently. Doesn't that explain why you can delete out of a query but the original tables remain the same?	johnd (85)
459380	2006-06-01 23:23:00	That's correct. The tables are the ones you change if you want to delete or add stuff. A Query just accesses the data that's in the tables. You can get the query not to look for items that are there, but you have to go back to Tables to delete or add stuff. Joe Davies	Joe90Davies (10442)
459381	2006-06-02 08:44:00	That's not quite correct. You can add and delete records in a simple select query (single table) and you can also delete records using a delete query. You are correct in that you can't delete records in a multi-table, a crosstab, or a totals query....but that said, I wouldn't rely on using a query to prevent users from deleting records. A	andrew93 (249)
1