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

Problem connecting to back end database

P: 1
Hi, I have a network of five PCs with 4 running Vista Home Basic with the other one running XP. I have an Access 2007 database system wherein the back end is installed in the public folder of one of the Vista PCs. I installed a copy of the front end on each of the 5 PCs. The problem is , on two of the Vista PCs, the PC crashes when the front end connects to the back end and another PC is already connected to the back end. I have already checked the Access default open mode and it is set to "shared". I already tried disabling my antivirus and firewall to no avail. The settings for all the Vista PCs in the Network and Sharing center are all identical. When the problematic PCs are the first to connect to the back end, the others can connect without any problem. Is there anything else that I could do? Please help. Thanks.
Aug 9 '10 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,561
If you've already checked the sharing settings in the client installation then I can only guess this is a networks/OS Configuration issue.

Unfortunately this is not an Access issue (assuming I'm correct of course) and worse, I suspect even the networks guys would need more information from you to have any idea what the issue is. I know that's not easy, as you probably would have posted anything you understood to be relevant.

I could move it to the Networks forum if you feel it may help, but I wouldn't hold out too much hope to be fair. It's probably the sort of thing you'd need to get someone in to look at for you.

Good luck anyway, and welcome to Bytes!
Aug 9 '10 #2

Expert 100+
P: 107
Is the front end on the network as well?

If so there could be a problem if different users map to the back end in different ways. That could be the case if the back end is referred to using a drive letter and users have that drive mapped to a different network location.

Instead of referring to the back end tables with a drive letter, use the full network path: \\server\directory\mydatabase.mdb
Aug 9 '10 #3

NeoPa
Expert Mod 15k+
P: 31,561
From the OP...
Ronal Ocampo: I installed a copy of the front end on each of the 5 PCs.
Aug 9 '10 #4

Expert 100+
P: 107
Ah - missed that.

On the crashing PCs, could it be it is just taking a long time to link to the back end? Ctrl-Break allows you to stop the code from executing, for cases where Access seems to freeze. Try pressing Ctrl-Break and waiting a minute or two to see if you get into the code.
Aug 9 '10 #5

Post your reply

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