Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access on Terminal Server - error opening form - runtime error 2001

Status
Not open for further replies.

NightZEN

Programmer
Apr 29, 2003
142
US
I am running an Access Database on a terminal server (Windows2003) that connects to a SQL-Server back end. I am having trouble running this code:

Code:
Private Sub Command13_Click()
Dim strChange As String
 strChange = Me!ChangeNum
 
    DoCmd.OpenForm "FrmChanges", , , "ChangeNum =" & strChange
    
End Sub

when I Click the button in debug mode i get an error:

runtime error 2001
You canceled the previous operation

When not in debug mode, I get no error, but nothing happens. This code works fine on a normal XP box running locally. Any idea's?

Thanks
 
FYI Update:

I also get this error when I open the database, though the database continues to load:

Windows cannot find 'C:\Program Files\Database.mdb'. Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top