DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

VB6 - Access Database

•

Join Date: Nov 2009

Posts: 3

Reputation: Jaisonkv is an unknown quantity at this point

Solved Threads: 0

Jaisonkv

Offline

Newbie Poster

VB6 - Access Database

23 Days Ago

Hi.... I am a student.

When i tried to connect VB with Access, it is giving me this message "Run-time error 13, Type Mismatch" Below is the code

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
Dim DBase As Database
Dim RBase As Recordset
 
Set DBase = OpenDatabase("DB Name")
Set RBase = DBase.OpenRecordset("Table name")
Dim DBase As Database
Dim RBase As Recordset

Set DBase = OpenDatabase("DB Name")
Set RBase = DBase.OpenRecordset("Table name")

The funniest thing is, this same code works on another project on the same computer.

Somebody help meeeeeeeeeeeee.

Last edited by peter_budo; 23 Days Ago at 8:42 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

•

Join Date: Mar 2009

Posts: 810

Reputation: vb5prgrmr will become famous soon enough

Solved Threads: 147

vb5prgrmr

Offline

Practically a Posting Shark

22 Days Ago

What is the version of the database you are having problems with? You may have to convert it to a previous version...

Another thought. Did you add the reference to the data access object?

Good Luck

If anyone has helped you solve your problem, please mark your thread as solved.

Thanks

•

Join Date: Jul 2008

Posts: 471

Reputation: abu taher is an unknown quantity at this point

Solved Threads: 24

abu taher

Offline

Posting Pro in Training

21 Days Ago

if you want to use upper version of office then you need service pack 6 of vb6.

I like sword. Attack or Defense.

•

Join Date: Nov 2009

Posts: 3

Reputation: Jaisonkv is an unknown quantity at this point

Solved Threads: 0

Jaisonkv

Offline

Newbie Poster

16 Days Ago

•

Originally Posted by vb5prgrmr

What is the version of the database you are having problems with? You may have to convert it to a previous version...

Another thought. Did you add the reference to the data access object?

Good Luck

Yes I add everything

•

Join Date: Nov 2009

Posts: 3

Reputation: Jaisonkv is an unknown quantity at this point

Solved Threads: 0

Jaisonkv

Offline

Newbie Poster

16 Days Ago

•

Originally Posted by abu taher

if you want to use upper version of office then you need service pack 6 of vb6.

How can we get this service pack 6?

•

Join Date: Jul 2008

Posts: 471

Reputation: abu taher is an unknown quantity at this point

Solved Threads: 24

abu taher

Offline

Posting Pro in Training

16 Days Ago

here and here and here

I like sword. Attack or Defense.

•

Join Date: Nov 2009

Posts: 14

Reputation: akhileshbc is an unknown quantity at this point

Solved Threads: 4

akhileshbc akhileshbc is offline

Offline

Newbie Poster

16 Days Ago

•

Dim DBase As Database
Dim RBase As Recordset

Set DBase = OpenDatabase("DB Name")
Set RBase = DBase.OpenRecordset("Table name")

Try to use database name and table names without spaces. eg: DBName , TableName...

Which line shows the error ?

Make sure that the data saved to the database is of the same datatype of those in the Fields...

eg: "abcd"(string) to IntegerField is not applicable...