multiusers not seeing each others changes

[ProgramError]

Hi folks

I have two users who have front ends (mbe) on their computer which link to a backend of tables. Simple enough so far. But because it was inhereted Database which I decided to split for faster processing, I have found that if one user alters a query (don't ask me why it was first designed like this but it was) then the other person does not see the changes in that query.
As I sit here typing this I just thought, what if I move the query to the back end and link to it.mmmm will this work? are there any methods of updating the front ends automatically?

regards
Ian M (UK)

Program Error
Programmers do it one finger at a time!

 

[Darrylles]

Hi,

You can't 'link' queries.

All queries should be in your back-end (they are after all views of data-tables). The back-end should contain data.

The whole point of splitting your app. into front-end, back-end is to distinguish data from application interface objects (forms, reports) etc.

Why are users allowed to edit queries in any case? What if they edit a query that is pre-defined and used by a form/report?

Regards,

Darrylle


Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[traingamer]

I'm sure Darrylle meant "All queries should be in your front-end".

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Darrylles]

Trainer,

You're absolutely wrong; I meant what I said.
Thing is, what I meant was wrong. (Thanks Trainer).

Yep - of course - queries in the front-end.
I have a legitimate excuse for this, but I ain't got the time or energy to explain - my employer requires more of my 48 hours per day to add 10 more reports.

(Don't give users access to queries though (don't give users access to anything), if they change a query that a form or report depends on, then you will answer).

Regards (and regrets)

Darrylle



Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[ProgramError]

As I mentioned in the original question, the database was inherited from someone else. As it happens I am completely rewriting it in a new DB but until that is finished they are still using the old DB. The users are familiar with the DB and have been using it for several years now so know not to alter things in it.
The point about the query is...
one person is taking bookings for offair tv recordings and enters the information. during the day the other person who makes the recodings, prints off the labels with the details like times and channels etc for the next days recordings.
As a safety measure the person taking the booking enters the request number of any late requests in the criteria of a select query(the one in question) and the person recording just does a quick query first thing in the morning to catch these LATE requests.
the problem I'm hveing at the moment is because i have split the DB and put a FE on each of the users comps, the query not updated on the other persons comp and recordings are being missed hence the moving of the query into the BE.

- pauses for a breath -

BTW the new DB will not allow any direct access to any forms queries etc.

Phew
Ian M
bringing a little light humour to the forums..
Its midnight and I'm kn***rd night night.




Program Error
Programmers do it one finger at a time!

 

[easyit]

...it is very well possible to make a link to a query with sql:

SELECT *
FROM qQueryName IN ''[path to database];

The two single quotes are neccesary

Regarding the problem, I still don't see a reason for users to modify queries. Why not create the different queries that are being used and oresent them thru a form to your users?

 

[easyit]

...it is very well possible to make a link to a query with sql:

SELECT *
FROM qQueryName IN ''[path to database];

The two single quotes are neccesary

Regarding the problem, I still don't see a reason for users to modify queries. Why not create the different queries that are being used and present them thru a form to your users?

 

[ProgramError]

Thanks easyit

I've created a new table and form for them to each enter and alter each others data. I then altered the original query to lookup its criteria from the newtable, produced new FE's for both of the users, and restricted them access to the underlying query. Came to me in a flash as I was on the way to work. BTW - moving the query to the BE part of the DB didn't work - I could find a way to link to it from the FE's.

thanks for all advice.




Program Error
Programmers do it one finger at a time!