By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,143 Members | 1,854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,143 IT Pros & Developers. It's quick & easy.

Create Access 2003 db

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a

"'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

P: n/a
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.