global users using remote desktop connection - databaseread only e Crossh 6/25/2007 9:08:03 PM I have three users logging onto a server using remote desktop connection. They open the access database on the server, which has a sql backend. This process works fine for one user, but the other two get a database is read-only error. Any ideas what would cause this? Also, everyone locally can log into the server and use the database without any problem.

Re: global users using remote desktop connection - databaseread only e Armen Stein <ArmenStein[ at ]R3m00v3Th1s.gmail.com> 6/26/2007 12:10:07 AM On Mon, 25 Jun 2007 14:08:03 -0700, Crossh <Crossh[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I have three users logging onto a server using remote desktop connection. >They open the access database on the server, which has a sql backend. This >process works fine for one user, but the other two get a database is >read-only error. Any ideas what would cause this? Also, everyone locally can >log into the server and use the database without any problem. Check the permission settings for the two users that are having problems. Perhaps they don't have read-write permission on the folder that has the front-end application. They can quickly test it by creating a simple text file in that folder, modifying it and deleting it. Armen Stein Microsoft Access MVP www.JStreetTech.com

Re: global users using remote desktop connection - databaseread only e "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/26/2007 2:19:22 AM Crossh <Crossh[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I have three users logging onto a server using remote desktop connection. >They open the access database on the server, which has a sql backend. This >process works fine for one user, but the other two get a database is >read-only error. Any ideas what would cause this? Also, everyone locally can >log into the server and use the database without any problem. Everyone should be getting thier own copy of the database even if they are logging onto a Terminal Server system. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: global users using remote desktop connection - databaseread on Crossh 6/26/2007 12:12:01 PM [Quoted Text] > Everyone should be getting thier own copy of the database even if they > are logging onto a Terminal Server system. > Are you saying that I should have multiple copies of the database on the desktop of the remote terminal, one for each user?

Re: global users using remote desktop connection - databaseread on <david[ at ]epsomdotcomdotau> 6/26/2007 12:41:50 PM You should have one copy of the database in the "My Documents" folder of each user. Or in the Local Applications folder of the My documents folder of each user. (david) "Crossh" <Crossh[ at ]discussions.microsoft.com> wrote in message news:F5365D66-317B-4B5B-B56A-82515A454FD4[ at ]microsoft.com... [Quoted Text] > > Everyone should be getting thier own copy of the database even if they > > are logging onto a Terminal Server system. > > > > Are you saying that I should have multiple copies of the database on the > desktop of the remote terminal, one for each user?