You are here:

Using MS Access/access at back end and gui at front end


QUESTION: hi, hlw r u dear

i want to adk that  i have developed an access database for e-testing, i want to put the access at back ground and want a graphical user interace at front end so no one could know that ms accesd is being used for this e-testing.
thanx in advance

ANSWER: Hello Mehr,

I'm a bit confused with your question, as to what I understand

1.You want to have Access as a Back-end to another User Interface which will serve as a front-end

If this is what you're looking for, please let me know what help do you need in this regard? How can I help you.

Awaiting your response.

Thank you
Best regards
Manish Batola

---------- FOLLOW-UP ----------

QUESTION: hi sir, hope u r fine

you got it right.
i just want to ask is it possble to have Access as a Back-end to another User Interface which will serve as a front-end. if possible then how can i do that?

thank you

best regards

Hello Mehr,

ODBC Driver is the solution.

Access can be a Back-end database for any front-end development tool in this world which can provide a ODBC Driver which can help in connecting to the Access database.

Many ODBC drivers are available free from Microsoft itself from their download site to get connected to Access. But there are some ODBC drivers which are provided by 3rd Party Vendors who will charge you for this program. For example if you want to connect Access as a front-end to Linked-in/Facebook as a backend, or something very unique which can be used mostly for digital marketing.

Lately the buzz is of connecting Access with Sql-server running on Linux/Unix or Access with Big-Data etc.

Choose your tools carefully before you jump into any serious project.

Best regards
Manish Batola  

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Manish Batola


ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.


29+ yrs in the Software industry with 23yrs completely dedicated on more than 350 Various Microsoft Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Worked in various multinationals catering from Aerospace, Oil & Gas etc.

-BSc - Computer Science -MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2016 All rights reserved.