trouble opening Access files

[associates]

Hi,

I was wondering if i could get some help here. I think this is to do with the security issue. I usually double-click to open or run an access file (for example student.mdb) that sits on the server with no problem. But this time, nothing happen when i did double-clicked on it from my laptop while the file was being open by someone'else on another computer. I know that it makes sense that we shouldn't open a file that's being used by other users. But my curiosity is that should it not give you a warning like (you know) you're not able to save any changes or things like that. No, i didnot get any of that messages. It's just nothing happen after trying to open it by double-clicking it.

I have set the macro security to low level but that did not help either. Is there any thing that i need to tweak?

Thank you in advance

 

[The_Doc_Man]

Normally you should get a file sharing violation (which is a WINDOWS error) if that is what is actually happening. I am not sure that you are seeing that class of violation, though.

 

[battenberg]

for starters - is it a shared database? look under: tools>options>advanced...

maybe you should split the database to form a back end, create a MDE as a front end, then launch the MDE from both your laptop and your mates PC, instead of launching the design master.