hello,
The following codes work fine for me, but when other users run the executable, the system will prompt them for database. Can anyone help ?

OPEN DATABASE ID_CARD
CREATE CONNECTION Myconn DATASOURCE "MS Access 97 DATABASE" ;
DATABASE F:\APPS\ELITE2K\AMHPOLCY.MDB
system will prompt user to enter a database file

CREATE SQL VIEW POL_VIEW REMOTE ;
CONNECTION MYCONN SHARE AS ;
SELECT Vehicles.Vehicle_ID, Vehicles.Model_Year, ;
Vehicles.Make,Vehicles.Model, Policies.Subproducer,;
Policies.First_Name,Policies.Last_Name, Policies.Addr1,;
Policies.Addr2, Policies.City,Policies.State, ;
Policies.Zip, Policies.Date_Effective,;
Policies.Date_Expiration, Policies.Policy_ID;
FROM Policies Policies, Vehicles Vehicles;
WHERE Vehicles.Policy_ID = Policies.Policy_ID

the system will prompt use to enter a database file again right here.

what did I do wrong??
sherry