= You can also use Excel in multiuser environment, to connect to
centralized database, enter data, read latest data updated to
database, generate reports from latest data stored in database. YES,
Excel can connect to databases, in our case we can connect to MS
Access database, you need not to have Access database installed in
any of the PC's but you can use this features.. Watch this video
for more details,Excel Automation with MS ACCESS
= You can Enhance the capacity of MS Access database size
limitation by using multiple Access databases linked to one central
Access database, and refer your front end application to central
Access database, this works with same effeciency but you will get
advantage of more than 2 GB limitation of Access database.
I have been working with Manjunatha on a complex Microsoft
Access database that was custom built to our specific
requirements. The database application also included
synchronization with data that we have on our Sharepoint site
which added complexity to the project. It has been a great
experience working with Manjunatha on this project. He has
always taken the time to understand the specific requirements
and has offered creative solutions throughout the entire
process. Communication has been excellent and he has been very
patient with the MANY changes that I have asked for during
this project. I would highly recommend Manjunatha for MS
Access and VBA projects
Thanks Manjunatha for creating a super useful file migration
tool! It saving us hours of work a day! A++ for
professionalism, customer service and communication.
Excel app to convert XML - I am very pleased with all aspects
of the work received.
Macro in Word/Excel to mail merge into individual PDF's - I
had a job, Manjunatha had a ready solution for me. Within an
hour I was provided with a solution. It didn't quite work
exactly as how I envisioned. Within 2 hours he provided me
with a fixed and working solution. The total time for the
project was quite short, based on his expertise and ability to
address and he knew exactly what he was doing. Would certainly
use his service again, if needed. Thanks!.
Export excel database into Json format - great work and
communication.
Excel to JSON and CSV output generator - Manjunatha did
excellent work on this project. We look forward to working
with him again. He is very skilled, timely, and professional.
Automating Frequency and Stratification reports in Access -
Manjunatha is an experienced programmer who understands how to
construct application efficiently that meet users need. A true
professional. Thanks.