pedro at plex.nl
pedro at plex.nl
Wed Dec 29 12:20:36 CST 2004
Hello Group,
i converted a A97 database to A2003. The conversion went ok, no compiling errors. This database is secured by an mdw. When trying to do a mailmerge from a form i am getting an error: 5922, source could not be opened. In the code itself, nothing was changed (except the name of the database, i checked the name several times). The odbc, in the user-DSN, the database, the mdw, the registrationname and password are correct.
Also when doing the mailmerge from the form, i get a datalink box, where i fill in the odbc data. This is giving a message that the connection is ok. The error in the code is highlighting the following part:
OpenDataSource _
Name:="P:\Cytologie\positieven\" _
& "BeveiligdPOSITIEVEN(XP).mdb", _
ReadOnly:=True, LinkToSource:=True, _
Connection:=strConnect, _
SQLStatement:="SELECT * FROM [Uitvoer], [tblHarts] WHERE Uitvoer.AanvragerID = tblHarts.AanvragerID AND Uitvoer.ControleID = " & Forms![Brief]![veld] & ";"
Anybody any idea's
Pedro Janssen