AVSIG: Help with Excel wwswsigarch.jpg (7236 bytes)

✈ . . . . . . ✈ . . . . . ✈ . . . . ✈ . . . ✈ . . ✈ . ✈ . . ✈ . . . ✈ . . . . ✈ . . . . . ✈ . . . . . . Touch-and-Go to our Live Forum (This is a Read-only Archive of the 2004-2017 AVSIG Forum)


AVSIG Discussion Sections >> Hardware/Software

Terry Carraway
Top Gun


Reged: 06/02/04
Posts: 7098
Loc: Maryland
Re: Help with Excel
      12/17/15 02:17 AM

Quote:

Whenever I hear about MS Access, I shudder. Nothing to do with the program, but how organizations use it.

MS Access was never designed to operate well over a network. It can operate just fine over a relatively high-speed, low latency Ethernet network, but it performs very poorly when run over a wide area network which usually includes a significant increase in latency.

As my day job involves helping clients move data centers, with almost every move we hear about issues of slow performance. Very often it is tied to a "critical" Access database that was never captured as a key application but has now been moved to a remote data center. Performance is poor, and the client basically has two choices: 1) Move the Access DB back to be local to the users, or 2) Migrate from Access to a full-fledged SQL Database with a front-end application residing on the user's desktop.

Grumble, Grumble, Grumble. Current client is dealing with this right now from our move in November.

John




Absolutely.

It is a great single user, write a database to do what YOU need, but never intended to be a robust, multi user, remote database.

We used to have an application that ran on an Access backend, but only the local, laptop version we used when traveling. The data was then sneaker netted (security reasons) to an Oracle database that did the heavy lifting.

The whole application (laptop and mulituser around the world) not runs SQL Server.

--------------------
Terry
Mostly 0W3

Post Extras Print Post   Remind Me!     Notify Moderator


Entire topic
Subject Posted by Posted on
* Help with Excel Ward Miller POU-NY 12/09/15 05:29 PM
. * * Re: Help with Excel Bruce Gorrell [EQY]   12/12/15 09:17 PM
. * * Re: Help with Excel Kcid LlirreM   12/11/15 09:07 AM
. * * Re: Help with Excel sreyoB yrraL   12/11/15 09:19 AM
. * * Re: Help with Excel Kcid LlirreM   12/15/15 08:53 AM
. * * Re: Help with Excel sreyoB yrraL   12/15/15 11:18 AM
. * * Re: Help with Excel Terry Carraway   12/15/15 02:56 PM
. * * Re: Help with Excel John O'Shaughnessy [FCM]   12/16/15 12:26 PM
. * * Re: Help with Excel Terry Carraway   12/17/15 02:17 AM
. * * Re: Help with Excel Russell Holton   12/16/15 12:31 PM
. * * Re: Help with Excel Terry Carraway   12/12/15 02:19 AM
. * * Re: Help with Excel sreyoB yrraL   12/12/15 09:37 AM
. * * Re: Help with Excel Terry Carraway   12/13/15 12:41 AM
. * * Re: Help with Excel sreyoB yrraL   12/09/15 06:32 PM
. * * Help with Excel Ward Miller POU-NY   12/09/15 09:15 PM
. * * Re: Help with Excel sreyoB yrraL   12/10/15 09:00 AM
. * * Help with Excel Ward Miller POU-NY   12/10/15 10:31 AM
. * * Re: Help with Excel Terry Carraway   12/10/15 11:18 AM
. * * Help with Excel Ward Miller POU-NY   12/10/15 05:34 PM
. * * Re: Help with Excel Terry Carraway   12/11/15 03:32 AM
. * * Re: Help with Excel sreyoB yrraL   12/10/15 12:35 PM
. * * Help with Excel Ward Miller POU-NY   12/10/15 05:34 PM
. * * Re: Help with Excel Bill Bridges - 9S1   12/12/15 11:00 PM
. * * Help with Excel Ward Miller POU-NY   12/13/15 06:04 AM
. * * Re: Help with Excel Mase Taylor   12/10/15 11:10 AM
. * * Re: Help with Excel Mase Taylor   12/09/15 09:25 PM

Extra information
0 registered and 9 anonymous users are browsing this forum.

Moderator:  Mike Overly 



Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 5221

Rate this thread

Jump to

Contact Us AVSIG

Powered by UBB.threads™ 6.5.5

Logout   Main Index    AVSIG Aviation Forum