Workgroup File

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.
 
N

Norman Yuan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.mdb or .adp which is best to use with SQL 2K 10
What's the steps to modify a .adp connect string & convert DAO to 2
Queries missing in ADP and SQL after upsizing 4
Alternatives to ADP? 8
Packaging ADP project 1
upsizing with autonumber 1
SQL security permissions 1
ADP project is ReadOnly after using Upsizing Wizard 2

Top