Access will not open

[Jesse]

Hello,
I'm using access 2002 sp-2 on w2k machines with and
without sp4, also we use XP pro with sp1. My office uses
Access for our shipping and recieving database. Everything
was working fine for months and without notice the
database will no longer open on some machines, there were
no updates applied to the machines or to office and no new
software installed. Other people have no problem opening
this database so I know it is not the database. The error
message in the event viewer is:

Faulting application msaccess.exe, version 10.0.4302.0,
faulting module msaccess.exe, version 10.0.4302.0, fault
address 0x00209bbe.

HELP almighty Access gods!!!

 

[Joseph Meehan]

I don't have an answer, but I do have a question.

Does each user have their own copy of the database or are they sharing a
copy on a LAN? Is any security in effect?

 

[Tony Toews]

HELP almighty Access gods!!!

I'm using access 2002 sp-2 on w2k machines with and
without sp4, also we use XP pro with sp1. My office uses
Access for our shipping and recieving database. Everything
was working fine for months and without notice the
database will no longer open on some machines, there were
no updates applied to the machines or to office and no new
software installed. Other people have no problem opening
this database so I know it is not the database. The error
message in the event viewer is:

Faulting application msaccess.exe, version 10.0.4302.0,
faulting module msaccess.exe, version 10.0.4302.0, fault
address 0x00209bbe.

Actually Joseph is on the right track. Which hadn't occurred to me.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It also supports
Terminal Server/Citrix quite nicely.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm