Exporting report out in Access 2003 format from Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to produce Access 2000 mdb file for end users from Access 2007 front end
application using SQL server.

I have upgraded my application to Access 2007 from Access 2003.

One functionality of the application is to provide report data in access
format. We generate these mdb files using docmd.transferdatabase in vba.

As end users have not yet upgraded to offcie 2007 and since our upgrade our
end users cannot open these mdb files.

I feel that the file extension (which is still .mdb) is misleading and
that the output file being generated is Access 2007 version and not Access
2000 - 2003 version.

To resolve this I have changed the default file format for creating
databases to Access 2002 - 2003, iIn Access options, in popular section. This
has not helped me.

I tried to change docmd.transferdatabase option for output file format to
"Jet 3.5" from "Microsoft Access". This does not work as Jet 3.5 is not
available on machine.

Please help with suggestions for possible solution.
 
Hi Pete,

I haven't tried this with Access 2007, but in earlier versions I'd do
something like this (air code):

Dim dbD as DAO.Database
Dim FileSpec as String

FileSpec = "D:\Folder\new database.mdb"

'Create an empty mdb file in Jet 3.x format
Set dbD = CreateDatabase( FileSpec, dbLangGeneral, dbVersion30)
dbD.Close
Set dbD = Nothing

'Export the report to that mdb file
DoCmd.TransferDatabase acExport, , FileSpec, acReport, "My Report"

John Nurick
Microsoft Access MVP
 
Back
Top