Table in wrong MDB

S

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
 
K

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.
 
D

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!)


Klatuu said:
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


Shell said:
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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top