Accessing Queries in another file

Database is Access 2000 format but working with in Access 2007

I have a database split into three files; one holds the tables, another
holds the administrators forms, queries, reports, and etc. The third holds
the Users queries (these are seperated from the administrator's for security
reasons). All three files are secured with the same .mdw file.

Someone else initially created this database. I am the new owner of this
database. The original owner created a form that would allow you to click a
button that would then open up the query database while prompting you for
your login and password.

My question is; when moving these database files to a new location; how do I
code the button in the form to access the query file in the new location? I
have already tried to paste the new path (both UNC and windows) within the
code used originally. But all I get is a bunch of errors saying it can't find
the database file.

Thanks in advance for any help,

Rather than pasting, have you tried linking (File | Get External Data |
Link...) from the new location?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"ACCESS2007" wrote in message
...
Database is Access 2000 format but working with in Access 2007

I have a database split into three files; one holds the tables, another
holds the administrators forms, queries, reports, and etc. The third holds
the Users queries (these are seperated from the administrator's for
security
reasons). All three files are secured with the same .mdw file.

Someone else initially created this database. I am the new owner of this
database. The original owner created a form that would allow you to click
a
button that would then open up the query database while prompting you for
your login and password.

My question is; when moving these database files to a new location; how do
I
code the button in the form to access the query file in the new location?
I
have already tried to paste the new path (both UNC and windows) within the
code used originally. But all I get is a bunch of errors saying it can't
find
the database file.

Thanks in advance for any help,

I want to be able to program the button in the form to open the database that
holds all of the queries the users can run (which holds about 13 different
queries).

If I did a link, I would need to link all the queries which would be placing
them in the same location the Administrator queries are and I don't want the
users to even have access to the queries portion of the main database file,
this is why they are in a seperate file.

Or, did I misunderstand something?


Thanks

"Jeff Boyce" wrote:

Rather than pasting, have you tried linking (File | Get External Data |
Link...) from the new location?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"ACCESS2007" wrote in message
...
Database is Access 2000 format but working with in Access 2007

I have a database split into three files; one holds the tables, another
holds the administrators forms, queries, reports, and etc. The third holds
the Users queries (these are seperated from the administrator's for
security
reasons). All three files are secured with the same .mdw file.

Someone else initially created this database. I am the new owner of this
database. The original owner created a form that would allow you to click
a
button that would then open up the query database while prompting you for
your login and password.

My question is; when moving these database files to a new location; how do
I
code the button in the form to access the query file in the new location?
I
have already tried to paste the new path (both UNC and windows) within the
code used originally. But all I get is a bunch of errors saying it can't
find
the database file.

Thanks in advance for any help,

I'm not aware of a way to "link ... queries".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"ACCESS2007" wrote in message
...
I want to be able to program the button in the form to open the database
that
holds all of the queries the users can run (which holds about 13 different
queries).

If I did a link, I would need to link all the queries which would be
placing
them in the same location the Administrator queries are and I don't want
the
users to even have access to the queries portion of the main database
file,
this is why they are in a seperate file.

Or, did I misunderstand something?


Thanks

"Jeff Boyce" wrote:

Rather than pasting, have you tried linking (File | Get External Data |
Link...) from the new location?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"ACCESS2007" wrote in message
...
Database is Access 2000 format but working with in Access 2007

I have a database split into three files; one holds the tables,
another
holds the administrators forms, queries, reports, and etc. The third
holds
the Users queries (these are seperated from the administrator's for
security
reasons). All three files are secured with the same .mdw file.

Someone else initially created this database. I am the new owner of
this
database. The original owner created a form that would allow you to
click
a
button that would then open up the query database while prompting you
for
your login and password.

My question is; when moving these database files to a new location;
how do
I
code the button in the form to access the query file in the new
location?
I
have already tried to paste the new path (both UNC and windows) within
the
code used originally. But all I get is a bunch of errors saying it
can't
find
the database file.

Thanks in advance for any help,