A database can grow larger, especially when you add more data to your databases. Access databases can occasionally become corrupt or damaged or deleting objects such as records, tables, forms, or ...

Does anyone have any simple ways of performing these functions within Visual Basic? I have found some snippets of code but they seem very complicated. I'm focused here on preventing or at least ...

5 seconds in google tells me that you can call Access with the "/compact" command line switch. Also, there's a KB article at support.microsoft.com that give further details.