using Access 2000 database in VB

[Zbob]

I am using Macola flexibility, which has a VB interace for customization.

We have many subsystems built in Access 2000, I want to integrate some of our subsystems into macola using VB.

Example

On a form in Macola for Posting invoices, I want to add a button to update our bin database (access 2000). I have created to command button, I tried opening the short cut to the form using the shell command unsuccessfully.

Is there a way to connect to Access2000 and call existing forms and queries?

Thanks

 

[percramer]

You can use your queries. Use the ADO connection method and then there are stored queries. You can't use your forms, i am sorry.

 

[Zbob]

I am having trouble connecting using ADO.

I am using the following code.

Dim BinDB As New ADODB.Connection

BindDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0" _
& " Data Source=M:\ITI\picking ticket RC2.mdb"
BinDB.open

What am I doing wrong?

 

[johnwm]

For a whole lot of connection strings for all purposes try this:

http://www.able-consulting.com/ADO_Conn.htm

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'