Re: VB6 Questions

From: Krishna Prabhu (KrishnaPrabhu_at_discussions.microsoft.com)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 16:36:03 -0700

Thank you for your valuable input.

Especially inputbox function was really of help.

about the main issue...

I have downloaded MDAC 4.0 and have installed it. I also have SP6 for VStudio6.0

I also have referred to the KB articles. Have tried all that was mentioned in newsgroups earlier. But am still not able to get it

I also have confirmed that MDAC is installed successfuly. However I am not sure if VB is still using the older copy of MDAC. Is there a way how I know what version of MDAC is being called by VB6.0?

"Val Mazur" wrote:

> Hi,
>
> 1. It should work fine. What is your connection string? Are you using Jet
> 3.51 or Jet 4.0? If you need to connect to Access 200 or newer, then you
> have to use Jet 4.0 and it does not come as a part of Visual Studio or MDAC
> anymore. You would need to install it separately. You could download it from
> next link
>
> http://www.microsoft.com/downloads/results.aspx?productID=&freetext=jet+4+sp8&DisplayLang=en
>
> 2. As I remember there is an Input function, which asks for the value, but
> my personal opinion is to create some form. In this case you have more
> control and could validate the input value, before you close this form. It
> is extra coding, but it worth it
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Krishna Prabhu" <Krishna Prabhu@discussions.microsoft.com> wrote in message
> news:9AA97984-C6E6-4412-89BC-47C96882E372@microsoft.com...
> > Hi,
> >
> > I have 2 questions while I am writing a program in VB6.0
> >
> > Question 1.
> > -------------
> > I have VB6 and Access 2002(XP). When I try to access MS Access 2002
> > database from VB code I get an error message that says Run-time error 3343
> > Unrecognized Database Format. I downloaded the latest JET engine. I also
> > downloaded the latest Service Pack for VStudio. Nothing changed. However,
> > I opened the database and saved it in Access 97 format and that works.
> > Is there a way to run the application, while I maintain the DB in Access
> > 2002 format?
> >
> > Question 2.
> > -------------
> > I want to ask user for an input(eg: Start Date for a report). I want to
> > pop this question to the user as soon as the user clicks on the report
> > button. Is there a way to avoid a form and ask the question using any of
> > the built-in feature? In other words, instead of using a form just for
> > this question, is there a way how I can collect one word answer using a
> > feature just like MSGBOX function.
> >
> > Thanks and advance.
> >
> > Regards,
> > Krishna Prabhu
> >
> > Another question
> >
> >
>
>
>

Quantcast