Help!
I have a VFP program that needs to read in an Access database in a CD-ROM.
The CD-ROM will be changed each month, for example: Jan99.mdb, Feb99.mdb, Mar99.mdb
I have created a project with a remote view named "FRONTIER" to point to the Access database.
When I run the VFP program to open the view using the command: USE FRONTIER, a window pops up asking me to select the name of the Access database file.
Is there a way I can program VFP so that I don't have to select the Access database file when I use the VIEW command. Fox example:
USE VIEW in M:\JAN99.MDB <= I know this does not work! M: is the CD-ROM drive

Thanks in advance