Yin
Set DATABASE to [PathToFDriveDBC] ?
(and maybe you need first to OPEN DATABASE [PathToFDriveDBC])
HTH
Terry
>I have two database have same name, one is on C:\, another is on F:\,
>both are same name and same structure.
>I use SET DEFAULT TO F:\ and SET PATH TO F:\ to define the access path of the database, but the USE command still open the database which is in C:\.
>
>Why ?
>The following code is in the Form's INIT method.
>
>
>SET DEFAULT TO f:\yim\data\
>SET PATH TO f:\YIM\DATA\
>USE yim!invoice IN 0 ALIAS invoice SHARED
>SET ORDER TO 1
>
>
>Please advise.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.