Not trying to be snarky but did you try looking it up on google? This is the very first link when searching for "Access Like". It explains it very clearly....

Are you familiar with the like operator?

Same thing as in sql server. It is a parameterized query using the like operator.

What defines a cluster? You need something to indicate what each grouping should be.

There could be several things. Without anything to go on it is impossible to tell. We would need to see your select, ddl for the underlying tables and some sample...

What exactly are you trying to do? Are you wanting to pass a different set of parameters to an existing stored proc?

You said you were more of a front end person than a db person. Try thinking of your database as a place to store your front end information. You might...

What operation? select, insert, update, delete, drop, truncate, alter? What table level permissions does the user have? We keep asking for some details and you are not providing anything to...

No No I said I agree with you that the OP's table structure is not the greatest. I knew you didn't design that.

--edited because even my clarification required some clarification.

I have to agree with WelshCorgi that your table structures are less than optimal, of course there are some other pieces of this that you mentioned are not here. Given...

The permission may have been revoked for some tables for that user.

Not sure what the question is here.

Any chance you can create some sample data (preferably insert statements)? That will let me get to work quickly on the problem at hand instead of spending my time getting...

Alright unless somebody else jumps in I will take a look in the morning. Gotta get the kids to their swimming lesson. 😉

Ahh so you need to modify a couple of other tables when a record deleted from the VoucherServices table? Probably the best solution for this is a delete trigger. Simple,...