Aha!!! It seems that I have located the problem.

Years ago, we had an outside consultant design a Laboratory Management System. (A web app that ran on the sql...

Ok...I did some reading last night, and since I didn't know anything about Access Data Projects, I figured I better find out. (Boy was I embarrassed when I discovered that...

Brian,

I'll have to try your idea in the morning.(have an appointment this evening)

But I will say that within the User and Group permissions, Everything is selected...Read/Insert/Update/Delete. I can deselect...

Nelson,

Just for an example (Since I tore down all the permissions before I started this discussion)

I have a user bsmith

She has a windows login, which has been added to the...

I've tried both types of Authentication Nelson. The problem with the sql Server authentication is that it requires the users to log in each time they open the Access...

Thanks Nelson,

I checked out the Owner idea and Nope...it was free of that sort of thing. Good idea though. Made sense. Still makes me wonder about whether Access...

Thanks Brian,

Well, I'm using Access 2003 and Sql Server 2000 sp2

From what you are saying, this should be working. Maybe it's just one of those situations where I did...

Well..the main problem is that, regardless of the sql permissions setup, all users have full read/write access to the entire table.

Here's one scenario: On a Customer Specification table/Form....I have...