mutiple users on citrix

[jonamua1971]

thank you all for your help.
i haved searched and i did not find an answer.
i have splitted my database which is on the citrix server and put the b/end on the shared drive and put the front end on my document on the users desktop. my question when one is using the form the other cannt use the same form? why is that?? how can i fix that. i would like users to use the same forms to enter data at the same time.
thank you

 

[The_Doc_Man]

The problem has to do with the Citrix environment. I'm not going to swear that this is entirely legal. Not to mention that things aren't where they seem to be in Citrix.

Basically, Citrix uses Win Terminal Services to allow a web-based user to see a terminal-like screen through which some application runs. But other things like file sharing aren't automatic. You see, to Access, you are a local user on the server, not a remote user. It doesn't know or care where you are once you have passed the Citrix login process.

Normally, the reason you cannot open something is because Access thinks that the "something" is locked. If you are really running on Citrix and not running on a local machine, it is quite possible that the form IS locked since you don't have separate copies of it.

If you are really running from the FE, there is the question of the file services that are being used to access the main database file. Network shares have a little side-effect of sometimes locking things if the permissions aren't set up exactly right. Search this forum for "Network Permissions" as a topic.

 

[jonamua1971]

Backend problems on Citrix

after i the splitted the database, when i one user is on one front end , the others cant. it says that the backend is in use. why is ?
thanks you all for response
JO

 

[The_Doc_Man]

Has to be the permissions on the BE file or that the users are coming as Admin which has OpenExclusive permissions within the database.

You have two places to search in this forum, topics are

1. Workgroup Security or Securing a Database

2. Windows Permissions or Permissions (which would overlap topic 1)

 

[jonamua1971]

Security

Hi all
thanks for all your response so far.
i was asked to check my security and i have been seaching this forum since and i seem not to get my answer.
here are some my database properties.
default file format = 2000
default open mode = shared
'' records locking= no locks
checked box = open database-level = locking
secuirty macro is set to medium" we are in a secured enviroment no need for medium.
Question. when one use is accessing the front end the other cann't because it says backend already in use.
please help !
thanks all for your help in advance.

 

[The_Doc_Man]

Security is broader than what you described.

1. Individual file permissions in the folder holding the database will sometimes cause the DB to lock because the person first opening it cannot open the LDB file. So there is no way to do record-level locking. That means that the only way to be safe is for WINDOWS (not ACCESS) to lock the whole database as read-only.

2. If you search the database for "Securing a Database" or "Workgroup Security" you will find that again, PERMISSIONS (this time INSIDE Access) can cause / allow a database to lock because if you have not done the proper steps, the first person in comes in as a member of Admins group with the right to do an Open Exclusive. And that ends that discussion.

3. In a shared environment, you ARE SECURED whether you think you need it or not. The SHARE (Windows sense of that term) has permissions of its own over and above those of the folder when opened locally. SHARE permissions minimize against folder local permissions, so what you get when traversing a SHARE is the lowest common denominator of permissions, not the sum of those permissions. The sum only occurs in Domain environments where two different group identifiers apply via different Access Control Entries and the user happens to qualify for both groups at the same time.

The mechanism is one of the two that I have named. I just can't tell you exactly which level of Windows, Folders, or Workgroup issues has got you stymied. But it is one of those issues.

 

[MicroE]

What is the exact error message you are receiving?

Does each user have their own copy of the FE?
http://www.myaccesstips.com/deploy/deploy.html

 

[CraigDolphin]

Apologies for this side-bar.

Doc_Man,

You said

The problem has to do with the Citrix environment. I'm not going to swear that this is entirely legal. Not to mention that things aren't where they seem to be in Citrix

What did you mean regarding Citrix and legality? We use Citrix at my workplace (to my everlasting irritation) and if there is dubious legality regarding access and citrix I would be interested to know what the basis of that is. As far as I know, our IT department pays M$ for licenses etc.