Question Microsoft Access can't find the database file

[Makibird]

Hi all

We've just started rolling out a DB in work but we're having some problems implementing it.

Access Runtime 2010 and SP1 are installed on the machines (all running XP). Then the the data sources are set up and the .accde is copied to c:\program files\microsoft office\office14\accwiz.

Last week we rolled it out on some test PCs and everything worked fine.

However, Saturday I did a little flexi time and set it up on the rest. After set up, I could use the database as an administrator. However, none of the normal users on the system can access it. Nothing about it has changed, all the files are still the same. The runtime install file and SP is located on our server - this is copied to each machine before installation.

This is the error we get:

Microsoft Access can't find the database file 'C:\Program Files\Microsoft Office\Office14\ACCWIZ\CONFLICT CHECKER BETA.accde'

Make sure you entered the correct path and file name.

The problem is, I have very little experience with split databases, I am setting this up as our IT manager is on holiday.

Every machine has been set up in exactly the same way, and almost every machine is cloned, so they should be identical - I don't understand why the PCs that have it installed over a week ago work, yet the PCs from this weekend don't. Does anyone have any suggestions?

Thanks!

Vicky

 

[Uncle Gizmo]

>>>Does anyone have any suggestions?<<<

From the desktop machine log in to the server, go to the particular folder where your backend copy of the Microsoft access database is stored and try and create a simple text file. This will indicate if you have a suitable permissions.

 

[Makibird]

Hiya

Thanks for getting back to me. All the folders (including those which do work) are set to Read, Read & Execute and List Folder Contents.

The database is used for searching for client details only, it's not meant to be written to by anyone.

We have at least four different user groups who access it asides from admins. Within each group there are users that can and users that can't access it, despite the fact that all the user permissions should be the exactly the same.

Unfortunately, while our admin is away I can't get into the server to check things from that side.

The only thing that the machines have that differ are updates - anyone who's been away on holiday or worked a late shift has had more windows updates installed than someone who's been in 24/7.

Then again, if that's the case, why would I be able to run the db when logged in as an admin?

 

[Makibird]

Thanks for your help guys! For some reason when we were setting the folder permissions, they weren't being inherited by the files. I came into work yesterday (boo) and got them all fixed. Now however, I'm getting a different issue, ODBC call failed when some users attempt to search. Fun fun!

Thanks again for all your help everyone!

 

[Makibird]

Thanks Pat.
All our users have the server mapped to Z:, there are no variations on this. I'm pretty sure the db is set to \\servername not z: anyway.

It was a bit of a weird problem, out of 50+ staff he's the only one who had it and it disappeared after a day. He's one of those users who tends to get weird problems for no reasons anyway, I think he's just jinxed!

I just wanted to say thanks again to everyone for all your help! I really appreciate it.