Create Access 2003 db

[banba_ca]

When I create a new db from the main Access window or thru Vb (set
newdb = ...) I always end up with Access 2000 file format. I would like
to get 2002 - 2003 file format. The reason is that when I try to link
from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it
can't find the table in the target (2000) database.
And no, I can't convert on the fly.

Any suggestoins would be appreciated.
....Banba

['69 Camaro]

Hi.

When I create a new db from the main Access window or thru Vb (set
newdb = ...) I always end up with Access 2000 file format. I would like
to get 2002 - 2003 file format.

Select the Tools -Options... menu, then select the "Advanced" tab. Change
the "Default File Format" from Access 2000 to Access 2002-2003 in the combo
box on the top right of the dialog window. Select the "OK" button to save
your change. New databases will be in the Access 2002-2003 database format.

The reason is that when I try to link
from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it
can't find the table in the target (2000) database.

Something else is causing the problem, because Jet 4.0 (Access 2003) can
read Jet 4.0 (Access 2000 database format) files.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ba******@yahoo.comwrote in message
news:11*********************@11g2000cwr.googlegrou ps.com...

When I create a new db from the main Access window or thru Vb (set
newdb = ...) I always end up with Access 2000 file format. I would like
to get 2002 - 2003 file format. The reason is that when I try to link
from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it
can't find the table in the target (2000) database.
And no, I can't convert on the fly.

Any suggestoins would be appreciated.
...Banba

[Arno R]

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMschreef in bericht news:UO******************************@adelphia.com ...

<snipped>

>The reason is that when I try to link
from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it
can't find the table in the target (2000) database.

Something else is causing the problem, because Jet 4.0 (Access 2003) can
read Jet 4.0 (Access 2000 database format) files.

HTH.
Gunny

Not only Jet 4.0 Jet can also read and write earlier versions.
Access 2003 (and all earlier versions) can even link to Access 2.0 databases.

IME *every* Access version can link to *any other* earlier version.
(Don't know about Access 2007)

Arno R

[Baz]

Tools menu-->Options-->Advanced tab-->Default File Format

<ba******@yahoo.comwrote in message
news:11*********************@11g2000cwr.googlegrou ps.com...

When I create a new db from the main Access window or thru Vb (set
newdb = ...) I always end up with Access 2000 file format. I would like
to get 2002 - 2003 file format. The reason is that when I try to link
from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it
can't find the table in the target (2000) database.
And no, I can't convert on the fly.

Any suggestoins would be appreciated.
...Banba