ACCESS FEED: RE: [MS_AccessPros] Access back ends on NAS

Excellent questions, Jeff. Thanks.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jeff Jones
Sent: Tuesday, July 31, 2012 12:59 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Liz,

Hmmm, what happens if you actually open the DB and then open as you normally would? Do you get the same error message?

Does the problem show up only after the DB has been opened and closed or does it sometimes happen the first time it's opened after rebooting your PC? If the problem only occurs after the initial opening of the DB, then maybe the way it's being closed after the first time leaves tne system thinking that it's still opened. And, how it it being opened? Is it opened via a file open window within Access or by double clicking on it through a file manager? If one and not the other, then maybe trying the alternate way to open it will let it be fully released when closed.

Can the DB be copied to your hard drive and if so, does the problem present itself?

After 30+ years developing software, some IT folks sometimes remind me of the newlywed who's wife always cut both ends off the ham but she couldn't explain why other than her mother did it. Her mother had the same explanation. Finally the grandmother explained that it was the only way to get the ham to fit in the pan. I get the impression that there are some IT folks who were standing on a corner when the building was built and they could never find the door. Please note I said "some IT folks", not all.

My apologies if all these have been considered. Due to age and an occasional occurrence of terminal crankiness, I don't always see an entire thread.

Jeff

----- Original Message -----

Bill and what makes it worse in this situation is I get an "Admin has it open on DC####" where DC is the name of a citrix box in across the country.

...and don't even get me started with what conversations have been transpiring between me and the corporate IT folks!

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Tuesday, July 31, 2012 12:28 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Access back ends on NAS

Liz

If it isn't in the message there is no magic to get it. I sometimes see 'Admin' has it open on PCNameGoesHere

Other than that, I'm useless to you. I don't have any experience with Citrix except I I know that oranges, lemons and limes are in the Citrix group. Oh, and grapefruit, too.

Bill

--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood <liz_ravenwood@...> wrote:
>
> Yes Bill, I know and have done that too. I could see that I only had the database open 1x and could verify by looking at my citrix connection center.
>
> NAS: http://en.wikipedia.org/wiki/Network-attached_storage
>
> ... and the way we run things here, the message says user "admin" is all... for my own stats I gather the network login in other areas, but don't know how to get it at this msg.
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Tuesday, July 31, 2012 11:35 AM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Access back ends on NAS
>
> Liz
>
>
>
> One quick reply...You'll get that "exclusive rights" thing if you already have
> the DB open. I've done that lots of times. Read the message all the way through.
> It might tell you the name of the computer that has it open.
>
>
>
> What's NAS? "Network Aggravating System?
>
>
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT < http://thatlldoit.com/ > http://thatlldoit.com
> MS Access MVP
>
> < https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E >
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
> My Nothing-to-do-with Access blog
>
> < http://wrmosca.wordpress.com > http://wrmosca.wordpress.com
>
>
>
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
> Sent: Tuesday, July 31, 2012 9:43 AM
> To: 'MS_Access_Professionals@yahoogroups.com <mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> Subject: [MS_AccessPros] Access back ends on NAS
>
>
>
>
>
> Greetings, Has anyone ever had an access back end on an "NAS" ???
>
> A strange anomalous error that has been intermittent has started happening with
> a higher frequency.
>
> It "feels" like at time there is a partial network disconnect and a process
> holds on to a file and then when the process tries to grab the file it thinks
> it's already locked.
>
> For example, my very own database that nobody gets in to, and nobody even has
> rights to get in to "Lizzy's control panel" - I pop in and out of design mode
> and make design changes frequently but would get an error message saying that I
> don't have exclusive rights to the database.
>
> I've seen this with other types of files such as excel, where I've got a file
> open, save, do something, save, do something else, and then get a similar error
> message. Other users experience the same thing and I'm going the rounds with
> corporate IT.
>
> They are thinking that they may actually move one of the back ends to a windows
> server instead of the NAS and ... ??? well,
>
> Any experience, comments, etc.?
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you are
> not the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com <mailto:Christopher%40ExcelAndAccess.Com>
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net <mailto:jpjones23%40centurylink.net>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]