Table in wrong MDB

[Shell]

In Access 2000, I have created a data MDB where by data tables reside.
However, when I execute a MakeTable query, the link to the data MDB is broken
and the table is created in the code mdb.

How do I prevent this and get the table created in the proper mdb

Thanks

 

[Klatuu]

Here is an example:

SELECT tblClient.[ClientID], tblClient.[IsCorporate], tblClient.[MainName],
tblClient.[FirstName], tblClient.[AddressL1], tblClient.[AddressL2],
tblClient.[City], tblClient.[Zip], tblClient.[State], tblClient.[LevelID],
tblClient.[EnteredOn] INTO _Fingle IN 'C:\Access\CovertOps\CovertOps.accdb'
FROM tblClient;

But, I personally don't like to use make table queries. I prefer building
the table like I want it with the data types predefined. Then I delete the
old data from the table and use an append query to populate the table.

 

[Douglas J. Steele]

An alternate syntax that I prefer is

SELECT tblClient.[ClientID], tblClient.[IsCorporate], tblClient.[MainName],
tblClient.[FirstName], tblClient.[AddressL1], tblClient.[AddressL2],
tblClient.[City], tblClient.[Zip], tblClient.[State], tblClient.[LevelID],
tblClient.[EnteredOn]
INTO [;Database=C:\Access\CovertOps\CovertOps.accdb].[_Fingle] FROM
tblClient;

but I have to agree with your comments about make-table queries.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here is an example:

SELECT tblClient.[ClientID], tblClient.[IsCorporate],
tblClient.[MainName],
tblClient.[FirstName], tblClient.[AddressL1], tblClient.[AddressL2],
tblClient.[City], tblClient.[Zip], tblClient.[State], tblClient.[LevelID],
tblClient.[EnteredOn] INTO _Fingle IN
'C:\Access\CovertOps\CovertOps.accdb'
FROM tblClient;

But, I personally don't like to use make table queries. I prefer building
the table like I want it with the data types predefined. Then I delete
the
old data from the table and use an append query to populate the table.

--
Dave Hargis, Microsoft Access MVP

In Access 2000, I have created a data MDB where by data tables reside.
However, when I execute a MakeTable query, the link to the data MDB is
broken
and the table is created in the code mdb.

How do I prevent this and get the table created in the proper mdb

Thanks

 

[David W. Fenton]

but I have to agree with your comments about make-table queries.

MakeTables are something a developer or user should run to create a
table structure. They oughtn't be part of an app's regular tasks.