Re: Database Split and Linked Table

They can open and
use the db but in some forms there are combo boxes looking to tables and
when
the other users try to look at those fields, anything shows.

This sounds like the main reason for your post, and combined vs separate FE
may be only a related issue.

Not only is it normal to have a separate FE on each PC, but in every case I
know of Access itself is installed separately on each user's PC (whichever FE
scheme you use). I cannot imagine anyone actually using MSAccess.exe over a
network (like, how would you install or uninstall it?)

The problem is to find out what is different between a user which works and a
user which doesn't work. You could very well have different versions of Access
on different PC's (Office Service Packs would amount to a different version of
Access). Or, for all I know, you may think there is only one FE on a server,
but there could be an older FE version you stuck in a backup folder which
someone is picking up, or they copied-over an FE to their own PC and didn't
tell you. If you have no direct way of determining what software versions are
being run (Access, FE, possibly libraries which might get updated by other
installed s/w) then how can you start to tell what's going on?

All these disasters happen. I'm an Expert! (on disasters)

Another disaster is to believe when any client tells you they did something.
They are being honest of course (within their recollection) but you have to
have some way to verify it. Perhaps ask some questions about some unrelated
new features of a supposedly updated FE?
(anyway unrelated questions give you time to think <g>)

Chris


.

Relevant Pages