"Your network access was interrupted. To continue close the database, and then open it again"

[barret bonden]

We get "Your network access was interrupted. To continue close the
database, and then open it again"

This is with Access 2007 on Vista I have 6 other machines running XP that
dont have this problem I have the backend
MDB on a 2008 server.

To tell you the truth I'm sick of MS, Vista, and all of MS's disfucntional
garbage. I've been writting in Acess since 1995, but if someone knows of
another DB front end please let me know.

.

--
Net/Works Consulting
www.networks-cc.com
sup...@networks-cc.com

[AccessVandal via AccessMonster.com]

Have you patch vista and A2007 with SP1? And it might be an issue with
Server2008 with Vista.

barret bonden wrote:
>We get "Your network access was interrupted. To continue close the
>database, and then open it again"
>
>This is with Access 2007 on Vista I have 6 other machines running XP that
>dont have this problem I have the backend
>MDB on a 2008 server.
>
>To tell you the truth I'm sick of MS, Vista, and all of MS's disfucntional
>garbage. I've been writting in Acess since 1995, but if someone knows of
>another DB front end please let me know.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200903/1

[Tom van Stiphout]

On Tue, 17 Mar 2009 13:34:23 -0500, "barret bonden"
<sup...@networks-cc.com> wrote:

The error message points to disfunctional garbage with your network
infrastructure. Isn't it obvious it's not the application that's the
problem if 6 users are doing just fine?

-Tom.
Microsoft Access MVP

[Keith Wilby]

"barret bonden" <sup...@networks-cc.com> wrote in message
news:49bfed2d$0$20302$607e...@cv.net...

>
> I've been writting in Acess since 1995,
>
>

And yet you still feel the need to ask a question when the answer is
patently obvious to anyone with a modicum of experience?

[david]

Still nothing that I am aware of.

Apart from that, yes, I am repeatedly disappointed with the lack
of testing and development for this product, and that includes the
network and file system support it depends on.

Of course there was a new system planned for Vista, but it got
canned. Maybe that's where all the resources went.

(david)

"barret bonden" <sup...@networks-cc.com> wrote in message
news:49bfed2d$0$20302$607e...@cv.net...

[Tony Toews [MVP]]

"barret bonden" <sup...@networks-cc.com> wrote:

>We get "Your network access was interrupted. To continue close the
>database, and then open it again"
>
>This is with Access 2007 on Vista I have 6 other machines running XP that
>dont have this problem I have the backend
>MDB on a 2008 server.

This could be a Vista specific problem. Issues that you may encounter
when you open or are using a Microsoft Office Access database on a
computer that is running Windows Vista - 935370.
http://support.microsoft.com/?kbid=935370

This hotfix talks about problems between two Windows Vista systems
which isn't exactly the same environment as yours. Nevertheless
worth checking out.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Chris-Wilkinson]

I'm experiencing the same issue also. I recently installed an SBS2008 server
for a customer and he is getting this problem with an Access database he uses
that previously worked fine.

Since SBS2008 is so new I think this is a new problem that hasn't had a fix
issued but I'm not the only one experiencing it.

I found this link but was wondering if anyone can translate part 2 of
Stefan's answer for me so I can understand it. I'm not a database developer

http://www.pcreview.co.uk/forums/thread-3738838.php

Many thanks

Chris

[Tony Toews [MVP]]

"barret bonden" <sup...@networks-cc.com> wrote:

>We get "Your network access was interrupted. To continue close the
>database, and then open it again"

I've forwarded your posting to folks within the MS Access product
group.

[Tony Toews [MVP]]

"Chris-Wilkinson" <u50691@uwe> wrote:

>I'm experiencing the same issue also. I recently installed an SBS2008 server
>for a customer and he is getting this problem with an Access database he uses
>that previously worked fine.

Does he also have Windows Vista clients? If he has Win XP clients
are they having the same problem?

>I found this link but was wondering if anyone can translate part 2 of
>Stefan's answer for me so I can understand it. I'm not a database developer
>
>http://www.pcreview.co.uk/forums/thread-3738838.php

Part 2 is from my website.
http://www.granite.ab.ca/access/performanceldblocking.htm
Take a look at the section titled Bound Form and ask more questions if
that isn't clear. Which it may very well not be as I'm not a very
good tech writer.

[Tony Toews [MVP]]

"barret bonden" <sup...@networks-cc.com> wrote:

>We get "Your network access was interrupted. To continue close the
>database, and then open it again"

BTW is this a split system with a FE on each client PC and a BE on the
server?

[Chris-Wilkinson via AccessMonster.com]

Hi Tony

Thanks for your reply.

