To use or not use the data connection wizard?

[hwalisz]

I'm totally new to VB. I'm creating a program that, when distributed, will connect to an SQL database. Each client who has the program will have their data in a differently named database. Doesn't this exclude the possibility of using the data connection wizard?

Thank you - I'm trying to avoid heading in the wrong direction right from the start!

Al

 

[cjard]

nope, it doesnt.. though why youd want that, i have no idea! if the database is on the client machine, then name them all the same. if the database is a central network server, then why not create multiple databases within the one server?

client1.table1
client2.table1
client3.table1

...