Database error

[JonathonC]

When I goto set the RecordSource property of a data object, I get the error "Unrecognized Database format". I'm using Access 2000 and VB6. Why is my Database unrecognized?

Thanks,
Jonathon.
Computer problems? Have you checked the loose nut in front of the keyboard yet?

 

[ggreg]

Why is my Database unrecognized,

What's .Provider statement are you using
and what does your connection String look like?


RecordSource property of a data object
Unrecognized Database format....are you matching correct
data types........a Date Field, with date data type?

 

[JonathonC]

What is .Provider?
Here are what some of my properties are set to:

Connect = Access

DataBaseName = C:\Documents and Settings\Jonathon\My Documents\My Visual Basic projects\NetMessage\nmdata.mdb

BOF & EOF = 0 - Move first

Exlusive = False

RecordsetType = 0 - Table

RecordSource = CAN'T FILL BECAUSE OF ERROR

Jonathon. Computer problems? Have you checked the loose nut in front of the keyboard yet?

 

[ggreg]

If you right click on your adodc...Then go to properties..
then click build....you will see a provider tab....
you then need to make sure you have one of the
Microsoft Jet click I have 3.51 and 4 right there
could be one of your problems.

 

[ggreg]

By running a test I think you need the jet 4.0

 

[ggreg]

Then its my guess that you need to set RecordSource property to 2 adCmdTable.

 

[JonathonC]

I'm using the Data object not the adodc one!

Jonathon. Computer problems? Have you checked the loose nut in front of the keyboard yet?

 

[ggreg]

Are you doing something like this?
dim pconnmdata As New ADODB.Connection

pconnmdata.Mode = adModeShareDenyNone

pconnmdata.CusorLocation = adUseClient
pconnmdata.Provider = "Microsoft.Jet.OLEDB.4.0"
pconnmdata.ConnectionString = "Persist Security Info=False;
" & "Data Source=
C:\Documents and Settings\Jonathon\My Documents\My Visual Basic projects\NetMessage\nmdata.mdb"

pconnmdata.Open

 

[JonathonC]

I don't think you read my last post, i'm not using the ado object/control. I'm using the Data one. In the RecordSource property i'm supposed to specify the table I want to access from the database but I get an error because vb6 can't recognise my Database for some reason.

Jonathon. Computer problems? Have you checked the loose nut in front of the keyboard yet?

 

[ggreg]

Ok I with you now

Connect = Access


mine acturally has....

Connect = Access 2000;

 

[ggreg]

On my connect---I can get a down arrow and make it
Access 2000;

Can you not do that?

 

[JonathonC]

Nope, I only have one called "Access"

Jonathon. Computer problems? Have you checked the loose nut in front of the keyboard yet?