Thanks Julian, that helps a lot. 

I've gotten it to the point where the user would get the permission denied error if they tried to open a table in QA...

Maybe a silly question, but how do define "declaring public permissions"?  When you create a database and add tables, sps, views, etc to it, then you go to the permissions...

I believe the answer really depends on how you define DBA, DA, and other roles. 

At the university hospital where I work, the "DBAs" are responsible for making sure SQL...

I like that idea!  I hadn't thought of that, obviously. 

What if they get put on the same server in production?  Or if they are on the same server in...

Jeff,

Great idea!  Thanks.  I think that takes care of my problem quite nicely.

Jana

I'm not sure what you mean about creating them separately.  I want my FirstLastName to look like:

'Mr. Jeff L Bagwell, Jr'      or

'Mr. Jeff L Bagwell'    or

'Mr. Jeff Bagwell, Jr'        or...

Yes, IsNull helps a lot.  However, when it comes to putting spaces between the fields and not end up with 2 spaces, it gets a little dicey. 

For Example:

Prefix: empty...

This probably won't fix your problem, but your between is looking at the same two variables, startdate and startdate, instead of between startdate and enddate.

My suggestion would be to approach the developers with a goal of compromise and that you are "helping them" accomplish what they need to accomplish.  If the vendor's application requires...

I agree that looping through the recordset within SQL is something to be avoided if possible. However, when I find a TRUE need for it, I use the dreaded...

I'm using Access to produce a report off of this data at the moment. I'm hoping to move to using Reporting Services next month. The data seems to...