When an Access Database Outgrows the Shared Drive: Azure SQL for Winston-Salem Teams
A clinic scheduling tool, a lab sample log, a supplier tracker: plenty of Winston-Salem departments still run on an Access file someone built years ago. It works until it corrupts, slows to a crawl or has to be opened from home, and then the data needs a proper home.
Our Azure consulting services in Winston-Salem focus on that moment. Edward Pinela, MBA, moves the tables out of Access or an overgrown Excel workbook into Azure SQL Database, keeps the forms and reports your staff already know wherever that makes sense, and sets up sign-in, backups and access rules so the data stops depending on one file on one drive.
The first step is a free 30-minute strategy call. There is no package price: once we have looked at the database itself, you receive a written, fixed quote. Microsoft bills your Azure usage directly, and every session is held remotely from Lightray's business address in Fullerton, California.
“Great firm, they understood our company needs really quickly… their approach was very hands on…”
— Jean-Michel C., Google review
What are the signs an Access database has outgrown the shared drive?
The common ones are a file creeping toward its size ceiling, a compact-and-repair ritual that now happens weekly, records locked whenever two people edit at once, and staff who cannot open it over a VPN without long waits. Any one of these means the data has outgrown a file-based database.
Microsoft's own Access specifications cap a database at 2 gigabytes, minus the space system objects need, and list 255 concurrent users as the theoretical maximum. A file shared across a network struggles long before either limit, because each query drags data over the wire to every user's computer.
- Compact and repair has become a weekly chore
- Two people editing the same record get a lock message
- The database is slow or unusable over a VPN
- Only one person understands how it works
- Copies of the file have multiplied on desktops and in email
Why do Winston-Salem organizations have so many of these databases?
Because many of the city's jobs sit inside departments of large institutions, and departments build their own tools. Greater Winston-Salem, Inc. names Atrium Health Wake Forest Baptist and Novant Health as Forsyth County's two largest employers and counts 43,657 people in health care and life sciences, about 21% of county employment in 2024.
Clinics, research groups, billing teams and their suppliers all needed something quicker than the IT queue, and Access or Excel was already installed. The same is true at the manufacturers and aerospace firms named among the region's target sectors, from Collins Aerospace to Corning. Those homemade tools often hold data that matters a great deal and is protected very little.
| Concern | Access file on a shared drive | Azure SQL Database |
|---|---|---|
| Size limit | 2 GB per database file | Up to 4 TB on a standard single database, more on Hyperscale |
| Backups | Whatever copies someone remembers to make | Automatic full, differential and log backups with point-in-time restore |
| Sign-in | Anyone who can reach the folder | Microsoft Entra accounts, with multifactor sign-in available |
| Working from home | Slow or unreliable over a VPN | Reached over an encrypted connection from Access, Power Apps or reports |
| Patching and upgrades | Tied to each user's Office installation | Handled by Microsoft for the database engine |
Does the Access front end have to be replaced?
Usually not at the start. Microsoft's SQL Server Migration Assistant for Access moves the tables into Azure SQL Database and links the existing Access application to them, so forms, reports and macros keep working while the data lives in Azure. Swapping the front end for Power Apps or a web app can come later, if ever.
Some queries do need rework, because Access lets forms do things a server database handles differently. We test every form and report against the migrated data with the people who use them, move slow queries to views on the server, and document what changed. Microsoft's SSMA for Access documentation lists Azure SQL Database and Azure SQL Managed Instance among the supported targets.
What does Azure SQL Database take off your plate?
The chores nobody was doing reliably. Microsoft patches and upgrades the database engine, takes full, differential and transaction-log backups automatically, and lets you restore to any point within the retention period. Sign-in runs through Microsoft Entra accounts, so a departing employee loses access the moment their account is disabled.
Small databases can run on the serverless tier, which bills compute per second of use, and Microsoft offers a free tier with a monthly allowance of serverless compute and 32 GB of storage, according to its Azure SQL Database overview. We size the database from the real file and real usage, and tell you whether the free allowance would cover it.
What does an Access-to-Azure project cost?
It is a fixed quote, given once we have seen the database. The main drivers are the number of tables, forms and reports, how much VBA code runs behind them, and whether patient or personal data calls for extra access rules. There is no monthly retainer, and Azure charges go on Microsoft's invoice to you rather than ours.
A short assessment comes before the quote, so the figure reflects the database you actually have, not a guess about a typical one.
Working with Lightray in Winston-Salem
One senior consultant handles the assessment, the migration and the handover. Edward has 20+ years in technology and 200+ delivered projects, and Lightray holds a 4.9 Google rating. For reports built on the new database, see Power BI help for Winston-Salem teams without an analyst.
Elsewhere in North Carolina, see Azure consulting in Greensboro and Charlotte. For the wider service, read our Azure consulting overview or open the Azure consulting locations list.
Further reading: Microsoft Learn — SQL Server Migration Assistant for Access.
Is one Access file holding up a whole department?
Book a free 30-minute call with Edward Pinela, MBA. You get an honest read on what to fix first — and if we are not the right fit, you will hear that on the call.
Frequently asked questions
Do you have anyone in Winston-Salem we would deal with?
No. Lightray works remotely only and has no Winston-Salem office or North Carolina staff; the business address is in Fullerton, California. Assessments, testing sessions and training all happen over video and screen share, scheduled within Eastern business hours.
Our database holds patient information. Is Azure still an option?
It can be, handled with care. Azure SQL Database encrypts data at rest and in transit, and access can be limited to named Entra accounts with multifactor sign-in. Your organization still decides whether the data may move and under which agreements with Microsoft; we configure and document the controls rather than make that call.
Can people keep working in Excel?
Yes. Excel connects to Azure SQL Database directly, so a workbook that used to hold the data can become a live view of it instead. People keep their pivot tables and filters, while the numbers come from a single source that everyone shares.
How long does a migration take?
A typical departmental database moves in a few weeks: assessment, a test migration, a round of user testing and a cutover over an evening or weekend. Databases with heavy VBA code or many linked files take longer, and the assessment tells you how much longer before you commit.
What do you need from us?
A copy of the Access file or workbook, a list of who uses it and for what, one person who can test the forms and reports, and permission to create an Azure subscription on your organization's own billing account.
You Won’t Get Handed Off to Junior Staff.
At most consulting firms, the senior person who sold you shows up for the kickoff — then you get handed to a team of juniors learning on your dime. That’s not how we work.
When you hire Lightray Solutions, you work directly with Edward Pinela, MBA — a principal consultant with 20+ years of experience across Power BI, web development, SEO, and CRM systems. Edward architects every engagement personally, stays involved through delivery, and answers his own phone.
Read Edward’s Full Bio“Mid-market companies deserve senior-level expertise without paying enterprise-agency prices. That’s the gap Lightray fills.”
Simple. Transparent. Proven.
No black-box processes. No endless discovery phases. A straightforward three-step approach designed to deliver measurable results fast.
Discovery Call
Free 30-minute strategy session where we assess your data landscape, website, marketing — and where AI would genuinely pay off versus where it's hype.
Free · No ObligationCustom Roadmap
You receive a tailored plan with clear deliverables, realistic timelines, and expected ROI. You approve every detail before we start.
Fixed Scope · Clear PricingMeasurable Results
We execute, measure, and optimize. You get dashboards, regular check-ins, and full visibility — so you always know the impact.
Data-Driven · TransparentGet a clear plan in one free call.
Tell us what you are trying to fix. Your request goes to Edward Pinela, MBA — the principal consultant who would do the work — and you hear back within 4 business hours.
Prefer to call? +1 (714) 872-9606