Data Access Forms

[MurfOS]

"Provider cannot be found. It may not be properly installed."

This is the error I get when I try to select a database as a data source in VB6. I need to access databases via forms and I don't know how to do it and the wizard ain't working.

Can anyone help me I really need to be able to do this.

Any info greatly appreciated.

Murf.

 

[Transcend]

Hi there

are you trying to select Access 2000 by any chance as the provider?

Trancend

 

[CassandraR]

Hi Murf:

You will need to be a bit more specific.

Which technology are you using: DAO, ADO, ADODC?

Which type of database are you accessing: Access, SQL Server, Oracle?

Cassie

 

[Transcend]

Check out these threads, you may not have the correct mdac installed or you may not be using the right jet reference.

thread222-494694
thread222-306925


Transcend

 

[MurfOS]

I am trying to access Access 2002 (tried exporting as 97 and acessing that) using VB6. I'm getting nowhere and don't know what to do. I am a major noob when it comes to this.

 

[johnwm]

How are you trying to access the database?

1. Is it from VB6 or VBA in Access?

2. If VB6 (which is what this forum covers) are you using SP5 - if not download that first from:

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/dnldoverview.aspx

3. Are you using DAO or ADO for data access? If DAO get the latest update to Jet engine from MS Download site. If ADO get MDAC 2.7 The ADODC issue is covered by your SP5 update

I suggest you do the appropriate updates, try again and then come back if necessary, posting the snippet of code that seems to be failing.

Check out faq222-2244 to get the best Answers


________________________________________________________________
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.'

 

[Vizion]

You might want to check if you're using VB6 to access your Access database:

1) Your type of your database, I recommend access(connect properties)
2) If you use DAO as your connection, make sure you use Reference, I usually use Jet for my access.
3) Also check your recordset type, use appropriate one.

Ignore my suggestion if above reply solved your problem.

Good luck.