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!
- Capt CrasherLv 61 decade agoFavorite 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
- Anonymous6 years ago
VB Language is used to programming at ms access.
- olisLv 43 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.
- TheMadProfessorLv 71 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.
- FudgeLv 51 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 :
Good luck !