Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2006

Tip: Looking for answers? Try searching our database.

2003 compatibilty

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy - 20 Sep 2006 22:51 GMT
I have an application which is complied at Ver 9 (Access 2000) as an mde
database. I have another application also complied at Ver 9 (Access 2000) as
a mdb database.

If I open the second 2K mdb database using Access 2003 it opens fine but
when this 2K database tries to open the first 2K mde database from within a
vba module using the OpenDatabase statement it fails with error 3041 'Cannot
open a database creates with a previous version of your application'.

Any ideas?
John Spencer - 21 Sep 2006 13:36 GMT
I think you are out of luck.  If you want to open an mde you have to have
the same version that created the mde.

So you can get the mdb for the first database and convert it to 2003 format
and then use 2003 to make an mde.
OR
Get the mdb for the first database and use that with 2003
OR
Use Access 2000.

>I have an application which is complied at Ver 9 (Access 2000) as an mde
> database. I have another application also complied at Ver 9 (Access 2000)
[quoted text clipped - 9 lines]
>
> Any ideas?
John Spencer - 21 Sep 2006 16:46 GMT
Looks as if I might be wrong on this.  Please see Granny Spitz's response.
>I think you are out of luck.  If you want to open an mde you have to have
>the same version that created the mde.
[quoted text clipped - 19 lines]
>>
>> Any ideas?
Granny Spitz - 21 Sep 2006 15:26 GMT
> If I open the second 2K mdb database using Access 2003 it opens fine but
> when this 2K database tries to open the first 2K mde database from within a
> vba module using the OpenDatabase statement it fails with error 3041 'Cannot
> open a database creates with a previous version of your application'.

Something smells fishy in the state of Denmark.  Access 2003 can open mdb and
mde files in Access 2000, 2002, and 2003 database file formats.  It can't
open Access 95 and 97 mdb files unless it first converts them to Jet 4.0
format or *enables* them.  Access 2003 can't open Access 95 and 97 mde files
because mde's can't be converted or enabled.

Double-check that your mde file isn't an Access 97 mde.  If it truly is an
Access 2000 mde, then please post your VBA code that opens the Access 2000
mde (dim statements, too).
Andy - 23 Sep 2006 01:35 GMT
Thanks Granny - Yep truly trying to open 2k mde.

I'll post code on Monday

Andy.

> > If I open the second 2K mdb database using Access 2003 it opens fine but
> > when this 2K database tries to open the first 2K mde database from within a
[quoted text clipped - 10 lines]
> Access 2000 mde, then please post your VBA code that opens the Access 2000
> mde (dim statements, too).
Andy - 26 Sep 2006 17:56 GMT
As promised :-

   Dim dbsFE As DAO.Database
   Dim tdfLinked As DAO.TableDef
   Dim dbsAdmin As DAO.Database
   Dim rs1 As DAO.Recordset
   Dim rs2 As DAO.Recordset
   Dim SQLcmd As String
   Dim TML As String
   Dim FE As String
   Dim BE As String
   Dim tblName As String
   Dim AdminLoc As Variant
   Dim cc As Integer
   Dim rc As Integer
   Dim FEName As String
   Dim FENameL As String
   Dim BESearch As String
   Dim BESearch1 As String
   Dim FELen As Integer
   Dim FELen2 As Integer
   Dim BEN As Variant
   Dim Ver As Variant
   Dim Shellstr As String
   Dim SDbl As Double
   Dim DBVer As String
   Dim DL As String
   Dim DF As String
   
   On Error GoTo Err_Command9_Click
   
   DL = Me.cboDL.Value
   DF = "AL." & Format(CDate(Date), "yymmdd") & "." & Format(CDate(Time),
"hhmmss")
   
   FE = DL & ":\" & DF & "\AL" & Ver & ".mde"
   
   MsgBox "Now refreshing links to your Back End database ..."
   
   DoCmd.Hourglass True
 
   ' Open the FE database in order to link tables
   
       Set dbsFE = OpenDatabase(FE, True)

Fails at Open statement (the databse referred to by variable FE is a 2K
database)

> Thanks Granny - Yep truly trying to open 2k mde.
>
[quoted text clipped - 16 lines]
> > Access 2000 mde, then please post your VBA code that opens the Access 2000
> > mde (dim statements, too).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.