Scheduling Updates On Timer (ARRGH!!)

[abbaddon223]

Hi all,

I have a db which is split front and back and is deployed via RDS to quite a few users.

The problem I have is, a function which is used a lot triggers a series of queries which on their own run fine, however as it's used by about 10 users it's causing the db to crash.

The queries which are running only need to be ran once every 5 minutes or so, so, what I'm looking to do is scheduale a SINGLE update to happend every 5 mins so that only one event of th query happens.

The only way I can think to do this is to have a manager (1 user only) open a form in the background which triggers the event every 5 mins (not sure how to run a macro on a loop on timer in VBA).

Does anyone have any better ways? (If my rambling above makes any sense!!).

Thanks in advance!

 

[boblarson]

When you say it is deployed by RDS (do you mean RDP???) does each user have a COPY of the frontend they open from their own profile? If it is a shared location and they aren't opening a separate file then it should be.

 

[abbaddon223]

The backend is on a cloud server. There is only one FE. Each user logs in to a web based remote desktop session (if that answer the Q?).

Thanks mate.

 

[boblarson]

The backend is on a cloud server. There is only one FE. Each user logs in to a web based remote desktop session (if that answer the Q?).

Thanks mate.

Yes, it does answer the question and you need to give EACH USER a COPY of the frontend. You can't expect it to work properly if they all are accessing the same frontend file. It just doesn't work right if you do that.