Hey!
I've built a database that is for both research and administrative purposes. Due to Data Protection, it is important (due to these reasons) to have identifiable information unavailable to the researchers (such as name and contact details). As such, I have split the database - the core of the database which is available to everyone, and then a table with Client Identifiable Information in that only administration can access. This table is kept on the Admin Computer and on a transportable Hard Drive that is password protected (should Admin need to access it in the Clinic).
What I want to do is create ONE database that everyone can use. The Client Forms can be used to research, and thus would need to be seen, but in these forms are the identifiable stuff for the clients. What I would like to do is have the form load and if the linked table is not accessible, then the form data that is contained in that table be blanked out. Currently, forms do not load if it cannot access all data, but is there a way to bypass that...
Strictly for ease-of-use purposes (and so that it's less work for myself), is there any way to make the form load without the linked table if the Database cannot access it, and return all non-accessible fields as null values?
Access 2007 (though my computer is using '10)
I've built a database that is for both research and administrative purposes. Due to Data Protection, it is important (due to these reasons) to have identifiable information unavailable to the researchers (such as name and contact details). As such, I have split the database - the core of the database which is available to everyone, and then a table with Client Identifiable Information in that only administration can access. This table is kept on the Admin Computer and on a transportable Hard Drive that is password protected (should Admin need to access it in the Clinic).
What I want to do is create ONE database that everyone can use. The Client Forms can be used to research, and thus would need to be seen, but in these forms are the identifiable stuff for the clients. What I would like to do is have the form load and if the linked table is not accessible, then the form data that is contained in that table be blanked out. Currently, forms do not load if it cannot access all data, but is there a way to bypass that...
Strictly for ease-of-use purposes (and so that it's less work for myself), is there any way to make the form load without the linked table if the Database cannot access it, and return all non-accessible fields as null values?
Access 2007 (though my computer is using '10)
