Permission in database

From: Shailesh (shailesh@geminicorp.be)
Date: 08/02/02 

From: "Shailesh" <shailesh@geminicorp.be>
Date: Fri, 2 Aug 2002 00:56:10 -0700

Dear Friends

My company is having database in access and due to that
reason the performance is very slow.Hence we have decided
to go for the SQL server.

With the upsize wizard in MS-Access I have made all the
tables and funtions which are working very fine but the
only problem i have is to give permission.

I have 25 users working on the same database which
includes the table of

1) Sales
2) Purchases
3) Customer

And following are my users ( Groups )

1) Administrator -: One who can do anything in the
database.

2) Only Read permission users on all Tables

3) AccountDep : Who update the database of Sales and
Purchase but not customer they have only right of Read on
the purchases.

4) Sales Person: Who Update the Table of Sales ..

Kindly suggest how i can give the permission to all so
that there will not be any security laps.

Your reply will help me to perform best.

Thanks in Advance

Relevant Pages

  • Re: Proper use of database splitting
    ... If it were me Id set it up as similar to a sales logic ERP program that a ... Main database backend on the server has everything. ... the process of doing this all of his customer records gets a CustCheckedOut ... Sales rep comes back with a boat load of sales and new accounts. ...
    (microsoft.public.access.formscoding)
  • Re: Can databases form automatic calculations?
    ... Basically I would like to know if there is some way to get a database ... All my product sales are ... Anyone know the MySQL function syntax for this if it is possible? ... The user interface is the SQL language which can be invoked ...
    (comp.databases)
  • Re: Proper use of database splitting
    ... Put the master backend template on the server so that all sales reps use the ... Also require all sales reps to put their backend database ... upload and down load customer databases and not need to do anything else. ...
    (microsoft.public.access.formscoding)
  • Re: Can databases form automatic calculations?
    ... Basically I would like to know if there is some way to get a database ... All my product sales are ... Anyone know the MySQL function syntax for this if it is possible? ... The user interface is the SQL language which can be invoked ...
    (comp.databases)
  • Re: Thank you with Design Assistance but...
    ... Although each Access database is limited to 2G, ... (StoreID in the sales table) ... You saw the simple queries that I ... Also how would I write the queries for, lets say, One Store, week ...
    (microsoft.public.access.tablesdbdesign)