Workgroup File

  • Thread starter Thread starter Sapphire
  • Start date Start date
S

Sapphire

Hi,

The Access database I upsized has a workgroup file which
has about 100 users. How do I upsize this so that when an
user opens the ADP file, a login page comes up and they
only have the granted permissions. Is there a wizard or
something I can use to do this?

I am totally new to this and would greatly appreciate any
help. Thanks in advance.
 
You UPSIZED Access database to SQL Server/MSDE, right? So, the ADP file is
simply a front end application to the SQL Server/MSDE. SQL Server/MSDE has
its biult-in security features, which is not the same as Access's user level
security feature. Yu do not upsize Access DB's workgroup file to SQL Server.
You deal with user logging in and permission inside SQL Server/MSDE.

You probably need a bit study on SQL Server/MSDE's security features.
 
Back
Top