I am using an XP machine with Access 2007. I created a database and put in in a folder located on an XP box. I shared the folder on the network as a hidden share and added me with FULL CONTROL on the security tab. I tried to add the location as a trusted location in the trust center and it gives me this error:
"The path you have entered cannot be used as a trusted location for security reasons. Choose another location or a specific folder."
I have tried lowering my security settings in IE on "Local Sites' on the security tab but I do not believe it is that kind of issue. I also have tried the check box:
"Allow trusted locations on my network"
both checked and unchecked. I have tried mapping it in the trust center with IP (i.e. \\10.10.2.25\Share\sharesub) and by mapped drive (i.e. U:\Sharesub). It gives me the same error every time. How can I get this location to be a trusted site?
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: