Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Product Database
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Product Database
Resolved · High Priority · Version 2003
Reply
Product Database
Hi,I'm currently in the process of creating a product information database for my company. Contained in this database will be all information relating to each individual product we produce. What I want to create is a database that my colleagues can open to view the information required and be able to search for particular things (product codes,categories, etc) without them being able to modify any of the information contained within the database. I also only want them to see a 'front page' that will display information on 1 product at a time.
To do this, would I create a read only form that my colleagues can access that's linked to the table containing all information or is there a simpler way of doing it?
For upcoming training course dates see: Pricing & availability
RE: Product Database
Hi CraigThe simplest way of doing what you require is by creating a read only form for your colleagues to access.
Although this will prevent your colleagues from changing the data through the form, if they have access to the whole database they could still change the data on the tables.
Therefore, in future, you may need to look at setting up user groups and permissions if you only want them to access the relevant read only forms.
hope this helps
Carlos
|
 |
|
» Forum post: Microsoft Office 2007 |
Will excel files in 2003 with complicated formulas be copied into 2007 and be accessible?
