Problem to create a MDE-file

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

Guest

Hi,
I have a working Access VBA application that I want to create a MDE-file
from. When I do so Access returns a message that says: "Table
TempMSysAccessObjects already exist". No MDE-file is created!
How do I overcome this problem? VBA-code is in Access 2000-format and I use
Access 2000 when I try to make the MED-file.

Any help is appreciated.
 
Here is some code I use before compacting and repairing a database on
closing. I use it right before the "DoCmd.Quit" command. It deletes
TempMSysAccessObjects table if it exists, and prevents the "Table
TempMSysAccessObjects already exists" error.

Dim objtbl As AccessObject
For Each objtbl In Application.CurrentData.AllTables
If objtbl.Name = "TempMSysAccessObjects" Then
DoCmd.DeleteObject acTable, objtbl.Name
End If
Next objtbl
 
Back
Top