Creating tables in another table of the same directory

[R Bolling]

My question is based on the following scenario:

If you put two MDB files on a network share such as:

\\ServerName\Shared1\Main.mdb
\\ServerName\Shared1\Temp1.mdb

You can copy a table from Main.mdb to Temp1.mdb as follows:

From Main.mdb:
Select Field1, Field2, Field3 into Test in
'\\ServerName\Shared1\Temp1.mdb'_
from qryFinal;

If Main.mdb and Temp1.mdb are copied to another directory, what would
be the syntax of the select statement -- as long as both MDB files are
in the same directory?

Any help appreciated!

RBollinger

[R Bolling]

I just read my own post and got confused! Cheezzzzz

What I'm asking is simply: What is the VBA used to create a table in
another MDB file that is in the same directory as the first MDB file
(i.e., so the two MDB files can be placed in any directory and still
work)
The first example there are two mdb files:

Direcory C:\Shared1
Main.mdb
Temp1.mdb
From Main.mdb if you can execute:
Select Field1, Field2, Field3 into Test in _
'C:\Shared1\Temp1.mdb' from qryFinal;

But what is the syntax if you want it to work regardless of the
directory you execute it from?

Something like ? ? ?

Select Field1, Field2, Field3 into Test in _
'.\Temp1.mdb' from qryFinal;

Thanks,

RBollinger

[Jack MacDonald]

Use the Currentdb.Name property to determine the full path of the
current database. Parse the name to determine the path, and construct
the name of the second MDB file accordingly.

On 7 Jul 2004 13:18:39 -0700, ro*****@hotmail.com (R Bolling) wrote:

I just read my own post and got confused! Cheezzzzz

What I'm asking is simply: What is the VBA used to create a table in
another MDB file that is in the same directory as the first MDB file
(i.e., so the two MDB files can be placed in any directory and still
work)
The first example there are two mdb files:

Direcory C:\Shared1
Main.mdb
Temp1.mdb
From Main.mdb if you can execute:
Select Field1, Field2, Field3 into Test in _
'C:\Shared1\Temp1.mdb' from qryFinal;

But what is the syntax if you want it to work regardless of the
directory you execute it from?

Something like ? ? ?

Select Field1, Field2, Field3 into Test in _
'.\Temp1.mdb' from qryFinal;

Thanks,

RBollinger

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

[R Bolling]

Thank you -- brilliant solution

Jack MacDonald <ja**************@telus.net> wrote in message news:<tm********************************@4ax.com>. ..

Use the Currentdb.Name property to determine the full path of the
current database. Parse the name to determine the path, and construct
the name of the second MDB file accordingly.

On 7 Jul 2004 13:18:39 -0700, ro*****@hotmail.com (R Bolling) wrote:

I just read my own post and got confused! Cheezzzzz

What I'm asking is simply: What is the VBA used to create a table in
another MDB file that is in the same directory as the first MDB file
(i.e., so the two MDB files can be placed in any directory and still
work)
The first example there are two mdb files:

Direcory C:\Shared1
Main.mdb
Temp1.mdb
From Main.mdb if you can execute:
Select Field1, Field2, Field3 into Test in _
'C:\Shared1\Temp1.mdb' from qryFinal;

But what is the syntax if you want it to work regardless of the
directory you execute it from?

Something like ? ? ?

Select Field1, Field2, Field3 into Test in _
'.\Temp1.mdb' from qryFinal;

Thanks,

RBollinger

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security