Here is a challenge for someone Re. a Multi User database.

[Essendon]

Hi,

I have a form with 2 list boxes. In one box is a list of all motels (the left box). The user can then select any or all of the motels in the left text box and include them in the second list box (the right one). The motels in the second list box will then be used to filter a report.

To help you understand my situation, I have put up a screenshot of the part of my form in question here.

When motel(s) are included in the right text box, they are stored in an array, and when anything is changed, I have code that takes all the motel codes in the array and converts them to a string that can be used in an IN() statement. This IN() statement is used upon the query that the right list box is based upon. Hence the right list box only shows the motels that been included.

It works well for a single user. However, when multiple users are using the one form, I have problems. The good thing is that separate arrays get created for each user, so each user has a different set of motels included, but because the right list box is based on the one query, when one user makes a change it calls the code that produces the IN() statement that the right list box is based on, and hence all other users now see the same list of motels.

Does this make any sense at all?

Any ideas?

Thanks very much,

Peter

P.S. All the code that handle the arrays is in a code module.
P.P.S To me, a simple way around this would be finding a way to populate the list box from the array in code, and bypass the query alltogether. Is this possible?

 

[raskew]

In a multi-user environment, consider splitting the database, e.g., tables (back-end) on the server with each user having their own front-end (queries, forms, reports, modules).

See 'Splitting Databases' in the help file for additional discussion.

 

[Essendon]

ta

Wasn't much of a challenge for you was it...

Thanks for your reply, I have looked into splitting databases and that is definitely the way to go...

 

[raskew]

Have you ever stopped to consider that, down under, your toilets spin backwards? Could that be a potential cause of the problem?

 

[Essendon]

Have you ever stopped to consider that, down under, your toilets spin backwards? Could that be a potential cause of the problem?

I don't know what your toilets are like, but here our toilets are bolted to the floor, so they don't spin at all. (hehe)

One more question regarding my db. At the moment I am using currentProject.Path to obtain the path of the db to link pictures into my database. Now that I have split my database, my pictures are stored with the server. Is there a function similar to currentProject.Path that would allow me to obtain the path to the server? (I don't want to have to hard code it)

Thanks raskew...

Peter

 

[Fornatian]

Is that where the phrase 'sit and swivel' orginates?

 

[Rich]

Is Skippy still on down there, I missed episode 3452.

 

[Essendon]

Skippy is on 7:30pm weeknights over here. They just started making a new series as well! I am excited about that because I really love the show. Its the second biggest tv show in OZ at the moment.

In the new series, skippy starts getting into trouble with the law and goes into drug rehab after an overdose. What a great show. You should start watching man.

hahahahahahah