Access 97 Database Won't Open

[ch]

We've got a client that runs two access 97 based databases on their
network. up until recently both databases worked

fine on all workstations (all XP Pro).

About 3 weeks ago they called me to report that one of the databases
would not load on 3 workstations. It opened

fine on all the others. I checked out the permissions on the database
(which is stored centrally on the server) and

everyone had full control.

Within the last week they have added two new xp pro workstations to the
domain - neither of which can access the

database in question. they can access the other database no problem -
as can all the other workstations.


The occurs as follows:

1. Double click on the icon for the database

2. access 97 loads but does not load the database's interface - instead
it opens an empty version of access (with

file menu etc at the top)

3. no specific error messages at all.

4. close access and the standard xp program crash message appears (see
screenshots below)



As mentioned above, other workstations can open the database fine.

the only thing that has changed on the network is the installation of
some server and workstation based production

software - we have not yet consulted with the company that installed
this - we felt that if it was this software

causing the problem then all workstations would be suffering. we wil
have to consult with them once we've exhausted

all the possibilities.


Thanks in advance for any advice

links to errors:

http://www.techresource.co.uk/error1.jpg
http://www.techresource.co.uk/error2.jpg

 

[Pieter Wijnen]

Try opening the db from within Access (there are some stupid regsettings
that get written on first time opening of Access)
I will try to track them down again & post them, so you can add them
manually beforehand.
I have experienced this several times myself

HTH

Pieter

 

[Guest]

I have some access 97 databases that won't open unless office 97 serivce pack
sr2b is installed.

 

[eggedd2k]

opening from within access makes no difference unfortunately. i shall
install sr2b on one of the machines to see if that makes any
difference. weird thing is that it was working fine on all workstations.