AttachUNC Method

[Joe]

Hi,

I am upgrading a database from Access 95 to Access 2003 format.
The original developer is long gone, so nobody to ask questions.

He used a Recordset object that contained method named AttachUNC
like this.

Dim DB As Database, RS As Recordset

 

[Van T. Dinh]

I may be wrong but it looks to me that AttachUNC is simply a Field name in
your Table??? I think in old code, the dot (.) operator can be used with
the Field name to refer to the Field in the Recordset:

If this is the case. Change your code to:

RS.Fields("AttachUNC")

or the abbreviated version using the default properties Fields:

RS!AttachUNC

BTW, for safe coding (since we have Recordset in both DAO and DAO Recordsets
and ADO Recordsets are not compatible), change your decs to:

Dim DB As Database
Dim RS As DAO.Recordset