Prompting for a file name when linking to dBASE file

G

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?
 
M

MGFoster

Dan said:
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?
Click to expand...

-----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-----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search criteria in query 7
How stop Append from sorting records? 3
Linked table to mapped network drive 1
export query to dbase with fixed field length 2
Query on dbase files with access and VBA 3
Querying of tables that are linked 1
Use of the SUBST command to reduce breakage of Access links 2
Dbase Crazy Flicker Crash 3

Top