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

Gustav,
a big thank you for all the support.

i have rewriten the whole lot!
The creation of the database and I'm using code to
create the tables in that newly created database
instead off calling Make-Table queries. 

I'm now working on a (semi-)automatic relink thingy. 

thnx again.

Sander

--- Gustav Brock <gustav at cactus.dk> wrote:
> 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?
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/