Existing Access Databases
There are thousands of businesses still running Access systems.
The most common issues we find:
- No documentation
- Performance problems
- Multi-user corruption
- Old VBA
- Broken mail merge
- Broken ODBC links
- Excel exports everywhere
- Redundant queries, forms, reports
- Unused, unknown parts
“Stabilize and extend existing Access systems without forcing a costly rebuild.”
Access + SQL Server Modernization
Using SQL Server as a backend can boost new life into your fading Access database.
Typical issues with existing systems
- Access frontend is fine
- Backend is breaking
- Multiple users
- Remote access needed
- Reporting slow
- Backups poor
We provide
- Split database
- SQL Server migration
- Performance tuning
- Stored Procedures
- ODBC repair
- Cloud or SQL Express solutions
- Azure/VPN access
- Reporting cleanup
- VBA refactoring
“Implement a robust and secure Backend database on the Cloud or Server with your existing frontend.”
Access Database MOT
We provide a full MOT for your database
- Corruption risks
- Performance review
- VBA quality review
- Split DB review
- Backup review
- SQL migration readiness
“Help plan the next steps.”
Emergency Access Support
Businesses panic when:
- Frontend breaks
- References fail
- Runtime issues appear
- Windows updates break systems
- Charging for time on call to the nearest 30 minutes
“Security for your key business asset.”
Why We are Unique
There are few developers available these days who can do what we do.
- Understand old systems
- Diagnose broken VBA
- Recover databases
- Stabilize multi-user Access
- Integrate with SQL Server
- Deal with non-technical staff
“Unique and bespoke.”
Cost Saving
Many software providers will insist you ditch the Access database. Replacing these systems can cost €50k–€300k.
“Saving a database or postponing change can prove highly valuable.”
Integration with Modern Microsoft Services
Access Databases can combine with modern Microsoft Services to enhance the database.
- Power BI
- Power Apps
- Azure basics
- REST API integration from VBA
- OAuth / Office 365 authentication
“Improve your existing database.”
New Access Databases
We still build new access databases. Advantages are:
- Tailored to your business intelligence
- Rapid Low Cost development
- Ideal solution for small databases with low user base
- An upgrade on Excel spreadsheets
- Great solution for prototyping larger systems.
- You own the database and the data. Not some money grabbing software multinational.
“Own your business intelligence.”
This database tracks inspections carried out on rental properties for a council.
The data is loaded via Excel spreadsheets using an automated import routine.
The search filters on the logged in users inspections.filters on Eircode, Batch, Inspection count and a free text search.
There is a coloured coded status. Clicking on a column will sort the data.
