query copy

  • Thread starter Thread starter apk
  • Start date Start date
A

apk

Dear all,

How can I save a query on a floppy to add another
computer.I have same data available in both the pcs. One
person is making the query and I want the same query to be
in another pc. I am using Access97.

hlp

Regards
APK
 
If it's just a one time or infrequent thing, it is probably easiest to do
this manually. There are a couple of options.

1) Create a blank database on the floppy and go to File|Get External
Data|Import and import the query into the database on the floppy. Do this
from the database on the second computer to import the query from the
floppy.

2) Open the query in SQL view then copy and paste the SQL text into a text
file. Place the text file on the floppy and take it to the 2nd computer. On
the 2nd computer, open a new query in SQL view and copy and paste the SQL
text into it. Save the query with the appropriate name.
 
Back
Top