Access 2003 - Upon opening DB, .dlls and .ocx errors
Hi Experts
I have been working on a project for the last couple of months now.
I am having the following problem, when I move my DB to another PC, upon opening the DB it keeps on asking me for the following to files.
nero "nbcalendar.ocx" and
nero "controlls.dll"
How do I know if I am using these files in my current DB and how can I work around this so this error does not keep on popping up?
Regards
mustekkzn
I have been working on a project for the last couple of months now.
I am having the following problem, when I move my DB to another PC, upon opening the DB it keeps on asking me for the following to files.
nero "nbcalendar.ocx" and
nero "controlls.dll"
How do I know if I am using these files in my current DB and how can I work around this so this error does not keep on popping up?
Regards
mustekkzn
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Fredthered
Looks like a great little tool this. I am just not sure how to use it.
I see that there a lot of functions, which I dont really need.
All i need is to be able to add the .OCX and .DLL files, including the Access DB file.
Could you please assit me, if possible.
Thanks
mustekkzn
Looks like a great little tool this. I am just not sure how to use it.
I see that there a lot of functions, which I dont really need.
All i need is to be able to add the .OCX and .DLL files, including the Access DB file.
Could you please assit me, if possible.
Thanks
mustekkzn
ASKER
Hi Fredthered
A quick update, I have manage to get it working, very nicely. i am very impressed with this little application.
All I need to know now it how to get it to create a shortcut on to the desktop and how to put the file under Start, Programs.
Thanks
mustekkzn
A quick update, I have manage to get it working, very nicely. i am very impressed with this little application.
All I need to know now it how to get it to create a shortcut on to the desktop and how to put the file under Start, Programs.
Thanks
mustekkzn
ASKER
Hi Fredthered
I have manage to play some more with this tool and got to get it working like I wanted too.
I must admit, initially it is not easy to use, but after getting to use it a bit, one tend to master it.
Thanks once again for this great application.
KInd regards
mustekkzn
I have manage to play some more with this tool and got to get it working like I wanted too.
I must admit, initially it is not easy to use, but after getting to use it a bit, one tend to master it.
Thanks once again for this great application.
KInd regards
mustekkzn
Hi mustekkzn,
sorry for not replying to your additional comment, but you can use the yellow 'Links' button on the Little Setup Builder main menubar to add shortcuts.
What I usually do is target multiple versions of Microsoft Access by:
1. using the Project...Custom Variables option to create variables representing each version of Microsoft Access that my packaged app targets; e.g.
Custom variable:
Name: OFFICE
Value: «@PF»\Microsoft Office\Office
Description: Microsoft Office 2000
Custom variable:
Name: OFFICE11
Value: «@PF»\Microsoft Office\Office11
Description: Microsoft Office 2003
Next, I use the Links dialog box to create multiple desktop shortcuts; e.g.
Link:
Caption: Photographs Application
Linked file: «OFFICE11»\msaccess.exe
Arguments: "«@T»\AppPhotos.mdb" /wrkgrp "«@T»\AppPhotos.mdw" /user "username" /password"password"
Working directory: (This option) @T
etc.
I normally create desktop links for Access 2000, Access 2002 and Access 2003 using this technique, and provided that you are reasonably sure about the target platform of your app, you can use this stratey to create the links, and have the user discard those that aren't relevant.
Regards.
sorry for not replying to your additional comment, but you can use the yellow 'Links' button on the Little Setup Builder main menubar to add shortcuts.
What I usually do is target multiple versions of Microsoft Access by:
1. using the Project...Custom Variables option to create variables representing each version of Microsoft Access that my packaged app targets; e.g.
Custom variable:
Name: OFFICE
Value: «@PF»\Microsoft Office\Office
Description: Microsoft Office 2000
Custom variable:
Name: OFFICE11
Value: «@PF»\Microsoft Office\Office11
Description: Microsoft Office 2003
Next, I use the Links dialog box to create multiple desktop shortcuts; e.g.
Link:
Caption: Photographs Application
Linked file: «OFFICE11»\msaccess.exe
Arguments: "«@T»\AppPhotos.mdb" /wrkgrp "«@T»\AppPhotos.mdw" /user "username" /password"password"
Working directory: (This option) @T
etc.
I normally create desktop links for Access 2000, Access 2002 and Access 2003 using this technique, and provided that you are reasonably sure about the target platform of your app, you can use this stratey to create the links, and have the user discard those that aren't relevant.
Regards.
ASKER
Hi Fredthered
Thanks for the above post. I am really enjoying the tool. I mite have gone a bit over board,
but I went and created a read me file to my DB and added to the exe file. I was just having a bit of fun.
Once again, thanks for the tool. it is working out great for me.
Kind regards
mustekkzn
Thanks for the above post. I am really enjoying the tool. I mite have gone a bit over board,
but I went and created a read me file to my DB and added to the exe file. I was just having a bit of fun.
Once again, thanks for the tool. it is working out great for me.
Kind regards
mustekkzn
What about your copyright notice and photograph?
ASKER
Hi Frankytee
Sorry it is me again. I just posted a question again, I know the one I posted below is very similar to an older one a I posted before. I just cant get my head around the code. If you could please assist me in this matter.
Thanks so much and chat to you soon again.
From
mustekkzn
https://www.experts-exchange.com/questions/22917641/Access-2003-How-do-I-link-3-drop-down-boxes.html
Sorry it is me again. I just posted a question again, I know the one I posted below is very similar to an older one a I posted before. I just cant get my head around the code. If you could please assist me in this matter.
Thanks so much and chat to you soon again.
From
mustekkzn
https://www.experts-exchange.com/questions/22917641/Access-2003-How-do-I-link-3-drop-down-boxes.html
1. open a command promt
2. cd to the folder containing the OCX/DLL
3. regsvr32 nbcalendar.ocx
4. regsvr32 controlls.dll
If controlls.dll is not automation dll, then you will get an error message similar to "controlls.dll was loaded, but the entry point DllRegisterServer was not found", which can be safely ignored.
Also, note that the little setup builder will handle automation dll registration automatically, if you set the 'Register as IN-PROC Server (Ocx-Dlls)' option in the file Install Mode tab.