Visual Basic from Access Database 2

[RossoR]

Apologies if this is posted in the wrong forum, but here it goes:

I have created an Access database in work with 9 searchable fields and approx 2000 entries. Unfortunatly not all team members have Access so I have tried to creat a stand alone database. I have failed in this, and have resorted to trying VB5.

Is there an easy way to import this Access database int VB? If so, I can import it then save the program as an executable for the team to use.

Any comments Welcome =)

RossoR

 

[woyler]

You can use VB as an interface to the ACCESS database, but it does not store the data. You can put the database you have on a public share on your network and use the VB interface to talk to it. That will only require that the users have the interface app and not ACCESS

 

[RossoR]

Thanks for the quick reply!

I suspected that would be the case, but was not sure how much work would be dublicated by creating a new front face in VB.

Is there a way I can import the form from Access?

 

[sunaj]

Hi,

You can use ADO (or DAO) to access your Access database from VB. See FAQ.
When you've made a project in VB that manipulates your Access database you can distribute it through a setup program. A setup program is easy to make from a VB project using e.g. tha Package and deployment Wizard that comes with Visual studio.

Sunaj

 

[woyler]

There is no way to simply convert or port the ACCESS forms into VB, but the VB development enviroment would seem some what familiar to you if you have been developing ACCESS forms. It might be of interest to you to check out the VB Application Wizard. This is an option available to you when you start VB.