10
LMagnus
7y

I work in a large organization that previously didn't have it's own development team. Therefore various business areas have built their own solutions to solve problems which mostly involve Access and Excel.

Many of these applications still exist and we are expected to resolve any issues with them and update them when necessary performing this support role while still expected to meet our (very tight) development timelines.

I can't tell you how much of a pain in the tits it is to be trying to power through a priority development only to be interrupted with an urgent instruction to fix a 17 year old Access database that's running slow.

Of course it's pissing running slow, it's 17 years old, has nearly a million records and you have multiple users accessing it across the country!! I think it's time to peacefully let it die.

Comments
  • 4
    At least upgrade to SQL Server. Our company has told the business units that Access will no longer be supported by the IT organization.
  • 0
    There's hundreds of them so a lot of effort to migrate then all and many would need more than just a SQL backend as they have a lot of business logic and front end functions.

    Refusing to support them means critical business functions will be blocked. Can't win.
  • 2
    We are slowly migrating all Access stuff to SQL Server and Oracle. I get handed that lovely work. It often requires an app team to port the UI or create a new app, but we get it done.
  • 1
    Point out your concerns with higher ups, document it professionally. So when you cant hit your development objectives its no surprise and your back is covered. Let them come up with a solution to a problem of their making.
  • 0
    u can start by porting to mssql and adding the sql tables as linked tables in access
  • 1
    Management are aware of the issue and there's not enough resource to migrate all of them. Most of the time they work fine but when one does fail it's a massive ball ache to stop what I'm doing and have to deal with it and users who think it's some kind of super system as it's survived so long.

    Cretins.
Add Comment