Prompting for a file name when linking to dBASE file

[Guest]

I need to link my application to a dBASE file and I want to allow the
customer to input the name of the dBASE file; what is the best way to do
this? Can I have a query ask for the name of the file and create the link?

 

[MGFoster]

I need to link my application to a dBASE file and I want to allow the
customer to input the name of the dBASE file; what is the best way to do
this? Can I have a query ask for the name of the file and create the link?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Look at this site.

http://www.mvps.org/access/api/api0001.htm

It explains how to use the file browser to get a user-selected file
name. Then you can use the TransferDatabase method of the DoCmd object
to attach the dBase file.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAik14echKqOuFEgEQLgtACg4MVzAFyGAPJBWZvVDR8vvi/iRekAnier
/DvHTnlouGgRP4VXjcPvmKCL
=2SlM
-----END PGP SIGNATURE-----