I've asked the customer and he says that they have Access 2007 on all their
PCs. 4 are Vista and have this problem. 1 is XP and has not had this problem
as yet.

They developed the database themselves but don't know what is meant by front
end/ back end so I presume not. I installed the server as a straight
replacement for their old SBS2003 server. I didn't concern myself with what
the data was too much. I just used robocopy to move the data from one server
to the other. In that sense they are just Access 2007 clients accessing an
MDB file stored in a share on the 2008 server. I've made not made any changes
as yet to how the server operates as a file server. All settings are still
default so opportunistic locking is still turned on as is shadow copy.

Having not seen the database itself and not being an an access user really
your advice about using a bound form is a bit beyond me. What should I ask
him that would be helpful to you? I may ask him to register so he can post
here himself.

Many thanks

Chris

--

[AccessVandal via AccessMonster.com]

One thing is for sure, you can’t just copy the Back End Database into the new
server. It involves relinking tables if it is a split database. You’ll have
to relink all users Front-End.

If it is not a split database, that’s even worse. Sharing a non-split is not
the solution. If you need to split, look here (this blog) first before using
the Wizard.

http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

And make sure all users have access right the Server 2008 folder including
Read, Write, Delete, and Modify. Does the users have permission to access the
Server?

--

Please Rate the posting if helps you.

Message posted via http://www.accessmonster.com

[Chris-Wilkinson via AccessMonster.com]

Thanks everyone,

I'm waiting for my customer to get back to me about the file permissions but
he is thinking about migrating up to SQL get around this problem.

He has SBS2008 Premium so he's already licensed for it

--

[a a r o n _ k e m p f]

wow.. you guys really are a bunch of retards.

move to ADP-- it won't give you this trouble, I guarantee it

Please ignore Tony Toew's posting as Tony's answer to just about
every question is linked tables and jets. No matter how appropriate
his
response.

Aaron Kempf
MCITP: DBA SQL 2005

On Mar 26, 2:39 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:

> "barret bonden" <supp...@networks-cc.com> wrote:
> >We get  "Your network access was interrupted. To continue close the
> >database, and then open it again"
>
> I've forwarded your posting to folks within the MS Access product
> group.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can
> read the entire thread of messages.

>    Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm

[Greg Wood]

Tom,

Let's think about your answer... which was "The error message points to disfunctional garbage with your network

infrastructure. Isn't it obvious it's not the application that's the problem if 6 users are doing just fine?"

Okay, let's think about that shall we...if 6 machines are having no problem at all on the SAME network, how can the issue so obviously lie within his network?

I personally have seen this issue on Access versions 2003, 20007 and now 2010.

As a consultant I would NOT recommend access for mission critical multi-user applications. It simply is NOT a viable or robust enough solution to effectively meet your needs. If you want a viable solution there are a number of ways to go about implementing a multi-user database driven application. First I would suggest you look into SQL Server (express editions work fine) for the backend database. You can either write a windows app for your frond end using Visual Studio or you can write a web-based front end for your app which has it's benefits.

> On Tuesday, March 17, 2009 2:34 PM barret bonden wrote:

> We get "Your network access was interrupted. To continue close the
> database, and then open it again"
>
> This is with Access 2007 on Vista I have 6 other machines running XP that
> dont have this problem I have the backend
> MDB on a 2008 server.
>
> To tell you the truth I'm sick of MS, Vista, and all of MS's disfucntional
> garbage. I've been writting in Acess since 1995, but if someone knows of
> another DB front end please let me know.
>
> .
>

> --
> Net/Works Consulting
> www.networks-cc.com
> sup...@networks-cc.com

>> On Tuesday, March 17, 2009 11:01 PM AccessVandal via AccessMonster.com wrote:

>> Have you patch vista and A2007 with SP1? And it might be an issue with
>> Server2008 with Vista.
>>
>> barret bonden wrote:
>>

>> --
>> Please Rate the posting if helps you.
>>

>> Message posted via AccessMonster.com
>> http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200903/1

>>> On Tuesday, March 17, 2009 11:59 PM Tom van Stiphout wrote:

>>> On Tue, 17 Mar 2009 13:34:23 -0500, "barret bonden"
>>> <sup...@networks-cc.com> wrote:
>>>
>>> The error message points to disfunctional garbage with your network
>>> infrastructure. Isn't it obvious it's not the application that's the
>>> problem if 6 users are doing just fine?
>>>
>>> -Tom.
>>> Microsoft Access MVP

>>>> On Wednesday, March 18, 2009 4:57 AM Keith Wilby wrote:

>>>> And yet you still feel the need to ask a question when the answer is
>>>> patently obvious to anyone with a modicum of experience?

