Programming MS Access 2003. What language is best to program with Access 2003?

Question

I use queries in Access but have to many that I have to execute. Would like to write a program to do it in one click. I have a programming background so learning a new one shouldn't be too difficult but don't want to spend too much time doing that.

Is VB.net, or learning SQL or something like Python the way to go?
I like to program it within the Access application and just click on a button to have it run. But I suppose if I have to program it outside of Access application then I'll do it.

Thanks ahead of time!

Dean

Answer 1

In MS Access click the "MACROS" tab or button to work with the macros. They allow for simple automation (sequential drop list of available commands like OPEN QUERY, OPEN FORM, etc...). Top line is step one, 2nd line step 2, etc... Name one "Autoexec" and it will run when the DB is opened.



For more complex automation Click the "MODULES" tab. This will give you access to the built in VBA (Visual Basic Access) editor. It's just a scaled down version of VB, but does have some specific syntax variations and proprietory commands for working within the DB structure. Shouldn't be a real problem to figure it out with your background.



Sometimes it's faster to build a Macro, have Access convert it to a VBA Module (I'ts under the right-click popup I think...), then "upgrade" it within the editor...

Answer 2

VB Language is used to programming at ms access.

Answer 3

no longer an excessively nicely theory. The webpages created by ability of ability of get right of entry to are for database porpuse onlu, they frequently terrific works on the pc with get right of entry to connected. If u desire some handy answer to make internet website then use Frontpage, in spite of the shown fact that i'm able to recommand that u be knowledgeable HTML.

Answer 4

Since you're already dealing with a Microsoft product, .NET is probably the way to go - there are numerous classes already in the framework to facilitate connecting and transferring data between the database and the GUI, so you don't have to reinvent the wheel.

Answer 5

ur database manipulation ( insertio, update, delete, etc) will always be in SQL

But ur logic can be in Python , VB, or any suitable language; since VB is a Microsoft language , then go ahead for it



Try this link :



http://www.blueclaw-db.com/accessvisualbasic/

Good luck !