Opening DB

web38207.mail.mud.yahoo.com" type="cite">If anybody out there needs VB6 Professtional Edition, I have it for sale for $50.00 dollars.

Donald Gaither msn.com"><donarcomsn.com>; wrote:

Steve,

I have tried the suggested fixes, but without success. Even with the new
code I get the same error message ("Unrecognized format C:Budget
MasterGeneral Ledger.mdb"). I'm using Access 2003. When I look at the
Convert Format screen from Database utilities, the "2003" version is
grayed out - I assume this means my current format is compatible with Access
2002-2003. I have installed SP2 and SP6. I hope you may have further
suggestions.

Don Gaither

>From: "Steve Manser" < smanser%40twcny.rr.com">smansertwcny.rr.com>
&gt;Reply-To: helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com
&gt;To: < helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com>
>Subject: RE: [helpwithvb] Opening DB
>Date: Sun, 19 Nov 2006 10:24:07 -0500
>;
>
&gt;Good Morning Don,
>
>Two things:
&gt;
>1) When super-gluing strings together
> use the ampersand character: &
>; and not the math plus sign.
>;
> 2) Your project needs to have
> a reference set to DAO or ADO.
>
>What flavor of MS Access are you using ?
>
&gt;What is the latest Service Pack that you
>have installed / applied for VB-6 ?
>
&gt;This error message was quite common
&gt;when people had not applied SP4 or SP5,
>and they were trying to use Access 2000.
>;
>Forget which SP did the trick
>;to provide the Jet 4.0 engine.
&gt;
>Also, when packaging everything up,
>after MDAC 2.5 the Jet Engine became
&gt;a separate entity that had to be
>included in the shipping box.
>
>You might want to consider changing your code:
>;
>Dim db As DAO.Database
>Dim Tmp As String
&gt;
>Tmp = App.Path & "General Ledger.mdb"
>
&gt;Tmp = Replace(Tmp, "\", "")
>
>set db = Opendatabase( Tmp )
>
&gt;
>Every once-and-awhile Mr. App.Path decides
&gt;to attend the party in tails, so we need
>to always double check for a double path-slash.
>
&gt;All The Best,
>;Steve
>;
>10:15 AM EST Sunday, November 19, 2006
>.
>
&gt;
>From: helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com
&gt;[mailto: helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com] On Behalf Of Donald Gaither
&gt;Sent: Saturday, November 18, 2006 4:37 PM
>To: helpwithVB%40yahoogroups.com">helpwithVByahoogroups.com
&gt;Subject: [helpwithvb] Opening DB
>
>Help Group,
&gt;
>You will recall the problem I wrote about yesterday dealing with issues
>apparently stemming from the use of data controls. I'm now attempting to
>remove the data controls, but am having some difficulty described as
>follows:
>;
>"Dim db as Database
>
>set db = Opendatabase(App.Path + "General Ledger.mdb"
>
&gt;When my program reads the second line I get an error message as follows:
>"Unrecognized database format "C:Budget MasterGeneral Ledger.mdb". When I
>open the database in Access it appears to be OK. Any suggerstions or help?
>;
>Don Gaither
&gt;_.

><< winmail.dat >>

---

Sponsored Link

$200,000 mortgage for $660/mo - 30/15 yr fixed, reduce debt, home equity - Click now for info

exchdal06.Parsons.com" type="cite">

Hi Andreas:

 

Do you (or does anyone) know if VB.NET Express '05 will live nicely on a machine with VS.NET '03 on it?

 

-Bruce

---

From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On Behalf Of Andreas Renberg
Sent: Wednesday, November 22, 2006 5:44 PM
To: helpwithvb@yahoogroups.com
Subject: Re: [helpwithvb] Opening DB

Even better than pricey VB6, VB 2005 Express Edition includes many tools to make accessing SQL databases easier.
That is the version I use, and it is free from Microsoft at http://msdn.microsoft.com/vstudio/express/vb/.

Instead of having to open access every time you want to change databases, this newer version already comes with a similar thing in it.
I believe that you also have to install some extension which is on the same page or a similar one to use the database interface, but it turns out pretty good.

Also, for those who use C#, there is a newer version to that and also some other languages.

Andreas...

.