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

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

5 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    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...

    Source(s): Microsoft Knowledge Base: http://support.microsoft.com/search/ Free courses on MS Access with chapters on Macros and Modules: http://office.microsoft.com/en-us/access/CH1007399... http://www.free-ed.net
  • Anonymous
    6 years ago

    VB Language is used to programming at ms access.

  • olis
    Lv 4
    3 years ago

    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.

  • 1 decade ago

    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.

  • How do you think about the answers? You can sign in to vote the answer.
  • Fudge
    Lv 5
    1 decade ago

    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 !

Still have questions? Get your answers by asking now.