A2000 mdb: form not opening (visible?) for all users

  • Thread starter Thread starter Andrea Hahn
  • Start date Start date
A

Andrea Hahn

Hello,
I am confused by a strange effect regarding one form in my database and hope
someone perhaps has got an idea to help me on:

I am using a number of Access 2000 mdb Clients to manage some "private" data
stored locally and also open a read-only connection to a central
SQL-Server-database. Since the main form, showing those "central" data, is
rather complex and does not allow for the Access-provided filtering
mechanisms, I added some comboboxes for selecting filter criteria and a
small extra form for navigation purposes: the user selects a value, and a
small navigation form pops up that allows jumping to the relevant records.

Now, while this works fine on a number of machines in the network, it does
not on others: for one and the same client application, opening it from one
machine the navigation form works just fine, but on others this one form
will not open as expected. This also seems to be machine (or
Access-installation)-dependent: if I log on to one of the computers where
the form does not open, it also does not open for me. Can this have
something to do with the default settings of References unter the Tools
menu? Usually I would expect compiler messages if something were wrong with
the libraries on the client machine. What other possible reasons could there
be?

Thanks for any ideas,
Andrea
 
There can be several reasons.

First check references, but I suspect you may need to also look at DNS to
make sure the computer is connecting correctly. You are correct that there
should be some sort of error message. If the references are correct (none
marked Missing), and the connectivity is OK, I'd start rebuilding the form 1
combo at a time to make sure it isn't in the local installation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top