Should i learn Access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason (Jason_at_discussions.microsoft.com)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 07:43:01 -0700

Hello everyone,

Here's my situation: I know very little about databases but need to create
one for my company. It would be a relatively simple DB, where employees
access it at different times and enter data, but i don't want them to be able
to modify another employee's data. For example

1 - 203943 Jeremy
2 - 283948 Frank
3 - 201029 Sarah

etc, etc.

I want each employee to be able to access the DB and enter info next to a
number, but not be able to modfiy any of the other's data. Also, i want the
whole spreadsheet to be visible to all. I imagine this has something to do
with permissions and assigning them, etc.

Does Access give me the options to do this, or should i learn another
database utility? I don't want to learn it if it isn't going to give me
these options.

Thanks very much in advance for any help you may be able to give.

Jason

Relevant Pages

  • Re: Data Access Objects?
    ... >>this Employee class, not Employees table directly, and that you should ... >This decoupling allows the application to use any form of persistence, ... >including databases, flat files, flash memory, or even persistent RAM. ... >Data Access Objects (DAOs) are intermediate forms. ...
    (comp.object)
  • Re: Im Going Crazy, HELLLLPPP!
    ...  Relational databases are a lot more complicated than the ... Companies have one or more Employees. ... one or more badges over his tenure. ... diagram the database and then put in foreign keys. ...
    (microsoft.public.access.formscoding)
  • Re: Reference Question
    ... Can't you just implement a delete trigger on the Employees table? ... you would query the other databases for the existance of that ... we're finding that we're referencing these tables from other ...
    (microsoft.public.sqlserver.programming)
  • Pointers on designing web-portal
    ... I have an idea to create a small web-portal/community for a group of ... will be private and only open the the employees of my company. ... My first task was to make this portal password protected. ... Should i go for several small databases or one big? ...
    (microsoft.public.scripting.vbscript)
  • Re: Moving the Exchange data and log files.
    ... inheritance rules for that folder and all progeny. ... How to move Exchange databases and logs in Exchange Server 2003If you want ... Assuming it is a Microsoft KB, set the permissions to what the KB ...
    (microsoft.public.windows.server.sbs)