MS Access and Pass Through queries on remote desktop
I apologize if this is in the wrong place, but this is my first post and I have quite a specific issue that I hope someone else has experienced before.
Here is a little background:
I have created an access database to use as our companies' CRM, its an access front end and SQL backend.
Over the last few months, I have converted most queries to pass through queries due to the performance increase.
We have also just migrated to a remote desktop environment from the more traditional set up of a local server and workstations.
The issue:
Now we are using RDS there is only 1 central installation of MS access and my accdb file that all users open as they log into RDS (I have been told this is normal)
However, when VBA code fires to change the querydef of a pass-through query, it changes the query globally for all users, so users are sometimes presented with incorrect results.
Strangely, I also use TempVars to store things, but these DO stay unique for each user.
Example:
The users have a daily tasks screen on their home page, the event onload on the home screen sets the querydef to include the parameter for that user's ID number, but as users log in, previously logged in users end up seeing the tasks for the last user to log in.
I hope all this makes sense and I hope someone can help
sql-server ms-access remote-desktop pass-through edited Nov 21 '18 at 10:40
Shabeer Sha
6110
asked Nov 21 '18 at 10:30
R Exley
61
add a comment |
I apologize if this is in the wrong place, but this is my first post and I have quite a specific issue that I hope someone else has experienced before.
Here is a little background:
I have created an access database to use as our companies' CRM, its an access front end and SQL backend.
Over the last few months, I have converted most queries to pass through queries due to the performance increase.
We have also just migrated to a remote desktop environment from the more traditional set up of a local server and workstations.
The issue:
Now we are using RDS there is only 1 central installation of MS access and my accdb file that all users open as they log into RDS (I have been told this is normal)
However, when VBA code fires to change the querydef of a pass-through query, it changes the query globally for all users, so users are sometimes presented with incorrect results.
Strangely, I also use TempVars to store things, but these DO stay unique for each user.
Example:
The users have a daily tasks screen on their home page, the event onload on the home screen sets the querydef to include the parameter for that user's ID number, but as users log in, previously logged in users end up seeing the tasks for the last user to log in.
I hope all this makes sense and I hope someone can help
sql-server ms-access remote-desktop pass-through edited Nov 21 '18 at 10:40
Shabeer Sha
6110
asked Nov 21 '18 at 10:30
R Exley
61
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00
add a comment |
I apologize if this is in the wrong place, but this is my first post and I have quite a specific issue that I hope someone else has experienced before.
Here is a little background:
I have created an access database to use as our companies' CRM, its an access front end and SQL backend.
Over the last few months, I have converted most queries to pass through queries due to the performance increase.
We have also just migrated to a remote desktop environment from the more traditional set up of a local server and workstations.
The issue:
Now we are using RDS there is only 1 central installation of MS access and my accdb file that all users open as they log into RDS (I have been told this is normal)
However, when VBA code fires to change the querydef of a pass-through query, it changes the query globally for all users, so users are sometimes presented with incorrect results.
Strangely, I also use TempVars to store things, but these DO stay unique for each user.
Example:
The users have a daily tasks screen on their home page, the event onload on the home screen sets the querydef to include the parameter for that user's ID number, but as users log in, previously logged in users end up seeing the tasks for the last user to log in.
I hope all this makes sense and I hope someone can help
sql-server ms-access remote-desktop pass-through edited Nov 21 '18 at 10:40
Shabeer Sha
6110
asked Nov 21 '18 at 10:30
R Exley
61
I apologize if this is in the wrong place, but this is my first post and I have quite a specific issue that I hope someone else has experienced before.
Here is a little background:
I have created an access database to use as our companies' CRM, its an access front end and SQL backend.
Over the last few months, I have converted most queries to pass through queries due to the performance increase.
We have also just migrated to a remote desktop environment from the more traditional set up of a local server and workstations.
The issue:
Now we are using RDS there is only 1 central installation of MS access and my accdb file that all users open as they log into RDS (I have been told this is normal)
However, when VBA code fires to change the querydef of a pass-through query, it changes the query globally for all users, so users are sometimes presented with incorrect results.
Strangely, I also use TempVars to store things, but these DO stay unique for each user.
Example:
The users have a daily tasks screen on their home page, the event onload on the home screen sets the querydef to include the parameter for that user's ID number, but as users log in, previously logged in users end up seeing the tasks for the last user to log in.
I hope all this makes sense and I hope someone can help
sql-server ms-access remote-desktop pass-through sql-server ms-access remote-desktop pass-through edited Nov 21 '18 at 10:40
Shabeer Sha
6110
asked Nov 21 '18 at 10:30
R Exley
61
edited Nov 21 '18 at 10:40
Shabeer Sha
6110
asked Nov 21 '18 at 10:30
R Exley
61
edited Nov 21 '18 at 10:40
Shabeer Sha
6110
edited Nov 21 '18 at 10:40
Shabeer Sha
6110
edited Nov 21 '18 at 10:40
Shabeer Sha
6110
6110
asked Nov 21 '18 at 10:30
R Exley
61
asked Nov 21 '18 at 10:30
R Exley
61
asked Nov 21 '18 at 10:30
R Exley
61
61
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00
add a comment |
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00
add a comment |
2 Answers
2
active
oldest
votes
Create a copy of the frontend for each user. Place it in a subfolder of the users %localappdata% folder.
Create a shortcut to open the application. In this, use the %localappdata% in the command line.
Then all users will run their own copy not seen by the other users.
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
add a comment |
RDS or not,having all the users opening the same FE has drawbacks, in performance, and other matters. I suppose every users has his own VM ? Then just put a copy of the FE on each VM.
Or even better: give them a shortcut to open the app. The shortcut should:
- launch a small script that copies the FE from the deployment folder to their c:temp folder
- lauch the FE from there
This way, updates will be transparent for your users. However this solution is not valid if you keep some static data in the FE.
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410085%2fms-access-and-pass-through-queries-on-remote-desktop%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Create a copy of the frontend for each user. Place it in a subfolder of the users %localappdata% folder.
Create a shortcut to open the application. In this, use the %localappdata% in the command line.
Then all users will run their own copy not seen by the other users.
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
add a comment |
Create a copy of the frontend for each user. Place it in a subfolder of the users %localappdata% folder.
Create a shortcut to open the application. In this, use the %localappdata% in the command line.
Then all users will run their own copy not seen by the other users.
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
add a comment |
Create a copy of the frontend for each user. Place it in a subfolder of the users %localappdata% folder.
Create a shortcut to open the application. In this, use the %localappdata% in the command line.
Then all users will run their own copy not seen by the other users.
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
Create a copy of the frontend for each user. Place it in a subfolder of the users %localappdata% folder.
Create a shortcut to open the application. In this, use the %localappdata% in the command line.
Then all users will run their own copy not seen by the other users.
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
answered Nov 21 '18 at 10:50
Gustav
29.4k51734
29.4k51734
add a comment |
add a comment |
RDS or not,having all the users opening the same FE has drawbacks, in performance, and other matters. I suppose every users has his own VM ? Then just put a copy of the FE on each VM.
Or even better: give them a shortcut to open the app. The shortcut should:
- launch a small script that copies the FE from the deployment folder to their c:temp folder
- lauch the FE from there
This way, updates will be transparent for your users. However this solution is not valid if you keep some static data in the FE.
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
add a comment |
RDS or not,having all the users opening the same FE has drawbacks, in performance, and other matters. I suppose every users has his own VM ? Then just put a copy of the FE on each VM.
Or even better: give them a shortcut to open the app. The shortcut should:
- launch a small script that copies the FE from the deployment folder to their c:temp folder
- lauch the FE from there
This way, updates will be transparent for your users. However this solution is not valid if you keep some static data in the FE.
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
add a comment |
RDS or not,having all the users opening the same FE has drawbacks, in performance, and other matters. I suppose every users has his own VM ? Then just put a copy of the FE on each VM.
Or even better: give them a shortcut to open the app. The shortcut should:
- launch a small script that copies the FE from the deployment folder to their c:temp folder
- lauch the FE from there
This way, updates will be transparent for your users. However this solution is not valid if you keep some static data in the FE.
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
RDS or not,having all the users opening the same FE has drawbacks, in performance, and other matters. I suppose every users has his own VM ? Then just put a copy of the FE on each VM.
Or even better: give them a shortcut to open the app. The shortcut should:
- launch a small script that copies the FE from the deployment folder to their c:temp folder
- lauch the FE from there
This way, updates will be transparent for your users. However this solution is not valid if you keep some static data in the FE.
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
answered Nov 21 '18 at 10:38
Patrick Honorez
18.7k563117
18.7k563117
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410085%2fms-access-and-pass-through-queries-on-remote-desktop%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
My guess is that you have static variables that are being shared by all users, but without seeing a sample of the relevant code, it will be very difficult to diagnose.
– Dragonthoughts
Nov 21 '18 at 11:00