Linking Primary Key To Foreign Key

I am creating an Access database from excel. In the code I get the Database and Tables name from Excel spread sheet and assign them to variables.

In the first table, & tblNamePrime &, I create a Primary Key called, [PrimeRecId]. I create a second table, & tblName & and try to create a Foreign Key called, [RecId] and try to Reference it to the table, & tblNamePrime & [PrimeRecId]. I always receive the following error message:

Syntax Error in CONSTRAINT Clause
-2147217900(80040e14)

If I remove the code in blue it creates the tables but then I need to go th access and link them by access

I have tried many different ways and have followed instructions from SQL, Access VBA and I am unable to Link the Primary Key to the Foreign Key.

I am new at trying to tie Excel to Access and SQL.

The code below is just 2 tables but when I am done there will be a total of 4 tables all linked back to the first table.

Private Sub RDCModel()
Dim dbConnectStr As String
Dim Catalog As Object
Dim cnt As ADODB.Connection
Dim dbPath As String
Dim tblNamePrime As String
Dim tblName As String

'Set database name here
'MsgBox "Current user is " & Application.UserName
dbPath = ActiveSheet.Range("C1").Value 'Database Name.........