Hi Sherry!

Check your odbc for "MS Access" -- Do you have a data base selected?

>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