Dear all, I am having some strange problems in creating an Access 2000 

project (.dp) against an SQL Server 2000 database. 



The first problem is: 

Everything seems fine when I run the project as dbo. But when I login 

as a user of a user-defined role, the connection will be lost after I 

do just one or two operations, such as opening a table or view. 



The self-defined role has SELECT, INSERT, UPDATE, and DELETE rights to all 

my tables.



My observation is that only if the user has at least the 

datareader&datawriter rights that the connection will not fail. 



Has anyone had the same problem before? How do I fix it? I certainly

 don't want to give all my users admin rights to the database.





The second problem is:

Unless I assign datawriter roles to a user, the user doesn't see any 

stored procedures in the Access project. However, the user is able to 

run the stored procedures in Query Analyzer. 



What is it? Again, do I have to give admin to every user? 



I am new to Access Projects (.adp), but it seems very buggy to me. Is 

this true? I am worried whether I will ever be able to finish my 

project. Please let me know if you have any useful information about it.



Thanks.



--

JC