Command button fails to fire on click?!?

[Larry Kahm]

A client has told me that there are several workstations in his shop where
command buttons on the primary menu don't function.

The application is split into front-end and back-end databases; however, the
front-end is located on the server - not each desktop.

Since everyone accesses the same front-end mdb, what would I look for to see
why some workstations don't work, but others do?

Thanks!

Larry Kahm
Heliotropic Systems, Inc.

 

[Ken Snell [MVP]]

Not knowing what the buttons do, it's hard to say. But you're asking for
trouble to have everyone using the exact same front end file. Give each user
an individual copy of the front end; avoids corruption, conflicts, etc.

 

[M.L. Sco Scofield]

My first guess is that there is something referenced in the database that
exists on some machines and not others.

The first thing to do is put a separate copy of the front-end database on
everyone's computer as Ken suggested.

Next, on the machines that don't work, look for broken or missing
references.

Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;231413. Follow the
instructions in the "Resolution" section.

My guess is that this will solve your problem.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Larry Kahm]

Thank you both!

I'm going to be working with the client's IT staff to distribute the
front-end, but that is going to take some time. Their concern is how to
handle on-going maintenance to the contents. I'm just beginning to research
possible solutions.

In the meanwhile, that KB article doesn't display correctly in Firefox, so I
got quite a surprise when there was no Resolution section. There's no
problem showing it in IE.

I'll be sure the check the various workstations for missing VBA references
later this week.

Again, thanks for your suggestions.

Larry Kahm
Heliotropic Systems, Inc.

 

[Ken Snell [MVP]]

Maintaining front ends....is as simple as copying a new front end on top of
the old front end on the user's computer.

See Tony Toews' site for some ideas -- he has written an automated front end
updater utility as well.
http://www.granite.ab.ca/access/downloadsindex.htm

See these articles for more info about splitting a database:
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.allenbrowne.com/ser-01.html