>I'm having what I *think* are some security issues with
>Access 2002 ".adp" connected to a SQL Server 2000
>database. This is a small, single server environment.
>From my Access 2002 "adp" client, I can add and delete
>tables and nothing else. I can't add/change/delete
>records, or change the table design. It does not matter
>whom I am logged in as (even admin) or which client I'm
>using. When I go to the server and use the SQL Enterprise
>Manager, I can manipulate the tables and data any way I
>like no matter whom I'm logged in as (regular user or
>On the flip side, I can get into the NorthwindCS sample
>from any client and manipulate tables and data any way I
>want (the Northwind SQL database is on the same server as
>my database). I've logged in as different users from
>different clients as a test and not had any problems with
>What I've done so far:
>1. Created a new adp and database from the client to see
>what would happen. I created a very simple table, then
>tried to enter data and had the same issues as listed
>2. Imported a table from my database to the NorthwindCS
>database, then tried to manipulate data in the imported
>table. No luck.
>3. *Tried* to make sure the security on my database,
>tables and views mimics the NorthwindCS security settings.
>4. Checked my folder settings on the server (the Access
>2002 adp resides there while in development) to make sure
>they are not read-only, and that I have sufficient
>5. Moved the adp to the client and tried to manipulate
>data without results.
>I am pretty new to SQL Server 2000/Windows SBS security
>and development, so I don't doubt that there are things I
>I would appreciate any insight that could be given to
>resolve this issue. If more information is needed, please
>don't hesitate to reply or email (make sure to remove
>the "spambuster" thing!).
>Thanks in advance.
Since you have two machines, one working and one not, try comparing network
and firewall settings between them. Also try to ping the server from both
machines inorder to take Access out of the equation.
Bill Toleman [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
4. Java Games