[AccessD] Back-End DB is locking...WHY?!

Jim Lawrence accessd at shaw.ca
Wed Jan 15 18:31:02 CST 2014


Sorry Doug:

It was posted to see if there were any fanbois around. ;-)

On that subject though I have had a few run ins with product, within a network environment. Small networks never seem to have any issues. 

OTOH, within a larger network there have been events that has left me gun shy. 

Once a network that I was partly responsible for, with mixed Windows and Macs, a file corrupted...upon further investigation it turned many graphic files had corrupted. In the end, the branch lost a number of files. We never did discover the reason but the managers changed everything to Windows and as far as I know similar incidents were never repeated.    

I was working with a client, the local newspaper. We recommended that the company use Windows server to manage their archives. The local manager, who basically frowned on anything other than Apple, insisted on Apple servers and that only Mac specialists would manage the servers. As far as we were concerned that was fine. Two months later the Mac servers crashed...for no apparent reasons (We suspected (were told off the record) poor data management and Mac servers but that was never official.) The result, was that 150 years of archives were lost.

Do I blame Mac for this...maybe not but a mixture of Macs and Windows within a network have been involved with two of the major disasters in 35 years of computing. Maybe I am just being superstitious but everytime someone says Mac and Windows networks, the hair stands up on the back of my neck.

Jim
  
----- Original Message -----
From: "Doug Steele" <dbdoug at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Wednesday, 15 January, 2014 10:25:09 AM
Subject: Re: [AccessD] Back-End DB is locking...WHY?!

Huh?  What exactly do you mean?  I've got a mixed Mac/Windows network at
home, and have never had problems connecting Macs to clients' networks.

Doug


On Wed, Jan 15, 2014 at 9:36 AM, Jim Lawrence <accessd at shaw.ca> wrote:

> Hi all:
>
> The truth be known that no matter how nice the Mac machine, they can not
> do networking...kind of sad but true. They can still do internet though.
>
> Jim
>
> ----- Original Message -----
> From: "Gustav Brock" <gustav at cactus.dk>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>
> Sent: Tuesday, 14 January, 2014 11:12:20 PM
> Subject: Re: [AccessD] Back-End DB is locking...WHY?!
>
> Hi David
>
> You have been fooled somehow. Macs are goood! Spell: g-o-o-o-d => gooood.
>
> /gustav
>
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af David A Gibson
> Sendt: 14. januar 2014 21:13
> Til: 'Access Developers discussion and problem solving'
> Emne: Re: [AccessD] Back-End DB is locking...WHY?!
>
> A word of caution when sharing DBs between PCs & Macs.  One year we had an
> MS Access 2010 .accdb shared between about 40 users with as many as 15-20
> accessing it at one time without any problems.  The next year or the one
> after, we did it again and had all kinds of file corruption problems.
>  Turns
> out that whenever a Mac user running Access in Parallels would manage to
> lock their computer without exiting the DB it would corrupt data tables.
> Had a lot of lost work before we figured it out.
>
> David Gibson
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list