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

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

--
HTH
Van T. Dinh
MVP (Access)



"Joe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> .
> .
> Set DB = DBEngine(0)(0)
> Set RS = DB.OpenRecordset("tbl_Attachments")
> .
> If right(CStr(RS.AttachUNC), 1) = "\" Or
> right(CStr(RS.AttachUNC), 1) = "/" Then
> .....
>
>
> My intention is to upgrade the application to use ADO, but I need
> to find an ADO equivalent to this AttachUNC method.
>
> Does anyone know the ADO equivalent for the AttachUNC method?
>
> Joe
>