Access 97 Database Won't Open

[markjrees]

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

 

[oldaf294]

mark,
This is probably a moot point, but did you check to see if the "Target" and "Look in" properties of the icon are set to the correct location for the database?
jim

 

[markjrees]

what's a moot point?

we checked the target and look in properties. the problem even happens if we copy the database in question locally to the C drive on the computers.

still they cant open it

 

[Bat17]

Have you checked for differences in references?
Any module Tools>references...

Peter

 

[markjrees]

Bat17 - I did want to try that although I cannot access the database on the workstations in question.

Can this be done from any machine or are the references specfic to each computer?

btw - is the Tools>References menu accessed via the Modules tab (then into VB?)

 

[Bat17]

It is found in any module. Alt-F!! will bring up the code pages for you.

You will need to check the References on each PC. The references could be altered by other software that shares the sames Office libarys being updated.

Peter