I'm testing my Access 2002 application in Access 2010 without converting
either the front end or back end db's.
When the app tries to append a new table using Tabledefs.Append ..., the
following error is generated.
"Error 3845 (Error: Microsoft Access does not support linking to an Access
database saved in a format that is later than the current database format."
I've opened the source db and saved it as Access 2002-2003 mdb, and the same
for the front end just to be sure.

--
Bob Darlington
Brisbane

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote

Futher to my original post.
The db I was connecting to was created from within Access 2010 as an mdb
using:
DBEngine.CreateDatabase(strPathTo, dbLangGeneral, dbVersion40).
That created the file OK
And I can link to that file using the Access UI.
But when I use VBA to create the link, I get the error mentioned in my
original post.
--
Bob Darlington
Brisbane

On Feb 1, 2:28*am, "Bob Darlington" <b... (AT) notheredpcman (DOT) com.au> wrote:
I have had exactly this problem using a temp database created by
code. Your problem is the dbVersion40 in your code. This makes the
new database in the latest format - which A2002/XP cannot read.
Change the dbVersion to an earlier one - I can't remember the number
reqd. F1 in the dbVersion to see the Help.

JB.

Thanks JB.
I think that dbVersion40 covers Access 2002.
But I'd only added the constant to one instance of the CreateDatabase call.
I needed to apply it elsewhere as well.
Anyway, it all seems to work OK now.

--
Bob Darlington
Brisbane
"jbguernsey" <jeff (AT) angelsystems (DOT) co.uk> wrote

On Feb 1, 2:28 am, "Bob Darlington" <b... (AT) notheredpcman (DOT) com.au> wrote:
I have had exactly this problem using a temp database created by
code. Your problem is the dbVersion40 in your code. This makes the
new database in the latest format - which A2002/XP cannot read.
Change the dbVersion to an earlier one - I can't remember the number
reqd. F1 in the dbVersion to see the Help.

JB.