![]() ![]() So I Restored and while that fixed some things, it did not fix the problem of "Microsoft Office 12.0 Access database engine" being missing. Out of desperation, I looked at the Restore Points list and there was only one - the day MS installed OneNote and screwed up my computer. I had not previously tried doing a Restore because in all the years since Restore was "invented", I've never had to do a Restore and eventually just quit bothering to set a Restore Point. Sometimes I could fix one problem only to create a new one. I've spent the time since then trying everything. If you need portability I'd move to Jet and its default engine type 5 (2000/2003 format MDB). Just update your failing connection string to use the newer ACE Provider (14.0?, 16.0?) you installed over the top of the older one. If you don't need this to run on other machines you can probably just make a quick hack and be on your way. Why would the same program use both the simplistic ADODC and its big brother the Data Environment? Egad, how many separate opens do you have on the same database? This is the native format of the Jet 4.0 Provider which is a stable part of Windows and has been for decades now. Ideally you'd have chosen to use the "Access 2000/2003" format MDB instead. It sounds like part of your problem is that the OneNote install trashed .12.0 and installed .16.0, one of the most common instabilities. One problem with the ACE formats is the instability over time. I'm stuck.Īre you really using both ADO and DAO in the same program? If so, why? Sounds like a mistake. I know that this is a lot of stuff to wade through, but I wanted to provide all the relevant info I could think of. I had a terrible time getting Access 2007 to work with my program back then, and I documented all the problems and fixes for future reference, but I never had this particular problem. I see "OfficeSetup.exe" (6.6MB) dated in my Downloads folder, which must be what OneNote installed when I thought I was getting a simple app. I upgraded this program from Access 1997 to Access 2007 in mid-2018, but I can no longer find the DVD, so reinstalling Access isn't an option. The database works fine when I open it in Access 2007. Data source name not found and no default driver specified.Īt first I got a message about the Registry not being right (didn't write down the message), so that may be related, though I never got the message again and I wouldn't know what to do in the Registry anyway. Test connection failed because of an error in initializing provider. ![]() Provider=.12.0 Data Source=C:\Programming\VB98\Bridge\BidBase.accdb Mode=ReadWrite Persist Security Info=False In the Adodc controls' Properties window, "Use Connection String" is When I load the bridge program and open a form with the Adodc data controls on it, I get the following message for each control: In "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12" is a file named "ACEDAO.DLL" but when I Browse in References and select that file, it does not show up in the Reference list. I don't know the actual filename which the Engine lines pointed to. (That is all that is shown.) The "vfs" folder is now empty. Instead, it has "Microsoft Office 16.0 Access Database Engine Object Library", but it points to a file in "C:\Program Files (x86)\Microsoft Office\root\vfs\ProgramFiles.". I was able to reselect them all except "Microsoft Office 12.0 Access Database Engine Object Library". Long story, short: all the selections in "Project - Reference" and " - Components" were wiped out somehow. I installed MS OneNote recently because I read that it can perform OCR, but I couldn't get it to work, so I uninstalled it, after which neither program would run any more. I've been working on these programs for 20+ years as a retirement hobby unlikely ever to be finished in my lifetime, but still important to me as a hobby. One is Natural Language Processing and the other is a bridge game. I have two massive programs which have different, very large Access 2007. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |