Just to add to the discussion...
My wife and I share several databases that I built, and the backends are all on a NAS (La Cie RAID server.) On one or two occasions over the years, one or both of us has gotten locked out. It usually requires a re-boot of the server to clear the lock. I know that Access sends tons of lock requests to any network server, so I suspect the server is sometimes missing an "unlock" request that leaves the file hanging.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jeff Jones
Sent: Wednesday, August 01, 2012 2:05 AM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS
Well, after all my wonderings, I can only agree with your analysis. I don't see any other possibilities. Maybe the server change will fix things.
----- Original Message -----
The Db is opened by a hyperlink on an html file on the citrix portal that copies the most recent front end over to their h: drive and opens it from there.
I've also done numerous checks including with my own experiences if I've got more than one session opened. Again, the intermittency is just a strange thing and makes me think that a network hiccup is disconnecting and reconnecting although never releasing a lock on the file... thus the user ends up trying to relock a file that they just had locked. It screams to me that this is what is happening, but I don't get any verification and no error logs because of the NAS.
I just took a count and as of this minute I have 18 users logged in simultaneously to one database. Of course separate front ends, one back end, record level locking on edited record. Things run smoothly for a fair amount of time, so this is not a consistent issue. It just happens on occasion, but with higher usage, the intermittency is more frequent.
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 3:50 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS
Liz,
OK, one more one more thing. How is the DB opened? Is it via Access itself after opening Access or can some folks open it via Windows Explorer or some other file manager? The double clicking opening thing can sometimes allow the app used to do the double clicking to retain possession, even after the DB is closed.
I admit that I'm running outta possibilities. Big honking sigh.....
Jeff
----- Original Message -----
:-) Exactly. A lot of people say they "know" Access, but then when it gets going... you know who is going to have to finish up the project.
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 3:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Access back ends on NAS
Liz
What really happened was Jeff and I were the first REAL Access developers they ever met.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Liz Ravenwood
Sent: Tuesday, July 31, 2012 2:55 PM
To: 'MS_Access_Professionals@yahoogroups.com '
Subject: RE: [MS_AccessPros] Access back ends on NAS
Jeff,
I absolutely ABHORE spaces in names. :-) That's not something I'm dealing with here I believe. How did you diagnose that that was your problem?
It's so funny that both of you gentlemen have had to use Access databases to help IT out with their needs when they officially didn't support it in the first place. Something about biting feeding hands or something...?
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 Jeff Jones
Sent: Tuesday, July 31, 2012 2:48 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Access back ends on NAS
Liz,
One more thing. A healthy group of time ago an Access DB landed in my lap (I suspect because I happened to be sitting down). One of the countries in Europe were using a Citrix server. The Access database had problems because various tables, etc. had names with spaces in them. I used a utility to replace all spaces with underscores and their problems went away. This might be something to check.
Bill, one of the last Access databases I used at "work" was used for configuration management purposes to document pertinent data about the corporations software assets.
Jeff
----- Original Message -----
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.
--
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]
------------------------------------
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.
--
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
