Cannot cut and paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an Access canned program that keeps the tables on the server and
everything else resident on each local computer. I have updated some reports
and when I tried to copy them onto my flash drive to paste them on the other
computers it would only allow me to move a shortcut, which is of no use. Does
anybody know how I can copy these reports to the other computers and if so
would you please tell me?

Thank you;
 
We have an Access canned program that keeps the tables on the server and
everything else resident on each local computer. I have updated some reports
and when I tried to copy them onto my flash drive to paste them on the other
computers it would only allow me to move a shortcut, which is of no use. Does
anybody know how I can copy these reports to the other computers and if so
would you please tell me?

Thank you;
Click to expand...

A Report in Access is just a tool: it is the "structure" and layout of
the report, and does not contain any data. A Report has no existance
except within a working database.

So you cannot cut and paste "a report" as you are trying to do. If you
have a proper frontend with just the forms, queries, reports etc.
linked to a backend with all the tables, simply trash the old .mdb or
..mde frontend file and replace it with an updated one; if necessary,
use Tools... Linked Table Manager to relink the backend tables.

If the frontend contains objects that you can't afford to overwrite,
and if it's a .mdb file (rather than a "compiled" .mde file which
won't let you do this), you can use File... Get External Data...
Import to import the new Report object from the updated database.

John W. Vinson[MVP]
 
Back
Top