467,080 Members | 899 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,080 developers. It's quick & easy.

Create Access 2003 db

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

Jan 18 '07 #1
  • viewed: 1979
Share:
3 Replies
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

Jan 18 '07 #2

"'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
Jan 19 '07 #3
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

Jan 19 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Susan Bricker | last post: by
9 posts views Thread by Marc Miller | last post: by
1 post views Thread by Jack G | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.