This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.
COURSE of the MONTH
11 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Cannot open database in access, claims network error, but problem persists even when trying to open it locally?
Posted on 2011-09-21
I hace an access database that is located on a DFS share (redirected documents folder).
There are no access issues to the file, i can view it, and copy it no problems.
When i try to open it I get the message "Your network access was interrupted. To continue, close the database, and then open it again". This erro in it self makes no sense, since it is indicating that there are network access issues (and as I said I can reach the location just fine on a gigabit wired network).
I then tried to copy the entire database on to the users desktop. this worked just fine, but when I try to open it I get the same message. SO now I apperantly have networking issues opening a file on the desktop?!
Help?!
There are no access issues to the file, i can view it, and copy it no problems.
When i try to open it I get the message "Your network access was interrupted. To continue, close the database, and then open it again". This erro in it self makes no sense, since it is indicating that there are network access issues (and as I said I can reach the location just fine on a gigabit wired network).
I then tried to copy the entire database on to the users desktop. this worked just fine, but when I try to open it I get the same message. SO now I apperantly have networking issues opening a file on the desktop?!
Help?!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
7-
5
4- +1
17 Comments
Active 2 days ago
Do you have any linked tables? If so, one of them might be the source of the error.
Active today
Also check the fundamentals:
1. Users have full privs (read, write, delete) for the directory where the DB resides (check both share and directory security).
2. Make sure the disk has plenty of free disk space.
3. Make sure the DB is not being virus scanned at open.
Jim.
Helen_Feddema:
I was thinking that might be it since it gives this problem even when I try to open it locally off the desktop,
Sadly I am but a sysadmin, and have no clue how to check that. Any pointers in checking WHAT it can't connect to or IF it links to an outside source?
I was thinking that might be it since it gives this problem even when I try to open it locally off the desktop,
Sadly I am but a sysadmin, and have no clue how to check that. Any pointers in checking WHAT it can't connect to or IF it links to an outside source?
Active 2 days ago
Are you running Windows 7? If so, it might be a security problem with the database folder.
Active 2 days ago
The linked tables have an arrow to the left of the table name (see screen shot)
Tables.jpg
Tables.jpg
Helen_Feddema:
I added the location to trusted locations in Access, but it IS windows 7. Do you mean that it is a rights issue with his documents folder, or is there another angle I am missing?
So I open the database, and if I find blue arrows on the left of the 'Tables' means that there are external sources? (sorry, am slow, just want to be 100% sure I understand the issue).
I will look for 'linked table manager' inside Access, thanks.
I added the location to trusted locations in Access, but it IS windows 7. Do you mean that it is a rights issue with his documents folder, or is there another angle I am missing?
So I open the database, and if I find blue arrows on the left of the 'Tables' means that there are external sources? (sorry, am slow, just want to be 100% sure I understand the issue).
I will look for 'linked table manager' inside Access, thanks.
No, they have never successfully opened this database form this particular (DFS) location, it makes no difference if I am using DFS or "\\server" or IP address. But regardless of that I get THE SAME message even if I try to run a copy of that database from the desktop (if someone is still doubting my network - it took about 5 seconds to copy this database @27MB from the server top the desktop, so I know there isn't a networking infrastructure issue).
Someone else is using a similar setup and it works fine (though with another database).
Windows 7 32bit
Access 2010
Someone else is using a similar setup and it works fine (though with another database).
Windows 7 32bit
Access 2010
Active today
What does the Access DB do?
This isn't a front end database that connects to a back end db like SQL is it?
This isn't a front end database that connects to a back end db like SQL is it?
pgm554
It is a self contained MS Access database
I could not tell you if it was created in 2010 or not.
It is a self contained MS Access database
I could not tell you if it was created in 2010 or not.
Active today
Well,if it was converted from an earlier version of the program,there could be issues because of a bug in the compiler(Access 2000) that could be causing the issue.
Try this:
In Access 2010,go to the Compact and Repair Database on the Database Tools ribbon and try to see if that fixes it.
Make a backup copy of the DB before you do this.
Try this:
In Access 2010,go to the Compact and Repair Database on the Database Tools ribbon and try to see if that fixes it.
Make a backup copy of the DB before you do this.
Active today
Check this out and if you have an XP box around ,test it out there and see if you get the same issue.
http://answers.microsoft.com/en-us/office/forum/office_2007-access/your-network-access-was-interrupted-to-continue/61ed2ca6-ec77-40dd-8251-6f453a6ecb85
http://answers.microsoft.com/en-us/office/forum/office_2007-access/your-network-access-was-interrupted-to-continue/61ed2ca6-ec77-40dd-8251-6f453a6ecb85
Featured Post
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory.
NOTE: For Outlook 2016 and 2013 perform the exact same steps.
Open a new email: Click the New email button in Outlook.
Start typing the address: …
Suggested Courses
Course of the Month11 days, 17 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.