It's me again, with two syntax errors that I can't for the life of me figure out:

====
The first error:

Error Type:
Microsoft OLE DB Provider for SQL Server
(0x80040E14)
Line 1: Incorrect syntax near ')'.
/1076044226/dbridge/learner.asp, line 53

Code is as follows, with line 53 the last line:

strSQL = "SELECT tblCourseClient.CourseID, tblCourseClient.ClientID, tblClient.ClientCWareTitle, tblClient.ClientNumber "
strSQL = strSQL & "FROM tblCourseClient INNER JOIN tblClient ON tblCourseClient.ClientID = tblClient.ClientID "
strSQL = strSQL & "WHERE ((tblCourseClient.CourseClientID) = " & CCID & ") "
rs.Open strSQL, db

====
The second:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ','.
/1076044226/dbridge/learner.asp, line 115

Here's the code, line 115 is the last line (db.Execute(strSQL):

strSQL = "INSERT INTO tblAccess "
strSQL = strSQL & "(MemberID, CourseID, AccessStarted, AccessStatus, AccessType, ClientID, AccessStart, AccessEnd, AccessCompleteBy) "
strSQL = strSQL & "VALUES (" & MRLearnerID & ", " & CourseID & ", 1, 'Active', 0, " & ClientID & ", '" & StartDate & "', '" & EndDate & "', '" & CompleteDate & "') "
db.Execute(strSQL)

======

Any help will be much appreciated!

there's a problem with the SQL query your trying to execute

On the first one, right before line 53, put
response.write strSQL
then copy/paste here the results and we can analyse the query better.

the seconed one...
Are you using an Access database? If so, dates must be surrounded by # and not '
You can try response.write with that one too. Do all your variables that your inserting contain a value? If any of them do not, then it will break.

OK, here's what I get:

SELECT tblCourseClient.CourseID, tblCourseClient.ClientID, tblClient.ClientCWareTitle, tblClient.ClientNumber FROM tblCourseClient INNER JOIN tblClient ON tblCourseClient.ClientID = tblClient.ClientID WHERE ((tblCourseClient.CourseClientID) = )
Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near ')'.

/1076044226/dbridge/learner.asp, line 53

So it's not pulling in a value for CCID?

Sorry for the delay in my response, I just now had a chance to take a look at your post.

Yes, it looks like CCID is getting nothing assigned to it. You'll need to go back an re-evaluate how it gets populated.