>>>>> On Thursday, March 19, 2009 10:02 PM david wrote:

>>>>> Still nothing that I am aware of.
>>>>>
>>>>> Apart from that, yes, I am repeatedly disappointed with the lack
>>>>> of testing and development for this product, and that includes the
>>>>> network and file system support it depends on.
>>>>>
>>>>> Of course there was a new system planned for Vista, but it got
>>>>> canned. Maybe that's where all the resources went.
>>>>>
>>>>> (david)
>>>>>
>>>>> "barret bonden" <sup...@networks-cc.com> wrote in message
>>>>> news:49bfed2d$0$20302$607e...@cv.net...

>>>>>> On Monday, March 23, 2009 8:19 PM Tony Toews [MVP] wrote:

>>>>>> "barret bonden" <sup...@networks-cc.com> wrote:
>>>>>>
>>>>>>
>>>>>> This could be a Vista specific problem. Issues that you may encounter
>>>>>> when you open or are using a Microsoft Office Access database on a
>>>>>> computer that is running Windows Vista - 935370.
>>>>>> http://support.microsoft.com/?kbid=935370
>>>>>>
>>>>>> This hotfix talks about problems between two Windows Vista systems
>>>>>> which isn't exactly the same environment as yours. Nevertheless
>>>>>> worth checking out.
>>>>>>

>>>>>> Tony
>>>>>>
>>>>>> --
>>>>>> Tony Toews, Microsoft Access MVP
>>>>>> Please respond only in the newsgroups so that others can
>>>>>> read the entire thread of messages.
>>>>>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>>>>> http://www.granite.ab.ca/accsmstr.htm
>>>>>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

>>>>>>> On Thursday, March 26, 2009 5:17 AM Chris-Wilkinson wrote:

>>>>>>> I'm experiencing the same issue also. I recently installed an SBS2008 server
>>>>>>> for a customer and he is getting this problem with an Access database he uses
>>>>>>> that previously worked fine.
>>>>>>>

>>>>>>> Since SBS2008 is so new I think this is a new problem that hasn't had a fix
>>>>>>> issued but I'm not the only one experiencing it.
>>>>>>>

>>>>>>> I found this link but was wondering if anyone can translate part 2 of
>>>>>>> Stefan's answer for me so I can understand it. I'm not a database developer
>>>>>>>
>>>>>>> http://www.pcreview.co.uk/forums/thread-3738838.php
>>>>>>>

>>>>>>> Many thanks
>>>>>>>
>>>>>>> Chris

>>>>>>>> On Thursday, March 26, 2009 5:39 PM Tony Toews [MVP] wrote:

>>>>>>>> "barret bonden" <sup...@networks-cc.com> wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>> I've forwarded your posting to folks within the MS Access product
>>>>>>>> group.
>>>>>>>>
>>>>>>>> Tony
>>>>>>>> --
>>>>>>>> Tony Toews, Microsoft Access MVP
>>>>>>>> Please respond only in the newsgroups so that others can
>>>>>>>> read the entire thread of messages.
>>>>>>>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>>>>>>> http://www.granite.ab.ca/accsmstr.htm
>>>>>>>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

>>>>>>>>> On Thursday, March 26, 2009 6:00 PM Tony Toews [MVP] wrote:

>>>>>>>>> "Chris-Wilkinson" <u50691@uwe> wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Does he also have Windows Vista clients? If he has Win XP clients
>>>>>>>>> are they having the same problem?
>>>>>>>>>
>>>>>>>>>

>>>>>>>>> Part 2 is from my website.
>>>>>>>>> http://www.granite.ab.ca/access/performanceldblocking.htm
>>>>>>>>> Take a look at the section titled Bound Form and ask more questions if
>>>>>>>>> that isn't clear. Which it may very well not be as I'm not a very
>>>>>>>>> good tech writer.
>>>>>>>>>

>>>>>>>>> Tony
>>>>>>>>> --
>>>>>>>>> Tony Toews, Microsoft Access MVP
>>>>>>>>> Please respond only in the newsgroups so that others can
>>>>>>>>> read the entire thread of messages.
>>>>>>>>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>>>>>>>> http://www.granite.ab.ca/accsmstr.htm
>>>>>>>>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

>>>>>>>>>> On Thursday, March 26, 2009 6:00 PM Tony Toews [MVP] wrote:

>>>>>>>>>> "barret bonden" <sup...@networks-cc.com> wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> BTW is this a split system with a FE on each client PC and a BE on the
>>>>>>>>>> server?
>>>>>>>>>>

