GUID not allowed in Find Method

We are currently are using Access 2003 and going to start using SQL Server
2008.
We currently have one access application that links to the tables by using a
DSN connection The connection seems to work fine and for the most part the
application works. One problem that we are having is using some of the
dropdown combo box. The following error occurs "Run-time error '3614'": GUID
not allowed in Find Method criteria expression."

Below is the source code for the combo box.

Private Sub Combo3_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[dbo_MemberList].[MemberID] = '" &
Me![Combo3] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

The value of me![Combo3] has the correct guid information

The only thing that has changed is we have changed the application to link
to the new DSN link The rest of our access applications are actual .adp apps
and they all work fine.

Any suggestions would be greatly appreciated.

Thanks in advance
Tsharp


.

Relevant Pages

  • Re: Multiple Apps on System DSN on Server from One PC
    ... > Should I use the same Active-X server for the same in a MS SQL Server ... > DSN connection or is it ok to have multiple apps from the same pc using ... You don't need the ActiveX work-around for SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Ole connection not open sql server
    ... i am using CR 8.0 and vb 6.0 and data base is sql server 2000 my application ... work fine with DSN connection and with ole connection the report is not ...
    (microsoft.public.vb.crystal)
  • DSN connection fails when Basic authentication turned on
    ... When I switch on Basic Authentication, ... that pull information from the SQL server fail to make the ... DSN connection with the following message:- ...
    (microsoft.public.inetserver.iis.security)
  • Re: How to set the network protocol using dsnless connection to SQL Se
    ... If you check the string value of a DSN connection with SQLGETPROP(lnConn, ... with MS SQL Server. ... When I'm using ODBC System DSN, ...
    (microsoft.public.fox.helpwanted)
  • How to have a generic adodc in VB 6.0
    ... I'm using an adodc in a VB6.0 application but I don't know how I can set ... this control to forced to be customisable? ... this control is using a DSN connection in order to connect to a ... But If I deploy my VB program and then I want to change the DSN, ...
    (microsoft.public.vb.database)
Quantcast