By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

mdb file not opening on network

P: 8
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!
Mar 21 '07 #1
Share this Question
Share on Google+
13 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Mar 21 '07 #2

P: 8
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
Mar 21 '07 #3

Denburt
Expert 100+
P: 1,356
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
Mar 21 '07 #4

P: 8
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
Mar 21 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Mar 21 '07 #6

Denburt
Expert 100+
P: 1,356
Interesting, although I have had this issue before I.E.7 but it very well could be, with Microsoft you almost never know.
Mar 21 '07 #7

P: 8
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.
Mar 21 '07 #8

P: 8
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.
Mar 21 '07 #9

Denburt
Expert 100+
P: 1,356
Good luck and let us know if you manage to nail it down.
Mar 21 '07 #10

P: 8
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.
Mar 21 '07 #11

P: 8
ok i have an answer,

http://windowsxp.mvps.org/networkfile.htm
Mar 21 '07 #12

MMcCarthy
Expert Mod 10K+
P: 14,534
ok i have an answer,

http://windowsxp.mvps.org/networkfile.htm
IE7 obviously considers an mde to be an executable file.
Mar 21 '07 #13

Denburt
Expert 100+
P: 1,356
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...
Mar 22 '07 #14

Post your reply

Sign in to post your reply or Sign up for a free account.