Can Not Get into Design on Forms or Reports Help

[chiplarsen]

I have an Access 2003 database that created by someone else. When I go to the Database Window, I can not edit Reports or Forms. I can get into design for the tables, queries, and macros. The database is saved as a mdb, not a mde. Does anyone know why this is?

 

[Remou]

Could it be an mde renamed as mdb? This is not uncommon. I guess you have a full version of Access?

http://lessthandot.com

 

[chiplarsen]

Thank you. I see what you are saying. It really act likes a mde. Is there another way to determine if it trully is a mde?

 

[Remou]

In another database:

Sub CheckMDE()
Dim db As Database

'This is the path and name of suspect db
strDB = "C:\Docs\Test.mdb" 

Set db = OpenDatabase(strDB)

If db.Properties("MDE") = "T" Then
    MsgBox strDB & " is an MDE"
End If
End Sub

http://lessthandot.com