Access DoCmd.OpenForm

0
votes

I developed a project for warehouse. The application user interface is on MS access and database on MS Sql Server 2008. The problem is that when below statement is executed it generate error.

“DoCmd.OpenForm  stDocName, ,  , stLinkCriteria”

The error is that:

Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error:17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

1
sql-serverms-access
The error message seem straight forward to me. What troubleshooting steps have you taken so far? - Kefash
Are those quotes around your pasted code only in this post or also in your code? - Zaider

1 Answers

0
votes

  1. Remove the link criteria and see if the error goes away.

  2. If the form has an underlying data source, try to open that from the database window and see if the error happens.