General question on updating databases

[CharlotteR]

i am creating a vb.net project that accesses a database from MS Access. once i have finished it, will it be possible to then add/remove/manipulate the database from within the VB project? i want to be able to do more than just view the database through visual basic, and its not feasible to update the database in Access and then keep updating the connection & the database.

is there any way of doing this, or should i simply do the entire database in just VB.Net or just Access?

is it actually possible to create a database in VB btw? or does it have to connect to one anyway?

sorry for so many stupid questions - i first used VB.Net 3 days ago!

thanks for any help,
CharlotteR

 

[AndyWatt]

Don't know about VB.NET, but to create a database in VB6:

Dim cat As ADOX.Catalog

Set cat = New ADOX.Catalog
cat.Create(DatabaseName)

It's as easy as that!

Regards,

Andy

"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux

 

[zemp]

Through VB, and I assume VB.Net also, You can do almost anything to a database. Create, compact, add tqables and fields, users and permissions, etc., etc.. It is more a question of knowing which is the best tool and knowing how to use it.

Usually there are three tool involved. VB, a database (database engine) and a set of connection objects (such as ADO, DAO or ADOX). VB.Net may have it's own set of connection objects available as well.

To manipulate the database you need to learn how to use these connection objects.

Thanks and Good Luck!

zemp