Re: RE: ADO:VB6 Object not opened error. Guidance please?


<adalton@xxxxxxxxxxx> wrote in message news:ebg7f802dgc@xxxxxxxxxxxxxxxxxxxx

<snipped>

******** Answers ***********
Thanks for the quick response....

I am using most recent Jet.
Access '97 .mdb
MS access driver (PROVIDER=Microsoft.Jet.OLEDB.3.51)

ALSO - I can not get access 2000 (or newer) created databases to work at
all.....That's why I
am using the Access '97.

Tx,
Arcadia


There shouldn't be any problems... What errors are you getting?

This article is required reading when playing with MSAccess.
http://support.microsoft.com/kb/303528/

hth
-ralph


.

Relevant Pages

  • Re: Official Status of SQLServer 2005 ADP
    ... "remains with Jet and linked tables or remains with Jet ... but go with SQL pass-through queries and unbound forms" ... RecordSource is a query with a where clause that limits the number of rows ... > queries under MDB was bad and worst than the one offered by ADP while you ...
    (microsoft.public.access.adp.sqlserver)
  • Re: get external data odbc limitation?
    ... Jet database will show only 64K of characters in returning a list ... I'm a college institutional researcher and also must contend with ... of PeopleSoft's tables may be needed for research purposes, ... it creates a list of an Access databases tables (including linked ...
    (microsoft.public.access.externaldata)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)
  • Re: ADP or MDB - which is a better front end for SQL Server?
    ... the CLR into the JET/MDB couple. ... remove your MDB files on your home computer but if the JET/MDB remains ... full integration of the CLR and of the .NET Framework - including the ... > relational databases, MS cannot get rid of it for a while yet, but I have ...
    (microsoft.public.access.adp.sqlserver)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is free; but still crap-- much like Excel. ... MSDE/ADP is a free stack for all practical purposes. ... Steve Ballmer says that 50% of the seats in the WORLD are SQL Server. ... And the point of the matter--- IT SHOULDN'T OWN DATABASES. ...
    (microsoft.public.excel)