Viewing 15 posts - 14,386 through 14,400 (of 15,381 total)
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....
July 25, 2011 at 3:02 pm
Are you familiar with the like operator?
July 25, 2011 at 2:56 pm
Same thing as in sql server. It is a parameterized query using the like operator.
July 25, 2011 at 2:45 pm
What defines a cluster? You need something to indicate what each grouping should be.
July 25, 2011 at 11:58 am
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...
July 25, 2011 at 10:06 am
What exactly are you trying to do? Are you wanting to pass a different set of parameters to an existing stored proc?
July 25, 2011 at 10:03 am
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...
July 25, 2011 at 9:18 am
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...
July 25, 2011 at 7:09 am
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.
July 22, 2011 at 3:30 pm
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...
July 22, 2011 at 3:19 pm
The permission may have been revoked for some tables for that user.
July 22, 2011 at 10:24 am
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...
July 22, 2011 at 8:12 am
Alright unless somebody else jumps in I will take a look in the morning. Gotta get the kids to their swimming lesson. 😉
July 21, 2011 at 3:03 pm
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,...
July 21, 2011 at 2:52 pm
Viewing 15 posts - 14,386 through 14,400 (of 15,381 total)