Hey everyone. I'm new to this community, but I've been working with VB 6.0 for a few years now, but haven't done much with database programming. I'm working on a program that will allow a user to create and save databases, as well as switch between them whenever the user wants. I can switch the databases no problem...though it may not be the most effective way to do it (when a user clicks on a particular button, an Open dialogue box appears, they choose the database they want, the file name gets passed into a Global Variable, a Global Function is called, the original form is unloaded, then reloaded [via the global function] with the file name set to the data controls DatabaseName property).
Again, may not be the most effective way to do it, but it works. Now, since apparently databases within VB save on their own, I don't have to worry about a user clicking a "Save" button, but I do need the ability to let the user create a new database. This is where I'm hitting a snag, and none of my books seem to help...unless I'm really dense and just missing it.