473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Calculated value invisible until been clicked

We are running Access 2010 runtime on Server 2008 R2 with both FE and BE on it. Each user has own FE copy on Server which is opened from own PC through remote desktop.

After fresh Server restart all goes well for 1-2 weeks. But then some strange behaviour starts:
- values of all calculated fields - whatever, on forms or on reports - disapears. When I click on a field it shows up again. And refresh does not help;
- all condition formats does not show up until I hover the mose on it.

When we restart the Server all comes to normal again. Its very annoying because users thinking data are gone!

I have searched a lot on net but seems it is rare problem and maybe related to some kind of overcaching or something related to time used.

Would be great to hear from you of any help on it.
Jan 9 '14 #1

✓ answered by zmbd

Ok... so each user has a copy of the frontend... this is good.
The copy is on the server, this is a bottle neck.
- server feeds to local pc
- local pc makes request
- local request feeds to server
- server handles request
- server then feeds update to frontend display
- server then feeds data up to the frontend display

--
- each user has own copy on local pc
- the front-end sends request to server
- server processes and sends data back up to front-end
- local pc processes the data

You can still use the idea of the script,
Have the user click on the button
Have the script check for local pc version against server version of frontend (if change then download newer version, if no change then start the application).
This is what our IT does. We have a MySQL based system. The frontend is all in a flavor of C, there is a launcher script that checks the server for new versions and installs the newer version, then launches the frontend.

8 2478
zmbd
5,501 Expert Mod 4TB
See if the following will help...
ACC2100
You need to open the front-end master.
Backstage (File on the ribbon)
Options
Current Database
(scroll down)
Caching Web Service and SharePoint tables
Select: Use the cache format that is compatible with Microsoft Access 2010 and later
Select: Clear Cache on Close
Save
Push this new frontend down to the users.
Jan 9 '14 #2
Thanks for reply a lot.
I'll do it today for all front ends. We do not use neither Web nor SharePoint but who knows, maybe it helps. Be back with results after few weeks.
Still if anyone have other suggestions would be nice to hear.
Jan 10 '14 #3
As promissed I am back with test results. Unfortunately it did not help but now it is certain that our problem is directly related with thin client of remote desktop. So, nothing to do with Access. Still question is open and if somebody has resolved it would by great help for us.
Apr 7 '14 #4
zmbd
5,501 Expert Mod 4TB
one more suggestion then, push the frontends down to the local pcs... don't run them from the server.
Apr 7 '14 #5
It helps for sure to resolve this problem but then I loose control on FrontEnds. We have BackEnd based on Access. To make maintance I need to close all FrontEnds (30 users). On Server it is not an issue but on individual PC's - how can I manage it?

P.S.: I know that such many users must run on more serious DB, such as SQL SERVER. We plan to move there but it is different story...
Apr 8 '14 #6
jimatqsi
1,271 Expert 1GB
You could add a data item to a parameter table, something like
DBClosed_yn and then write a function that returns the value. Add calls at appropriate places throughout your software,
Expand|Select|Wrap|Line Numbers
  1. if DBClosed() then
  2. msgbox "The database is closed for maintenance"
  3. docmd.quit
  4. endif
  5.  
Then when you need to do some maintenance you just set the flag and wait for everybody to encounter it and exit. The waiting might be the hard part.

I wrote a menuing system that allows me to see who is logged in and what version they're running. I can retire a version, which forces people on that version to update before selecting anything on the menu. I think I'll add this feature to it.

Jim
Apr 8 '14 #7
Hi Jim, thanks for the suggestion.

We have 10 users in office and 20 users in production (their do scan all the products at every prod. proccess point). Office works 8 hrs / 5 days but production do 24 hrs / 7 days and here is the problem. In fact we nether have situation when all FE are logged off.

I have FE versioning done through vbscript. Every time user clicks the script file the FE (master) copy goes to separate folder, gets individual file name and starts Access runtime.

I never thought this approach is bad. At least I cannot find the reason "why?" because in my structure every user has own copy.
Apr 9 '14 #8
zmbd
5,501 Expert Mod 4TB
Ok... so each user has a copy of the frontend... this is good.
The copy is on the server, this is a bottle neck.
- server feeds to local pc
- local pc makes request
- local request feeds to server
- server handles request
- server then feeds update to frontend display
- server then feeds data up to the frontend display

--
- each user has own copy on local pc
- the front-end sends request to server
- server processes and sends data back up to front-end
- local pc processes the data

You can still use the idea of the script,
Have the user click on the button
Have the script check for local pc version against server version of frontend (if change then download newer version, if no change then start the application).
This is what our IT does. We have a MySQL based system. The frontend is all in a flavor of C, there is a launcher script that checks the server for new versions and installs the newer version, then launches the frontend.
Apr 9 '14 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: D Witherspoon | last post by:
An application I've just finished developing is not showing up in the taskbar on startup until the application is clicked on. This makes it difficult as it is being launched as a No Touch...
1
by: staeri | last post by:
I have a gridview which calculates a value in a templatecolumn. I want to save the calculated value into the database when all the other data is saved. How can I do that? As it is now I don't...
0
by: =?Utf-8?B?cGI2NDgxNzQ=?= | last post by:
We have been having this problem for months and always assumed it was because of our somewhat complicated setup. I have just spent almost all of today making this into a simple example that can be...
1
by: Prashantsd | last post by:
Hi, I have problem storing the calculated value in table. I have a text box(Ranking) which display the sum of 4 combo box. this is wat I hav done in control source of tex box = + + + I...
94
by: mlcampeau | last post by:
I have a report (JobVacanciesOnly) that has a subreport (JobVacanciesOnlySR) that are based on two separate queries. MY - JobVacancyJobs SELECT Job.Code, Job.Title, Job.Grade, Grade.Minimum,...
1
by: fperri | last post by:
I hope that this is the right forum. I'm using VB to create a report in Excel. After the report is generated I put two buttons onto the title sheet. Both are for printing a part of the report. Here...
9
by: JCCDEVEL | last post by:
Hi All, I'm trying to do the following: 1) ON a php page, calculate fees based upon user entires. I'm calculating it in a javascript function and that is working well. However, I need to take...
7
by: Proaccesspro | last post by:
How do I do this?? I have a text box that captures the count of a The number of open orders. I need this value to be the STARTING value the next time the report is run....How am I able to store...
3
by: JenniferM | last post by:
Annnnnd I'm back again, with a new problem, of course. I've got a table, TblKneeExamInfo, which corresponds to a form, FrmKneeExamInfo. In it, there is a section where I need to input patient...
7
by: Barry Heap | last post by:
I have a select query with several fields. A calculated field extracts part of the value of one of these fields. I want to retain the extracted value but include a further calculated field that...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.