I am using a function

set fs = application.filesearch
this is giving me an error that the filesearch is not recognised

what object under references must I install to use this function.

I have 2007, but saving the access database as a 2003
Thanks
--
Graeme

Graeme wrote:
> I am using a function
>
> set fs = application.filesearch
> this is giving me an error that the filesearch is not recognised
>
> what object under references must I install to use this function.
>
> I have 2007, but saving the access database as a 2003
> Thanks

As far as I know, the FileSearch thingie is removed in the 2007 version.
For other methods, I'd suggest having a look at Douglas Steels article
http://my.advisor.com/articles.nsf/aid/16279, or perhaps Allen Brownes
article http://allenbrowne.com/ser-59.html

--
Roy-Vidar

you cant use a database that’s from 2003 if the format is from 2007 you
should download a convert file and that's all you have to do

Have a nice day

"Graeme" <(E-Mail Removed)> wrote in message
news:57A48D09-23FC-4C70-9A6F-(E-Mail Removed)...
> I am using a function
>
> set fs = application.filesearch
> this is giving me an error that the filesearch is not recognised
>
> what object under references must I install to use this function.
>
> I have 2007, but saving the access database as a 2003
> Thanks
> --
> Graeme

What are you trying to say?

Access 2007 works fine with the Access 2003 file format.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rommel Fuentes" <(E-Mail Removed)> wrote in message
news:8240EA07-C050-4751-AD7C-(E-Mail Removed)...
> you cant use a database that's from 2003 if the format is from 2007 you
> should download a convert file and that's all you have to do
>
> Have a nice day
>
> "Graeme" <(E-Mail Removed)> wrote in message
> news:57A48D09-23FC-4C70-9A6F-(E-Mail Removed)...
>> I am using a function
>>
>> set fs = application.filesearch
>> this is giving me an error that the filesearch is not recognised
>>
>> what object under references must I install to use this function.
>>
>> I have 2007, but saving the access database as a 2003
>> Thanks
>> --
>> Graeme
>