Access runtime and RDC

[adiecidue]

I have Access 2010 Runtime installed on a server that I access via remote desktop connection. In many places in our program we save forms and or reports. This works fine until a second user logs in and runs the program. Now when we try to save a form or report we get an error because the MDB file is open in two places and Windows won't allow us to save to an open file.

Is there a solution to this other than NOT saving forms and reports?

[pbaldy]

The file should never be opened by two people simultaneously. In a Citrix/Terminal Server type of environment where multiple people are using the program on a single machine, I create a folder for each user and put a copy of the front end in each folder. That way each person is running their own copy.

I am curious why users are saving forms and reports. Typically that's only done in development.

[adiecidue]

pbaldy,
Thanks for the response. We are currently considering doing what you proposed. We were trying not to go down that road to keep it simple and have the ability to update everyone simultaneously by simply updating the front end file. If each user has their own copy, that makes updating a bit of a chore. I was hoping there was a way to set an attribute or something like that, to enable saving to a file while it was open.

As to your second question.... bad programming? Not really, there are parts of our program where users are given the opportunity to make changes to forms or reports and have the changes saved.

[pbaldy]

I write a little utility that checks a version table in the front end and copies any new versions to the user's folder (it also checks the user). The user doesn't run the mdb, they run my utility. It handles any necessary updating and then starts the copy. That makes updating as simple as placing a new version in a specified location. Of course if you're doing that, what happens to any changes a user has made to forms/reports?

I wouldn't call it bad programming to let users do that; I've just never done it. Maybe you have smarter users than I do.