I have a slooow Database. Everytime I go from one form to another (through buttons) it takes longer and longer as time goes (still developing database). So I tried converting my macros ( only bout 10 or so) into VBA through the setup they have on the wizard. My question is, now that I converted to VBA, can I delete the macros?? If not then what is the point of converting to VBA other than more flexibility of programming. Also any tips on how to "unclutter" my database to make it go quicker??

Thanks

Yes after converting delete the macro's, but make sure your not calling the macro's anymore.

Try "Compact and repair" to reduce your database's "weight", as time goes by though and more and more data goes into the database.... it will ineffitably slow down :(

Here is a page on other tricks to speed up access: http://www.blueclaw-db.com/access_consultant_rapid.htm

JR