My previously stable MS Access program now has many runtime errors when running in windows7

Question

I have run Access repair tool over the installation.. still have same faults Runtime error 48 referencing a dll error. when I hit a search combo box.

I have made a new copy of Access and imported all the items into it and still produces the same probelm

I feel its a problem with Office 2003 where it was fine under Win XPSp3

Its possible the is some underlying problem with the Office 2003 installation..

Is then any way to repair the installation of Access

I am also unable to create a Temp file export from within a Module, which used to work fine..

Answer 1

First of all Windows 7 will not let you let you do much to C:\ unless you change setting for the TrustedInstaller, so I would suggest creating a new folder under My Documents (or Documents as Windows 7 calls it) and then using s new file path.

As for the missing DAO library, perhaps you need to select custom and run everything from your hard drive.  Running from the CD will not load all files.  But it should be on the CD.  You could try a Repair and see if that fixes the issue.  Can you post the code you are using here?  There might be something there that will show what is happening.

Answer 2

I am a bit unsure about privileges, running Windows 7 Home Premium.  I dont get a run as Administrator option from file either windows explorer or from open within access. There is only one user on this machine saying that the account is Administrator.

Outlook is same as Access, installed from Office disk, 2003 with SP3.

I installed a run all copy of Access, from CD

Some sort of Office 2010 preview demo? version. Ive now removed it with CCleaner, BUT Still getting same failures. should I do a repair of Access or a re-install?

My send to Outlook module that looks for a saved snap file in C:\ fails cant find file.. I looked and the file is not there?

I ma using strAttach = "c:\TempSnp.snp it used to work on XP so I think its related to DLL's.

DeBug gives me a warning MISSING references DAO360.dll vsn5 the only copy I see in the installation is a copy in the Office11 folder, Browsing there via the references window, its not showing up unless I change to all file types then if I select it, MS Visual Basic popup reports cant add reference to the specified file. so I think its an incompatible version.

Answer 3

Try right mouse click and Run As Administrator.

And a thought... What version of Outlook do you have installed?  And do you only have the one version of Office installed?

Answer 4

I have had a look at the email advice and as yet have Failed to get it running. I have Access 2003 on a Win7 machine Access references are: Visual Basic foe Apps, MS access 11.0 Object Library, MS ActiveXdata Objects 2.0 library, MS Outlook 11.0 Objects library, I have one module that attaches a snapfile to to an email, so Ive found I need that one. I have un-installed Access completely and re-installed it using a new CD and I get the same problem. Ive followed Allen Browns online help setting up a new instance of Access and imported everything into the new copy and still get the same result. A lot of issues in my mind revolve around the going version was designed around MS. DAO 3.6 library which seems not to want to work in a 2003 Access version I tried adding DAO360.dll to Access via the regsvr32 process and I got warnings, that it wasn't designed to work with 2003. I cant find an acceptable ActiveX Data Objects Lib that will allow me to convert to ADO either. Ive tried removing all References and running DeBug and trying to find references to resolve each stoppage, Ive been able to get a successful complie but I must have issues as the module that sends a report to Outlook returns an runtime error -2147024894 (80070002) and all my combo boxes return runtime error 48. error loading dll. debug fails on line [code] set rs = me.recordset.Clone [code] In design Trying to recreate a combo box fails reporting 'error in loading dll'  As I see it the problem is probably in the dll's somewhere but I cant resolve it.. any help other than the steps already covered greatly appreciated

Answer 5

Sounds like you have some Reference issues, take a look here...

http://www.access-diva.com/d5.html

...you want to do this on a Windows 7 machine.  If you are not sure of a Reference you can post it here for us to take a look.