Accessing Queries in another file

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

Guest

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
 
Back
Top