Could you post this in a new thread and post your table structure and some sample data? hard to tell without some details.

You're welcome. Post back if you get stuck.

Surfed around for a second and found this:

http://stackoverflow.com/questions/7542517/call-a-stored-procedure-with-parameter-in-c-sharp

then you'd just call the stored procedure that way.

The code I provided...

This is one option.... kinda sloppy, but it works:

ALTER PROCEDURE uspAddEventParticipant

@ParticipantID INT,

@EventID INT

AS

BEGIN

SET NOCOUNT ON;

DECLARE @MaxEventsPerParticipant TINYINT = 2; -- just makes this a lot easier to modify...

IF (SELECT COUNT(*)...

you could create a stored procedure to do the insert and prior to actually doing it, check the existing count of records for that user and cancel/not do the insert...

To add to what Wendell said, there are several things you need to be aware of when using Access as a front end to SQL Server. To take advantage...

I would check Paul Randal's blog for some ideas. Maybe start here: Troubleshooting Transaction Log Growth[/url]

So far, no joy... I tried it. Works fine if the ToolTip has only a text value. Doesn't appear you can pass an image to it, though.

I...

Oops... oh well, gotta leave something for the OP to do!!!

Did i miss it, and this is in a report?

I tweaked your query to turn it into a stored procedure, just to make it easier to call in SSRS.

ALTER PROC...

Without sample data, this is hard to answer. Care to share? Or did you already figure it out?

LOL!!!! Well, no wonder I've been having such a rough go of it. Guess I gotta learn to program better, since I can't make the Aspergers go away... might...

that would be too easy... it's LEN()

You can shrink the database, but you'll need to rebuild all the indexes, because shrinking the DB makes a mess of the indexing.

I can't claim to be an expert on the subject, but here's a good article by Itzik Ben-Gan that shows different ways to do it and the performance of each...