mdb file not opening on network

[gcneal]

we have mdb running on windows xp and access 2003, we have several users on our network, but now only one user can access our mdb at the same time.

once one user is logged in and no other user can log in (clicking on the file name nothing happens), however from the server computer it will open direct from the harddrive not thourgh the network it makes no difference if anyone is on the network or not.

any comments!

[MMcCarthy]

First check the following:

In Tools - Options is the Default Open Mode set to Shared or Exclusive. It should be set to Shared in a multiuser environment.

Mary

[gcneal]

ok thanks Mary

already selected

I do recall changing from opreating system from 2000 to xp some time ago, maybe 2 users have not been in at the same time since.

i logged my computer into mdb today and then logged my laptop into mdb, both computers openned and logged into the mdb. however i logged my laptop into the mdb and then tried to log my computer in, and nothing happens

both computers access the mdb from the network

First check the following:

In Tools - Options is the Default Open Mode set to Shared or Exclusive. It should be set to Shared in a multiuser environment.

Mary

[Denburt]

gcneal seems like a LOT of people are having this issue. Simply put split the database and put the front end on the clients computer, your pc whatever.There is even code out there to help with the distribution of the frontend apps. Good Luck

[gcneal]

Thanks for your help Denburt, i had a feeling this was not my issue

its interesting i have just removed IE7, and now works fine although dont have IE7 on my computer now, Is there a setting in IE7 that stops this blocking action?

gcneal seems like a LOT of people are having this issue. Simply put split the database and put the front end on the clients computer, your pc whatever.There is even code out there to help with the distribution of the frontend apps. Good Luck

[MMcCarthy]

Thanks for your help Denburt, i had a feeling this was not my issue

its interesting i have just removed IE7, and now works fine although dont have IE7 on my computer now, Is there a setting in IE7 that stops this blocking action?

That's very interesting. Wonder if there's a patch.

[Denburt]

Interesting, although I have had this issue before I.E.7 but it very well could be, with Microsoft you almost never know.

[gcneal]

yes my thoughts too, no auto updates, no manual updates that I’m aware of, but I think I need to like closer

That's very interesting. Wonder if there's a patch.

[gcneal]

mm ok, im going to reinstall ie7 and see if its ie7 or a update within ie7

Interesting, although I have had this issue before I.E.7 but it very well could be, with Microsoft you almost never know.

[Denburt]

Good luck and let us know if you manage to nail it down.

[gcneal]

ok reinstalled ie7, the issue has come back! i have noticea a message i get with ie7 see below, this does not pop up on computers with ie6, but i can log in perfectly fine from one computer runing ie7 and any other computer running ie6.

Open File - Security Warning

Name: (then name of database)
Publisher: Unknown Publisher
Type: Microsoft Office Access Application
From: (network location)"

Good luck and let us know if you manage to nail it down.

[gcneal]

ok i have an answer,

http://windowsxp.mvps.org/networkfile.htm

[MMcCarthy]

ok i have an answer,

http://windowsxp.mvps.org/networkfile.htm

IE7 obviously considers an mde to be an executable file.

[Denburt]

Looks like we hit the sandbox again... I am currently working on an article that this fits right in with this. aargh Sandbox is only protecting us from beginners but is hampering our efforts as professionals...