If it helps: I have been able to open mdb's built with Access 2000 on my laptop which is running Access 2007. But, I did have trouble with ones that were created with a version prior to Access 2000.
--Ken On Tue, Aug 30, 2011 at 11:39 AM, Aaron Rouse <[email protected]> wrote: > 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 > -- 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
