I did some Access development earlier this year and found that the only way I could get into their old file was via installing a prior version of Access than 2007. I think I installed 2003 or had it on another computer. Unfortunately I slept since all this happened so my details are hazy within my mind.
On Tue, Aug 30, 2011 at 11:28 AM, Ken Auenson, II <[email protected]>wrote: > 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 > -- Aaron Rouse http://www.happyhacker.com/ -- 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
