How create a local copy of a linked table record?

  • Thread starter Thread starter mscertified
  • Start date Start date
M

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.
 
mscertified said:
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.
Click to expand...

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