LoadLibrary - Lebans dynapdf.dll

[Annette]

I currently use Lebans process to convert access reports to PDF. I
have an access 2003 database that uses the report to pdf option,
creates an email and sends the pdf as an email attachment. This works
perfect! Since I would like to schedule this as a task, I installed
Access 2003 on another server, mapped a drive to this database and am
trying to run the process from that server. I am accessing the SAME
database and folder of dll as I did on my computer, but from this
server and installation of Access. The process dies and closes access
at the statement: hLibDynaPDF = LoadLibrary("DynaPDF.dll").

Is there something I need to do with this version of access to get it
to run the load library statement or is there something else I should
be looking at? I am not sure why it works accessing the database/dlls
from my pc, but not accessing the same thing from a different
installation of Access 2003.

 

[Arvin Meyer MVP]

You need to install/load the dll on the machine that Access is running from.
It doesn't matter where the data is, it matters only where the process is
running from.

 

[Annette]

I do have the dlls in the C:\WINDOWS\SYSTEM32 folder on this machine
and still get the same issue. Then I placed them also in the folder
where the application resides.

The program aborts when it gets to this line of code: hLibDynaPDF =
LoadLibrary("DynaPDF.dll")

 

[Arvin Meyer MVP]

I don't believe that you need to register the file, but you might try that.

Start >>> Run

regsvr32 "C:\Windows\System32\dynapdf.dll"

Install it the same way as you did the first time. The other thing that
might help is if you do not have your database split, do so and put the
Front-end on each computer running the app.

 

[Tony Toews [MVP]]

I don't believe that you need to register the file, but you might try that.

No, you don't need to register the DLLs. I've never done so and I've
distributed it many times without registering them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I currently use Lebans process to convert access reports to PDF. I
have an access 2003 database that uses the report to pdf option,
creates an email and sends the pdf as an email attachment. This works
perfect! Since I would like to schedule this as a task, I installed
Access 2003 on another server, mapped a drive to this database and am
trying to run the process from that server. I am accessing the SAME
database and folder of dll as I did on my computer, but from this
server and installation of Access. The process dies and closes access
at the statement: hLibDynaPDF = LoadLibrary("DynaPDF.dll").

I wonder if you have two different versions of the two DLLs? Also if
you downloaded a newer version of the DLLs did you also update the VBA
code which references those DLLs?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I do have the dlls in the C:\WINDOWS\SYSTEM32 folder on this machine
and still get the same issue.

Putting the DLLs in any folder other than the folder in which the
front end MDB/MDE resides is definitely not needed. This also won't
work well for users who do not have admin privileges.

Then I placed them also in the folder
where the application resides.

That's exactly what I've done and it works well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Lawrence Lee]

I just stumbled onto Lebans website a few days ago and what a Gem!

Anyway, I have imported the modules from the sample MDB into my own MDB and it worked without making any changes to my own MDB. I am using Access 2003.

I am learning DynaPDF right now so may be in the future I can extend Lebans' tools to my other needs.

One thing I want to point out is you need to copy StrStorage.dll as well as the DynaPDF.dll in the same folder where your MDB is.

Good Luck.



Posted as a reply to:

Re: LoadLibrary - Lebans dynapdf.dll
23-Apr-09



I wonder if you have two different versions of the two DLLs? Also if
you downloaded a newer version of the DLLs did you also update the VBA
code which references those DLLs?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx