Multivalued Look-Up Field Problem

[Mike Wood]

I have created a multivalued look-up field to pick the quarters (mo/year) of reports received. The database is on shared drive and used by multiple users. The problem is that when more than one user is on the database and entering data, that only the person who signed in first may select the multiple items, the second and subsequent users may not. What am I missing?

[orange]

You should investigate " splitting your database" http://www.fmsinc.com/microsoftacces...ter/index.html

[Mike Wood]

You should investigate " splitting your database" http://www.fmsinc.com/microsoftacces...ter/index.html

I split the database, then my users couldn't access the forms to fill in the data. I had to physically link each person to the BACK END database, which worked, however, after they exit then re-open it, they couldn't access the forms again. Since I have the database restricted (to keep folks for screwing with the data tables and such), how do I make the database automatically "REFRESH" with the linked tables upon opening?

[Mike Wood]

I figured it out. I went to each user and copied the front end, then had to re-link the tables via the "Linked Table Manager".

Once I was completed, I renamed their copies with the accdr file extension. None are the wiser.

[orange]

You split the database, you put the BE on a server. Each PC/user gets a separate copy of the FE.
There is code available for linking to the proper BE.
Google for automatic relinking of BE tables or something similar.
There is a link here http://www.databasejournal.com/featu...-Relinking.htm
but I'm sure there are others. Check a few forums and support sites and get a copy of code that works and has some followers.


If you need to deal with updates then the video and info at this link may be useful.
http://www.youtube.com/watch?v=s1-OOqvvpxs


OOOPS: I see you have answered while I was doing something else.

You could still get code to do the relinking each time the user logged on or started his/her front end.