[AccessD] Make-table query points to c:\documents and settings?!

Hi Sad

If this is inconvenient, you may try to run the command

   ChDir <your path to the temp database file>

before running the make table queries because your problem is that
they try to write to a file in the current directory of the drive and
the current directory may be whatever.

/gustav


> Hi Sad

> Then I will suggest you rewrite the SQL to include the full path.

> /gustav


>> I build it in SQL view. There's no path in there
>> either... :-(

>>> Switch from design view of the query to SQL view ...
>>>
>>> > No, where can I do that?
>>> > I looked at the properties but I just saw in wich db
>>> > the tables will be created. Not the path!
>>> 
>>> >> So did you specify the full path of the tables in
>>> >> those make-table
>>> >> queries?