How create a local copy of a linked table record?

[mscertified]

This is a split database where each user has their own copy of the front end.
I have a need to do the following:
Create a local copy of the structure of a linked table, empty of data.
Move (read then delete) a single record from the linked table into the local
table.

What is the most efficient way of doing this? thanks.

 

[Larry Linson]

This is a split database where each user has their own copy of the front
end.
I have a need to do the following:
Create a local copy of the structure of a linked table, empty of data.
Move (read then delete) a single record from the linked table into the
local
table.

What is the most efficient way of doing this? thanks.

What you describe has the potential of being a very inefficient approach to
most problems.

Visit MVP Tony Toews' site http://www.granite.ab.ca/accsmstr.htm and look
around... you'll find a method that you can copy, and then make minor
changes, for creating temporary tables in a temporary database to avoid
database bloat.

Larry Linson
Microsoft Office Access MVP