Convert linked table design to local table

Hi!

I need to make a local table with the same structure as a
linked table. All of the methods I have tried (export,
import, cut/paste, copy, etc.) all create the new table
as another linked table. I am sure there is a simple way
to do what I need but so far it has eluded me.

Any suggestions or help is greatly appreciated!

BTW this Access 2002.

Thanks!

Dave Venus

Hi Dave,

Create a MakeTable query pulling from the linked table to create a new
local table.

For your MakeTable query make sure it returns no records. Example:

SELECT dbo_Customers.* INTO CustomerTestLinkLocal
FROM dbo_Customers
WHERE (((dbo_Customers.CustomerID)="sjkfjlsj"));

There's not a record with a CustomerID of "sjkfjlsj"


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Dave Venus"
| Sender: "Dave Venus"
| Subject: Convert linked table design to local table
| Date: Wed, 16 Jun 2004 08:23:58 -0700
| Lines: 15
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRTtfG4SuHLfsg1SlGKRbzCz37BXw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:80772
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hi!
|
| I need to make a local table with the same structure as a
| linked table. All of the methods I have tried (export,
| import, cut/paste, copy, etc.) all create the new table
| as another linked table. I am sure there is a simple way
| to do what I need but so far it has eluded me.
|
| Any suggestions or help is greatly appreciated!
|
| BTW this Access 2002.
|
| Thanks!
|
| Dave Venus
|

On Wed, 16 Jun 2004 08:23:58 -0700, "Dave Venus"
wrote:

Hi!

I need to make a local table with the same structure as a
linked table. All of the methods I have tried (export,
import, cut/paste, copy, etc.) all create the new table
as another linked table. I am sure there is a simple way
to do what I need but so far it has eluded me.

Use File... Get External Data... Import to import the table *directly
from the backend database*; check or uncheck the "design only"
checkbox as appropriate.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Open the linked table in Design View, dismissing the warning.
Select and copy everything using Ctrl-A, Ctrl-C
Close the table
Create a new table in Design View
Select the first blank record
Paste using Ctrl=V
Save the table


Dave Venus wrote:

Hi!

I need to make a local table with the same structure as a
linked table. All of the methods I have tried (export,
import, cut/paste, copy, etc.) all create the new table
as another linked table. I am sure there is a simple way
to do what I need but so far it has eluded me.

Any suggestions or help is greatly appreciated!

BTW this Access 2002.

Thanks!

Dave Venus

Why not write a MakeTable query based on the table? Much simpler...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Robin Proctor" wrote in message
. net...
Open the linked table in Design View, dismissing the warning.
Select and copy everything using Ctrl-A, Ctrl-C
Close the table
Create a new table in Design View
Select the first blank record
Paste using Ctrl=V
Save the table


Dave Venus wrote:

Hi!

I need to make a local table with the same structure as a
linked table. All of the methods I have tried (export,
import, cut/paste, copy, etc.) all create the new table
as another linked table. I am sure there is a simple way
to do what I need but so far it has eluded me.

Any suggestions or help is greatly appreciated!

BTW this Access 2002.

Thanks!

Dave Venus

Certainly more elegant, and easier to automate, but you don't get
certain field properties copied, such as Default Value and Format.



Douglas J. Steele wrote:
Why not write a MakeTable query based on the table? Much simpler...