>>>>>>>>>> Tony
>>>>>>>>>> --
>>>>>>>>>> Tony Toews, Microsoft Access MVP
>>>>>>>>>> Please respond only in the newsgroups so that others can
>>>>>>>>>> read the entire thread of messages.
>>>>>>>>>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>>>>>>>>> http://www.granite.ab.ca/accsmstr.htm
>>>>>>>>>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

>>>>>>>>>>> On Friday, March 27, 2009 5:41 AM Chris-Wilkinson via AccessMonster.com wrote:

>>>>>>>>>>> Hi Tony
>>>>>>>>>>>
>>>>>>>>>>> Thanks for your reply.
>>>>>>>>>>>
>>>>>>>>>>> I've asked the customer and he says that they have Access 2007 on all their
>>>>>>>>>>> PCs. 4 are Vista and have this problem. 1 is XP and has not had this problem
>>>>>>>>>>> as yet.
>>>>>>>>>>>
>>>>>>>>>>> They developed the database themselves but don't know what is meant by front
>>>>>>>>>>> end/ back end so I presume not. I installed the server as a straight
>>>>>>>>>>> replacement for their old SBS2003 server. I didn't concern myself with what
>>>>>>>>>>> the data was too much. I just used robocopy to move the data from one server
>>>>>>>>>>> to the other. In that sense they are just Access 2007 clients accessing an
>>>>>>>>>>> MDB file stored in a share on the 2008 server. I've made not made any changes
>>>>>>>>>>> as yet to how the server operates as a file server. All settings are still
>>>>>>>>>>> default so opportunistic locking is still turned on as is shadow copy.
>>>>>>>>>>>
>>>>>>>>>>> Having not seen the database itself and not being an an access user really
>>>>>>>>>>> your advice about using a bound form is a bit beyond me. What should I ask
>>>>>>>>>>> him that would be helpful to you? I may ask him to register so he can post
>>>>>>>>>>> here himself.
>>>>>>>>>>>
>>>>>>>>>>> Many thanks
>>>>>>>>>>>
>>>>>>>>>>> Chris
>>>>>>>>>>>
>>>>>>>>>>> --

>>>>>>>>>>> Message posted via AccessMonster.com
>>>>>>>>>>> http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200903/1

>>>>>>>>>>>> On Sunday, March 29, 2009 9:08 PM AccessVandal via AccessMonster.com wrote:

>>>>>>>>>>>> One thing is for sure, you can???t just copy the Back End Database into the new
>>>>>>>>>>>> server. It involves relinking tables if it is a split database. You???ll have

>>>>>>>>>>>> to relink all users Front-End.
>>>>>>>>>>>>

>>>>>>>>>>>> If it is not a split database, that???s even worse. Sharing a non-split is not

>>>>>>>>>>>> the solution. If you need to split, look here (this blog) first before using
>>>>>>>>>>>> the Wizard.
>>>>>>>>>>>>
>>>>>>>>>>>> http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> And make sure all users have access right the Server 2008 folder including
>>>>>>>>>>>> Read, Write, Delete, and Modify. Does the users have permission to access the
>>>>>>>>>>>> Server?
>>>>>>>>>>>>
>>>>>>>>>>>> Chris-Wilkinson wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Please Rate the posting if helps you.
>>>>>>>>>>>>

>>>>>>>>>>>> Message posted via http://www.accessmonster.com

>>>>>>>>>>>>>> On Tuesday, April 07, 2009 6:05 AM a a r o n _ k e m p f wrote:

>>>>>>>>>>>>>> wow.. you guys really are a bunch of retards.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> move to ADP-- it won't give you this trouble, I guarantee it
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Please ignore Tony Toew's posting as Tony's answer to just about
>>>>>>>>>>>>>> every question is linked tables and jets. No matter how appropriate
>>>>>>>>>>>>>> his
>>>>>>>>>>>>>> response.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Aaron Kempf
>>>>>>>>>>>>>> MCITP: DBA SQL 2005
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>

>>>>>>>>>>>>>> On Mar 26, 2:39=A0pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
>>>>>>>>>>>>>> www.granite.ab.ca/accsmstr.htm

>>>>>>>>>>>>>> Submitted via EggHeadCafe
>>>>>>>>>>>>>> OAuth Basics for .NET Developers
>>>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/16beeea4-4332-4d23-8433-ade0ae6dbcbd/oauth-basics-for-net-developers.aspx

[Tony Toews]

On Wed, 10 Nov 2010 13:23:05 GMT, Greg Wood <gr...@jugger.ca> wrote:

You do realize that you replied to a message stated March 17, 2009?

>> On Tuesday, March 17, 2009 2:34 PM barret bonden wrote:

And you didn't trim the postings on your reply.

Tony
--
Tony Toews, Microsoft Access MVP

Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/