467,169 Members | 965 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

How to link ALL data with an specified PROJECT, create ACCOUNTS for users, and "EXE"

Hello guys, i just started developing a database for my company which will help a department to build BILL OF MATERIALS (BOM) of different projects. The main idea is that FIRST the user will CREATE/SELECT the PROJECT so that he can start creating or modifying all the info under that project. Once the user has selected the PROJECT, FIRST the engineer will enter engineering data through the ENGINEERING form, THEN the costing department will add/modify data regarding ONLY the PRODUCTS ALREADY ENTERED by the engineer, finally the PRICING deparment will do the same. (COSTING and PRICING can ONLY work with the already created ENGINEERING data).

Iam quite a beginner with access and i need your help with 3 things:

1.- How can i setup different "authorizations" or "users" so that ONLY the engineer can change engineering data, only costing deparment can modify costing info, etc..?

2.- Once all forms and reports are finished how can i make the database executable?? (as in the user only has to double click a file name and the database will open with the PROJECT form which will then take it to the ENGINEERING table, COSTING, PRICING...)
[indent]3.- How should i create the relationships so that ALL DATA for EVERY diff PROJECT is stored under different project tables, so that when you select a project it will take you to its specific data????

I also wanted to paste you a picture of my current relationships so that i could get an insight if they are correct or if i should make any changes but i couldnt paste the picture. Can you tell me how can i add a picture to the post.

Thank you very much, i hope to get help soon and that i followed correctly the posting rules.

Attached Images
File Type: jpg relationships.JPG (20.9 KB, 152 views)
File Type: jpg ENGINEERING FORM.JPG (22.4 KB, 139 views)
File Type: jpg PROJECT FORM.JPG (11.2 KB, 160 views)
Aug 30 '07 #1
  • viewed: 1252
2 Replies
Expert Mod 8TB
You are asking too much for one question. Break out your question into smaller individual questions and ask them separately.

Sep 2 '07 #2
Hire a consultant or buy an off-the-shelf solution. This is NOT a job for a beginner. Coding errors or security breaches could easily cost your company ten times the development cost.
Sep 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by marco | last post: by
3 posts views Thread by Martin Ink | last post: by
2 posts views Thread by Dean Slindee | last post: by
2 posts views Thread by Anthony | last post: by
reply views Thread by Waldy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.