If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
Accessing Queries in another file
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, |
#3
|
|||
|
|||
Accessing Queries in another file
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, |
#4
|
|||
|
|||
Accessing Queries in another file
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, |
Thread Tools | |
Display Modes | |
|
|