Thanks for the response Bert! I can use LogMeIn without any trouble but would prefer not to use it as when the people that are servicing the remote areas are at the remote offices their computers are still in use at our office and financially we would rather not buy more machines at the moment.
So, what I would like to do is have the remote laptops with AC installed on them and then, like in our office, use the database file located on the server. The problem is that the laptops are on workgroups instead of on the domain. The reason for this is that you cannot contact the domain to log in without a dedicated VPN such as the Cisco hardware VPN options you mentioned, and the cache that stores the entry saying the log in is "ok" is only good for (I think) 5 logins after the computer cannot communicate with the server.
So, I tried mapping the drive from the server, which worked and I could see the database and select it in Amazing Charts. However, AC would then ask me if the remote computer was the "main" computer. I said no, of course. The window asked me to choose the file again. I did and this time selected that this WAS my "main" computer. I got a message then stating that I needed to have SQL installed.
Without buying something or dedicating computers at the office to LogMeIn I don't know of a way around this. I was hoping someone had done something like this before and could help me figure out how to let AC know that the file was not actually on the remote computer, that the mapped drive was in fact, a network drive. I just know there has to be a way to accomplish this.
