Error: 18456 Severity 14 SQL State:38

• Steven.g.karpowicz

  SSC Veteran

  Points: 222

  More actions

  October 31, 2009 at 9:48 am

  #216278

  I have been Googling trying to find out the Syntax to explicitly call a SQL Data base? I know this seems like a very easy thing but I can not seem to find out how to do it.

  I have a DSN connection to SQL server and it test out fine with no Errors. I am trying to add a new table to my SQL data base from Access using the Do CMD. I checked the SQL SErver log an I am getting the above Error message. The data base I am trying to connect to is [FA_Jobs] and I am trying to add a table [MJRI_New] to it.

  The actual command is below:

  DoCmd.SetWarnings False

  DoCmd.TransferDatabase acExport, "ODBC Database", _

  "ODBC;DSN=WaveTest;DATABASE=PETER", acTable, "MJRI", "[FA_Jobs].[dbo].[MJRI_NEW]"

  I thought by including the Database name infront of the new table "Explicitly Specified the database", but apparently not.

  I know I am missing something very easy but I can not seem to see it.