Library dependency

[blueeagle69]

Hi

Apologies, if something similar has been posted.

I have created a databse, that handles, names,addresses, items bought, and so on.

Because of this, the database uses the internal variable Date().

I recently fitted a new hard drive, and when I came to run the database, to print out addresses, it complained that a missing DLL (Iaiexplore.dll) was needed. I clicked OK, and every field or line of code that uses the Date() variable no-longer works without this DLL. Which is off because this particular DLL belonfs to the Intervideo WinDVD player!
My database handles a lot of things, but it doesn't play DVD's!

If I create a new database, the Date() variable works, it juswt doesn't work in mine without that DVD player being installed.
This has baffled me.
I did have this app installed, but I switched to another DVD player, after fitting the new Hardrive.

For one-reason-or-another my database has a dependency for this DLL, and the Date() string won't work without it. And this of course, has a knock-on effect of stopping something else from working.
I went to Macros/Tools/References, and removed it from there, but it still didn't cure the Date() problem. Although it didn't ask for this DLL again.

I cured it the last time by re-installing the DVD player, but this is ridiculous, and seems overkill.

Thanks

 

[Newman]

The problem is that Access cannot use any DLL if one of them is missing.

Going to «/Tools/References», unchecked the missing ones, save and run your application again should have repaired it. I suggest you try again and make sure no «Missing» is left checked.

 

[blueeagle69]

DLLs's

Hi

That was one of the first thing I tried.

Even though it no-longer asked for the DLL's, the Date() variable refused to work.

I got it to work by re-installing WinDVD, and re-registering that DLL within Access. Then afterwards, it sprang to life(With WinDVD installed). Hardly ideal.

I will try again though.

Thanks.

 

[blueeagle69]

Thanks

Hi

Sorry for the late reply.

I tried it again, and this time it seems to have worked.
I can now hopefully uninstall WinDVD, and leave my database going cold turkey in corner!

Thanks again.