database - Is there a way to do sql queris on access but outside of the program?

Question

I have a case where I want to make tool for people in my company to use. It's simple tool to import log-type data into database, than tool should sort data and do some operations on it (like calculate difference between time based on previous record etc). But I'm restricted by corporation security programs so I have to stick to office and tools that don't require installing anything new.

I made access which do the job, but due to bad performance on even small portion of data I have to look for something else. Also excel is not an answer due to limitation in number of lines.

Is there a way to make some tool that will use Access as database, but will do operations on data outside of it, and the result will be returned to access as completed table? For what should I look to make such tool?

Answer 1

Vb.net is a Microsoft language that is easy to learn, you can create an application graphically, you can connect it to access DB. it will really help you in your situation. I'm personally using it to create access data managing apps.