If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How allow users to modify and create reports?
Is there any way to allow users to modify and create reports without
compromising the integrity of the database. I guess I need a way of making all existing reports, forms, queries and modules read-only. Or can I make them invisible like the 'Sys' prefixed tables. Is there any way to disallow UPDATE or DELETE in queries? I'd prefer to not use user-level security. |
#2
|
|||
|
|||
How allow users to modify and create reports?
If you make your application into an MDE then users will not be able to
modify forms and reports. Tables and queries are always modifiable unless you implement user-level security. You can name your objects "usysWhatever" and they will become hidden. If you want a solution that allows users to create custom query/reports, consider the query by form applet available at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane -- Duane Hookom MS Access MVP "mscertified" wrote in message ... Is there any way to allow users to modify and create reports without compromising the integrity of the database. I guess I need a way of making all existing reports, forms, queries and modules read-only. Or can I make them invisible like the 'Sys' prefixed tables. Is there any way to disallow UPDATE or DELETE in queries? I'd prefer to not use user-level security. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can i Create or Modify the AutoText List List's | Martyn Green | General Discussion | 4 | November 3rd, 2005 10:17 PM |
Best Practice | LMB | New Users | 4 | November 22nd, 2004 11:17 AM |
I CANNOT CREATE OR MODIFY REPORTS WITH ACCESS 2003 SP1 | THEBMIKE | Database Design | 3 | October 21st, 2004 08:59 AM |
Can I move the MDW file? | Damien McBain | General Discussion | 7 | September 28th, 2004 09:54 AM |
modify heading 2 style in Word xp | sam | New Users | 6 | June 9th, 2004 12:03 AM |