Ok, it seems the first problem I am having is that I have always just navigated to the file when I wanted to use it as the data source for merges.

When I try to open a new data source I get an error message that I do not have permission to use the file.

The database is stored on my hard drive because the server does not like me and won't let me save anything there.

Is this the only way to connect to a data source where you can have fields where you "set key fields"?