mdb save problems with Access 2010

[pacnwWill]

Hi all, Access rookie seeking help here. We've got both Access 2007 and 2010 running as front ends for our SQL db on several computers at work. I've got a small Autoexec VBA program to automatically update the Access database that is loaded on everyone's desktop:

 
'>>Here's the declaration:
 
Option Compare Database
Option Explicit
Declare Function apiCopyFile Lib "kernel32" Alias "CopyFileA" _
(ByVal lpExistingFileName As String, _
ByVal lpNewFileName As String, _
ByVal bFailIfExists As Long) As Long
Sub CopyFile(SourceFile As String, DestFile As String)
Dim Result As Long
   If Dir(SourceFile) = "" Then
      MsgBox Chr(34) & SourceFile & Chr(34) & _
         " is not valid file name."
   Else
      Result = apiCopyFile(SourceFile, DestFile, False)
   End If
End Sub

 
'>>Here's the autoexec fxn:
 
Function DatabaseLoad()
    
On Error Resume Next
    
If DLookup("VersionID", "tblVersion") <> DLookup("VersionID", "tblVersionMasterELISA Log") And Err = 0 Then
 
MsgBox "Your version of " & CurrentProject.Name & " is out of date." & Chr(13) & Chr(10) & "Please reopen the database after it closes.", vbInformation, "Updating database"
                
CopyFile "X:\Database.mdb", CurrentProject.FullName

 
Application.Quit acQuitSaveNone

End If
            
End Function

Specific error is that the switchboard form on the db does not load using Access 2010 after the update. Everything else seems to work. Also impossible to manually open or design form after the update, since Access says it now cannot recognize data in that form ?! 2007 Access works perfectly, no problems.


I've already turned off everything obvious in the Trust Center, as well as designated my source location as a trusted location. Plz help!

[June7]

Don't do design edits in 2010 version. File will probably not be backward compatible, in spite of the common file name extension.

You say the edits in 2007 make the form not run in 2010? That is odd. You say 'macro' but looks like VBA code. How was the switchboard originally created - by wizard? Try rebuilding it manually from scratch.

[pacnwWill]

Thanks for the reply. Yes, it's VBA code in the Autoexec module, running automatically on db load. Sorry, not sure what you mean by "design edits", since I'm just trying to copy over the entire db - i.e. replacing the old desktop copy on each user's workstation with the updated version sitting in X: drive.

Ya, the switchboard not loading on 2010 is really strange, since everything else seems to work. I'll try redesigning the form per your suggestion and see if that helps. At this point, I'm guessing that it's basically file compatibility issues between 07 and 10? Thanks.

[June7]

By design edits I mean creating/modifying objects (tables, queries, forms, reports) and code.