Error Messages - MANY

[access2010]

Hello, the MsAccess database network in the small charity that I volunteer at for is down again and has not worked as a network for over 3 weeks.

Each Network and Access consultant that we have had come into their office is offered the same contract, "They will pay the charges, if the network is usable by 5 persons for 1 week".

All the consultants have worked on folder permissions and Access security settings without any success. The data server is a Windows 2000 server and the workstations are Windows 2000 work stations.

To enable some work in their office, I have setup one of our computers as a single Data Base user server, the people trying to help me use our databases suggest that I change our back end to SQL, which should solve our problem..

What do you think?

 

[gemma-the-husky]

does the network fail?

do you find you can't "see" mapped drives etc? or is it just access failing?


SQL isn't necessarily a solution - you just shouldn't have this problem with access.

 

[access2010]

I can see the mapped drive on the data server and we can use ONE back end database at a time at the front end, if multiple users open two front end databases (ie; contacts), then the error messages start.

Many times the .Ldb back end remains open and to clear these files a reboot is required.

Everything was working perfectly for many years, until their network person did some changes. They have made no significant changes other than having another techie screw some things up, there's no reason why they shouldn't be able to get back up and running again if we can reverse-engineer what that guy screwed up, but what did he do?.