Table in wrong MDB

  • Thread starter Thread starter Shell
  • Start date Start date
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
 
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.
 
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
Click to expand...
Click to expand...
 
but I have to agree with your comments about make-table queries.
Click to expand...

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.
 
Back
Top