Selasa, 31 Juli 2012

RE: [MS_AccessPros] Access back ends on NAS

 

I just told my cubicle mates how much I adored this group also for the emotional support. Yes, fun and laughs are wonderful.

I started out my morning with a HUGE belly laugh. My cat was doing her morning contemplation and occasional swat at a dragonfly next to the swimming pool, and when I opened the door it startled her so much she fell in. She was able to get out quickly and in her good humored way, just shook it off and was only minorly embarrassed. If only I had a video camera... It'd be $100,000 easily cause she's so cute and fat and presented such a delightful image.

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@yahoogroups.com] On Behalf Of Jeff Jones
Sent: Tuesday, July 31, 2012 2:52 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Hi Liz,

I saw the link and wondered. However since I've loved Dylan since the early 60's, I paid it no mind.

BTW, feel free to use any of the pleasantly playful pithy pontifications I spew forth. I think that fun ought to go along with all the corporate messages. If I can't find fun in what I'm doing, I might as well try to inflate a fishnet.

Jeff

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





Hi Jeff,

Backups supposedly happen over night - according to our IT across the country.

I have inactive shutdown implemented.

I love your expression, "optical rectiosis!" I'm stealing it. :-) That and the screen door on a submarine. I'm stealing that one too.

... weird how I have a url in the bottom of my last msg... I guess Jonah Lehrer resigned... :-(


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@yahoogroups.com ] On Behalf Of Jeff Jones
Sent: Tuesday, July 31, 2012 2:28 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS

Hi Liz,

I wasn't thinking about a permanent local copy; just a test to see if the error happens locally. But, since other files give the same error on the h: drive, then never mind.

Is it possible that backups are getting in the way? I have backups that continually happen whenever files get updated. Do backups happen on a regular schedule or are they based on nothing more than file changes.

Since the DB is mult-iuser, is it possible that some users head off to lunch without closing their connection? Could logic be added to log someone off if no activity happens for a fixed period of time?

The last place I foraged for bucks in Corporate America had an IT department that was so blind to the capabilities of Access that they had optical rectosis and would never think of ever allowing an Access DB to live in their hallowed production environment, even if it was read only. In this case they were as useful as a screen door on a submarine.

And, thank you Bill.

Jeff

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





Jeff,

It's intermittent and unexpected and not replicated at will with all of those scenarios.

We can run and run and run and then it just occasionally happens.

These are high use databases and need to have multiple user access and so local copies are not an answer.

But yes, I've had other network files - such as something on my personal h: drive give similar error messages.

One of many troubles is that it is on this NAS and our network group don't have access to error logs to check for file lock errors that I suspect. Apparently an NAS is a paired down environment with minimal logging.

What they are going to do is test a back end to a windows server instead of this NAS and see if it behaves better.

http://money.cnn.com/news/newsfeeds/gigaom/articles/2012_07_30_after_fabricating_bob_dylan_quotes_jonah_lehrer_resigns_from_the_new_yorker.html
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@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@yahoogroups.com ] On Behalf Of Bill Mosca
Sent: Tuesday, July 31, 2012 12:28 PM
To: MS_Access_Professionals@yahoogroups.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 , 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@yahoogroups.com ] On Behalf Of Bill Mosca
> Sent: Tuesday, July 31, 2012 11:35 AM
> To: MS_Access_Professionals@yahoogroups.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@yahoogroups.com ] On Behalf Of Liz Ravenwood
> Sent: Tuesday, July 31, 2012 9:43 AM
> To: 'MS_Access_Professionals@yahoogroups.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
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




[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.



--


Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.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




[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.



--


Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.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




[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.

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar