Re: What database shall I use???

From: Glen A Stromquist <gstromquist_at_nospamyahoo.com>
Date: Wed, 06 Mar 2002 18:45:28 GMT
Message-ID: <ctth8.80610$Ym3.13883705@news0.telusplanet.net>

> This is just a guess from somebody with extremely limited experience,
> but could the method of accessing (no pun intended...) the Oracle DB
> be a problem?
>
> Sounds like you're going after it with DAO/Jet/ODBC.
>
> The successful Access-front-end/Client-Server back end apps I'm
> familiar with (but haven't written) all use ADO hooked in through the
> DB vendor's "Data Provider". Given that scenario, it doesn't seem
> like it would be any diff between Access and VB.
> -----------------------
> Pete Cresswell

You may be right Pete, I dont think an Access "front end" should really be any different than one written in pure VB, but thats just been my experience. I administer about 6 oracle databases and 3 sql server. The one's with VB or Powerbuilder front ends are virtually trouble free, I NEVER have any connectivity or data retrieval problems with them. The Access front ends are a constant source of headaches, new one's pop up weekly it seems, and we are using the jet/odbc route, which could very well be the problem. I have *really* learned to hate the very mention of ODBC lately (although our VB app uses them trouble free)

cheers! Received on Wed Mar 06 2002 - 12:45:28 CST