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

Bill, Good story! Thanks! HA!

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 2:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Access back ends on NAS

Liz

My two "hot" Access applications right now are our Application Master System
which houses everything about all the applications we support (252 last count).
It stores ownership and user contact info, Server details, SQL Server instance
details, patching schedules and history, vendor details, SLAs, troubleshooting
for the helpdesk, links to all documentation.

The other one is a project management application with details on all projects
having anything to do with our IT department, resource hours (projected and
actual), time sheets that show how many hours we spend in project and
non-project areas, documentation requirements for BP8, graphs showing resource
utilization.

And, of course they both have all the reports that go with those kinds of data.
I built them both in Access 2003 with SQL Server 2005 back ends.

All of this amuses me because when I was hired I was told we don't support or
build Access databases. I would clean up one the Financial Analysts used for
Fiscal Period reporting and then I would be doing SQL DBA work. Ha! Eight years
later I still spend 80% of my time on modifications or new applications. Good
thing I love working with Access. I'm the Access IT support that we aren't
supposed to have.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Tuesday, July 31, 2012 1:40 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Access back ends on NAS

Here's my latest argument that nobody can argue with:

We have engineering change management through Access databases that was to have
been incorporated in to Siemans TeamCenter. Well, they failed, nobody talks
about how much money and time was spent on that endeavor that seems to have been
backburnered... nobody says anything... nobody knows... BUT - yes, they
"supported" that endeavor.

Meanwhile, our business practices are still being accomplished quite well, thank
you very much, in Access databases.

So, their argument that they don't support Access, yet they supported the failed
attempt that cost a lot of money ... and we still need to get the work done and
are doing so successfully - in spite of these hiccups... hee hee...

I tell my boss that if I can carry functions that a multimillion "billion"
dollar company can't seem to carry - well then, they should pay more more moula.

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 1:19 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Access back ends on NAS

Liz

At least you're able to have conversations with IT. Some IT departments just
say, "We don't support Access." And that's the end of the discussion.

Regards,

Bill

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 12:38 PM
To: 'MS_Access_Professionals@yahoogroups.com
<mailto:%27MS_Access_Professionals%40yahoogroups.com> '
Subject: RE: [MS_AccessPros] Access back ends on NAS

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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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>
<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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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.

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

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