Filter Combo Box by Login ID

[Pamela]

Our company has about 5 different computers on our Network that all have been
using their own copy of an Access db. I thought this would be fine as I like
that they each only have access to their own records which are relevant to
them. This is, however, creating a difficulty for me as far as updating the
db or fixing any errors. I find I have to go through and do it over and over
5 times. I've read up on splitting the database but want to know if I were
to create a login form for each appraiser could I then filter the records and
combo boxes by their login?

Also, I'm a little confused about if this will help with my programming
issues since the forms and code all seem to go on the front-end which would
be loaded on each computer, right? Would I still have to go and change the
code on each computer??

Thanks so much for any help with this!

Pamela

 

[Dale Fye]

1. Yes, you can use the users login ID to filter data. I do this all the
time. One of the nice things about this is that users can be assigned to
specific roles which you can use to determine which forms, reports, and even
controls that your users may see or use.

To get their login ID, use the code located at:

http://www.mvps.org/access/api/api0008.htm

You will need to copy this code and put it into a public code module.


2. The goal of having a Front End (FE) / Backend (BE) configuration is that
all of your data will reside in a single location on a network server. It
sounds like you currently have five different sets of data, and are having
to merge that to get the "total picture" for your organization (which can be
very time consuming). Most people that using this configuration use a
separate application to update the FE application that sits on their users
computers. The version I use checks to see whether the version number of
the application on the users computer matches the version number of the
application sitting on my server. If not, this application copies the newer
version to the users computer, starts that application, and then quits.
Tony Toew's has what he calls his Auto Front End Updater, located at:

http://www.granite.ab.ca/access/downloadsindex.htm

HTH
Dale