creating queries and saving them

[Guest]

My teacher gave us a database with tables to download. We were to download
it, create queries to answer the questions, and post it on our web space to
turn it in (the queries being the part that's graded).
So I did all the queries, saved them as I went, and tried to post it to my
webspace. The problem is the whole database is just a temporary internet
file and the only thing I can do is create shortcuts in different places,
I've tried saving it to a specific place when I download the database but
it's still just a temporary internet file. So while I'm working on it it
looks like everything is being saved, but when I try to post it to my
webspace, what I thought was the database was just a shortcut to a temporary
internet file that no longer exhists.
So I've just done it for the third time, I've tried to save the individual
queries, tried exporting them, copying them to other locations, but it all
comes down to the fact that it's all shortcuts leading to no where in the
end. Please help me, I've got everything up on my computer just waiting for
an answer.

 

[Douglas J. Steele]

It sounds as though you might simply have clicked on the MDB file, rather
than downloading it.

You need to download the MDB file, make the changes in it, then upload the
changed MDB file.

 

[Guest]

Hi

It "may" be that you have in fact saved the work you have been doing. Try
this.

Go to Tools
Go to Internet Options
Go to Browseing History
Go to Settings
Go to View Files
Try and find the file you were working on
- it may be worth trying to find it by the time and date -
If you can find it - right click Save As and save it onto your hard disk

If this fails then you should contact your teacher for advice

Good luck

 

[M Skabialka]

Have you tried viewing the queries in SQL format - In design mode, View, SQL
View, then copying the results to a document out of the database which you
would then submit to your teacher?

eg:
SELECT DISTINCTROW Computers.[Computer ID], Computers.[Office Location],
Computers.Owner FROM Computers ORDER BY Computers.[Office Location],
Computers.Owner;