Split Database - Accessing the Front End Via Citrix (1 Viewer)

ataylo27

Registered User.
Local time
Today, 06:20
Joined
May 7, 2015
Messages
13
I have a database application, split into a front-end (ACCDE) and a back-end (ACCDB) in Access 2013.

The back-end contains ONLY data tables. The front-end contains everything else.

What I've read about this scenario indicates EACH user should have their OWN copy of the back-end.

My problem: all users are getting into the ACCDE file using Access through a Citrix application server, it is NOT locally-installed.

Is an individual copy of the front-end necessary? If so, why?

What problems might I encounter if these users access the SAME copy of the front-end stored on a network share -- if they can?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:20
Joined
Aug 30, 2003
Messages
36,118
I had problems with that setup until I gave each user an individual copy of the front end. In my case I modified my version control utility to use

C:\FolderName\UserName

Where previously it put the front end in

C:\FolderName
 

JHB

Have been here a while
Local time
Today, 11:20
Joined
Jun 17, 2012
Messages
7,732
...
What I've read about this scenario indicates EACH user should have their OWN copy of the back-end.
NO each user should have a copy of the FRONT-end, NOT the backend.
...
Is an individual copy of the front-end necessary? If so, why?
Because of the network speed.
 

ataylo27

Registered User.
Local time
Today, 06:20
Joined
May 7, 2015
Messages
13
I mean front-end! Sorry!

So, then, can they all access the SAME front-end file stored on a network drive, using Access through Citrix?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:20
Joined
Aug 30, 2003
Messages
36,118
As I mentioned, not in my experience.
 

ataylo27

Registered User.
Local time
Today, 06:20
Joined
May 7, 2015
Messages
13
I guess I'm confused about how to get them their own front-end copy without having to actually place it on their local drive.

Where you said you used C:\FolderName\UserName -- are you meaning that you placed a copy for each user locally, or did you place it in their Citrix profile?

I've got about 70 users.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:20
Joined
Aug 30, 2003
Messages
36,118
That path was on the server, so there were quite a number of named subfolders. I probably had a similar number of users overall.
 

Users who are viewing this thread

Top Bottom