Cannot open access database on network

[Steve2507]

Hi,

I'm hoping someone on here can help as this is really winding me up now.

We have a small office network. The server is running SBS 2003, two clients are on XP Pro and the third is on Vista Ultimate 64 Bit.

Each client is running Access 2003.

We have an Access database which can be opened by all the clients except the new one (the Vista Ultimate). When we try to open it Access hangs and stops responding. Eventually forcing us to force Access to close. It then leaves the ldb file on the server which stops anyone else opening it.

To make matters even worse we can't delete the ldb file as the server then hangs. We are forced to do a reboot of the server just to delete the ldb file and allow others to open the database.

The database was in 2000 format, but we have tried to change the format to 2002/2003 and it makes no difference.

Any help greatly appreciated.

[JElder]

Can you make a copy of the database and open it locally?

If you can, it would imply there is a rights issue with the Vista machine. If not, there is likely to be something up with the installation.

Do check your antivirus on the vista - get it to ignore .mdb and .ldb files (or temporarily disable it)

If you cannot delete the .ldb, what error do you get? if it is access denied, then only the Vista machine has rights to the file - need to check permissions again.

If this does work, consider having the front end (forms) locally on each machine, linking to a back end with the tables - this is good practice from a security and performance basis only.

(I know this doesn't help, but I have not yet added a Vista desktop to the network - stuck with XP as I know this works! There are a couple of patches you have to install on SBS2003 to get Vista working properly, but I think they only affected Outlook - but well worth going to Windows Update on the SBS box)

[Steve2507]

Thanks for the help. I'm at home now so will try it out tomorrow or Monday.

[Dot Net Guru]

Thanks for the help. I'm at home now so will try it out tomorrow or Monday.

You need the hot fix - h t t p : / / support .microsoft .com/kb/937248/en-us

Nick Chambers, Freelance Web Developer
Website: w w w. nickchambers .co.uk