By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Use someone elses DB and Queries

P: n/a
HJR
Hello and thank you in advance to anyone who can help. I have searched
and cannot locate an answer to my problem...

My colleague has a database and queries what are built and running fine
for her (she uses Access 2002 and the DB is stored on the H: drive). I
can open the database, but when I do there are no queries. I can
access the tables, but the pre-built queries are missing. Can anyone
advise if it is possible for me to view and run her queries? i do not
want to make any changes, simply view information.

Many thanks in advance.

May 10 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Does she have her database split into a frontend/backend. If she does,
that you are looking at the backend that only contains tables. All of
forms, queries reports and programming would be contained in the
frontend. She should know if she has done this and can point you to
the frontend. The easiest way to tell yourself is if the database has
a name that has _be.mdb at the end.

If not I can not help.

May 10 '06 #2

P: n/a
HJR
Unfortunately my colleague inherited the database and neither of us are
experts. The name of the file is interchange_data.mdb. Does that
help?

Really appreciate your help!

May 10 '06 #3

P: n/a
HJR
Unfortunately my colleague inherited the database and neither of us are
experts. The name of the file is interchange_data.mdb. Does that
help?

Really appreciate your help!

May 10 '06 #4

P: n/a
Jan
Hi:

How does your colleague get to the database? You need to follow her
exact path.

If she uses a shortcut, check its target (right-click the shortcut,
choose Properties, then look at the Target). There is no way to tell
based on the name or location of the file exactly what its purpose is,
but its very likely there's a front-end database out there that has all
the parts you need. If the file you're looking at is
"interchange_data," then maybe there's another file with "interchange"
in its name. The file's modification date/time will likely be the date
of the last time she opened the database, if that helps. It may be
located on her C drive so look there too.

Good luck.

Jan

HJR wrote:
Hello and thank you in advance to anyone who can help. I have
searched and cannot locate an answer to my problem...

My colleague has a database and queries what are built and running
fine for her (she uses Access 2002 and the DB is stored on the H:
drive). I can open the database, but when I do there are no queries.
I can access the tables, but the pre-built queries are missing. Can
anyone advise if it is possible for me to view and run her queries?
i do not want to make any changes, simply view information.

Many thanks in advance.

May 11 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.