Mark, I am still shoulder deep in Access these days! It could be a corruption issue, or it could be that it was created with such an old version that the newer version you are using is having some trouble opening it. MS says that shouldn't be an issue, but I have seen stranger things!
One option you can try is to create a new Access database (save it to your desktop, or where-ever), then try to import everything from one of these MDB's. >From the Access Ribbons: "External Data"->"Access"-> browse to MDB, and select "Import tables, queries, forms, reports, macros, and modules into the current database" then click OK. In the next popup, do select all on each tab, then expand the options button and make sure to select to import the "menus and toolbars", too, just in case they used custom menus. If that import works, you should have access to everything. If it doesn't, try again, this time just importing the tables, then go back and just import queries, and so on. Good Luck! (And you can contact me off list if you still need some help) -- Ken (832) 493-0535 On Tue, Aug 30, 2011 at 9:04 AM, Mark Davis <[email protected]> wrote: > hey gang, > > My boss threw me a curveball yesterday by handing me an Access database > that needs a few changes. However, the original file he gave me is an MDE > file and not the actual MDB, so my understanding is that all the VB code > (and it has a lot) is compiled. He has since given me 4 MDB files. I > have no idea in what version of Access they were created, but its been > probably 6-7 years since they were created. > > So I open the mdb file in Access 2007 and I get the main forms. I go to > the Visual Basic editor and I see thees and classes, but when I try to open > any of them I get "Project is Unviewable" or "project Locked". I googled > this and see an article about digital signatures getting messed up, but this > mdb file has no digital signature. > > anyone work with Access much anymore? Ken, I think I remember you > mentioning you have been working with Access lately. Any thoughts? > > Thanks > > Mark > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > ColdBox training coming to Houston in July from the creator of ColdBox, > Luis Majano! > Use discount code "CFUG" for $175 off. More info at > http://bit.ly/ColdBoxHouston > -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en ColdBox training coming to Houston in July from the creator of ColdBox, Luis Majano! Use discount code "CFUG" for $175 off. More info at http://bit.ly/ColdBoxHouston
