connecting to ms access with vb6

[Dököll]

Very strange, guys, I agree Yoda. It could be your version of access. I did not know one could have such a problem. Would you be able to upgrade?

[Tig201]

I'm using WinXP SP2 and Access 97. I'm in a work environment and have no controll over upgrades.

[Dököll]

I'm using WinXP SP2 and Access 97. I'm in a work environment and have no controll over upgrades.

I see...

Are you allowed to take work at home?

I did find that if the project was included ob the drive your databse is located, it worked flawlessly. Have you tried working locally to C:

[Dököll]

the database is trial database and the table is trial data

the fields are contact id,first name, second name,city,regio n,country,mobil e phone

initially the programme was unable to see the table, so i converted it to access 97, it saw the table but couldnt display.

sorry but i cant find where to set the splash screen to startup,

so i made a small programme, using splash screen and the login screen and also converted it into an exe file, so i cld run it as standalone, but the main programme showed up, without the splash screen or the login form.

why is dat?

Hello Aysha!

You would need to set up your splash screen as your Start up form. It sounds like you created your main form first then your splash. If you want,

(1) make a copy of the whole project
(2) run it to make sure the copy works like the original
(3) Delete the splash screen

I am suggesting to avoid confusion. Besides, the most important part of your project should be to have interaction with your Access back-end.

Would you mind going this route?

[Dököll]

Hello Aysha!

You would need to set up your splash screen as your Start up form. It sounds like you created your main form first then your splash. If you want,

(1) make a copy of the whole project
(2) run it to make sure the copy works like the original
(3) Delete the splash screen

I am suggesting to avoid confusion. Besides, the most important part of your project should be to have interaction with your Access back-end.

Would you mind going this route?

Failed to mention you'll need to get rid of the login form as well, just to keep it simple so all else work. I can help you through what's already there if you have the patience :-)

[Dököll]

I am trying to create a similar program and have followed the info in this thread. I think I’m having the same problem as Yoda. When I try to dim myDb as Database, VB6 reports a compile error “User Defined type not defined” I was thinking that a reference needs to be added to the project but don’t know where to begin to look for it. was hoping maybe you could enlighten me and maybe solve Yoda and my problem.

Greetings, Tig201!

Your version of Access should work just fine. Can you tell us a little more? I must say after adding Yoda's code to a form he sent me via email, I did have the same error. I reverted to my code therefore, and all worked. Let's search here for this type of error, see what pops up. Would you mind searching through the Access forum on "User-Defined..."?

[Tig201]

I got it to accept the Database Type by going to Project/References… and checking “Microsoft DAO 3.51 Object Library”
however I can’t seem to get the recordset defined. I am getting a “Type mismatch” w/ “Set myRs = myDb.OpenRecord set(sqlTxt)” I have set sqlTxt to several different SQL Statements and also to the table name in access and I can’t seem to get past this. I hope the references helps Yoda and I would appreciate any help you could give me. Thanks

[Tig201]

I found a solution to the type mismatch error thought I should include it here basically Dim var as DAO.Database, var as DAO.Recordset so Access and/or VB don’t try to use ADO.
www.thescripts. com/forum/thread211605.ht ml

[Dököll]

I found a solution to the type mismatch error thought I should include it here basically Dim var as DAO.Database, var as DAO.Recordset so Access and/or VB don’t try to use ADO.
www.thescripts. com/forum/thread211605.ht ml

Nice of you to post your findings? You're alright then! Anymore problems?

[DUNXALEARE]

Nice of you to post your findings? You're alright then! Anymore problems?

hey ! I'm following your coding splash and login works but "about" failed
and i've got hte same error like Yoda.
did anyone find a solution in "USer Define-Compile User Dfined-Type- Error" :)

DUNXALEARE

[Tig201]

hey ! I'm following your coding splash and login works but "about" failed
and i've got hte same error like Yoda.
did anyone find a solution in "USer Define-Compile User Dfined-Type- Error" :)

DUNXALEARE

Sorry I didn't give the link for the references. This solved the "User defined type not defined" error.

I got it to accept the Database Type by going to Project/References… and checking “Microsoft DAO 3.51 Object Library”

I got the info from www.thescripts. com/forum/thread211599.ht ml

[Tig201]

Nice of you to post your findings? You're alright then! Anymore problems?

I got the VB to work I don't suppose there are any section on this forum for AutoLisp or VisualLisp.

[Dököll]

hey ! I'm following your coding splash and login works but "about" failed
and i've got hte same error like Yoda.
did anyone find a solution in "USer Define-Compile User Dfined-Type- Error" :)

DUNXALEARE

Groovy, good going!

About is anything you want it to be, name of my form in this case. You would get to it if password is correct....

[Dököll]

I got the VB to work I don't suppose there are any section on this forum for AutoLisp or VisualLisp.

Fantastic, glad you're ok. Have you searched re: AutoLisp or VisualLisp yet?

[lavadrinker]

hey there,

i connected Access and VB6, and I keep coming up with the error message:
"Couldn't find installable ISAM"
What can I do about this?
I have tried everything, except uninstalling and re-installing it all.
I made sure the dll connections were fine, it just keep appearing, can anybody help me?