VB and Access (VB6)

Topic

New Reply

New to Visual Basic and I am not clear on VB and Access.

Is the ability to create .mdb files shipped with VB or does the end-user have to have Access on their system?

Reply | Quote

Replies

You can use DAO or ADOX to create a database. See Creating an Access Database for ADOX; you need to set a reference to the “Microsoft ADO Ext. 2.7 for DDL and Security” library (msadox.dll).

Reply | Quote

VB 6 includes the Jet database engine. If you have VB6 professional, you can create and distribute an application that includes a Jet mdb file as a data store.

Reply | Quote

Thanks Hans and Charlotte for the info.

I am familiar with Access 97 security. In VB6, if by including a Jet mdb file as a data store, will security work in the VB app much as it does in Access? If not what options are available to secure a VB app?

Thanks

Reply | Quote

Whether you use Access itself or VB6, you are actually using the Jet database engine to retrieve and store data in the database. Security is an integral part of the Jet engine; if you apply user-level security (through a secured workgroup information file) to the database, this will be in force whatever method you use to connect to the database.

Reply | Quote

Whether you use Access itself or VB6, you are actually using the Jet database engine to retrieve and store data in the database. Security is an integral part of the Jet engine; if you apply user-level security (through a secured workgroup information file) to the database, this will be in force whatever method you use to connect to the database.

Reply | Quote

Thanks Hans and Charlotte for the info.

I am familiar with Access 97 security. In VB6, if by including a Jet mdb file as a data store, will security work in the VB app much as it does in Access? If not what options are available to secure a VB app?

Thanks

Reply | Quote

VB 6 includes the Jet database engine. If you have VB6 professional, you can create and distribute an application that includes a Jet mdb file as a data store.

Reply | Quote