943,670 Members | Top Members by Rank

Ad:
Aug 27th, 2008
0

VB with MS Access

Expand Post »
Hey,

I made a VB project which saves and loads data by writing and reading from an MS Access database. One problem is when i run the exe on a different computer i get the "Runtime Error 91 Object variable or width block not set " error. Now I am assuming that is because I have not got MS Access installed on the computer (correct me if I am wrong). Are there any packages that can install all the required components onto a machine that hasnt got Access on it so it can work? Or is there another way I can get it to work?

Thanks
Similar Threads
Reputation Points: 16
Solved Threads: 2
Junior Poster
Don Gino is offline Offline
102 posts
since Oct 2006
Aug 27th, 2008
0

Re: VB with MS Access

Hello,

Yes, I believe the error you are receiving is because the target machine does not have the necessary objects or components that is included in your application. You may need an installation tool, like InstallShield(if called this anymore) or Wise to distribute the appropriate components to the target machine.

If an installation tool is not readily available then you have to determine each component the application needs to run on the target and then register those components (.dll's) by running RegSvr32.exe, I believe.

HTH
Reputation Points: 10
Solved Threads: 2
Newbie Poster
wrappingduke is offline Offline
17 posts
since Jul 2008
Aug 28th, 2008
0

Re: VB with MS Access

Use the Package and Deployment wizard to create the Setup Package from the source system where u have developed this project.
This addin is a part of Microsoft Visual Basic.

1. Open ur project
2. Select Add-Ins -> Add-In Manager... option
3. Select the Package & Deployment Wizard
4. Put a check for Loaded/Unloaded and Load on Startup check boxes.
5. Click Ok.

Now u can find the Package & Deployment Wizard menu option in the Add-Ins menu. Click it and follow the instructions. This wizard will automatically identify all the required object, components and dlls for the project. except for user created files like ur database files, icon files etc. which if u want can manually add them in, i beleive 4/5 step of the wizard

Once the setup package folder is created, copy it to CD or pendrive and perform the setup process in the target computer.


Hope this helps u. Try it and if any problems get back to us.

Regards
Shaik Akthar
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Aug 28th, 2008
0

Re: VB with MS Access

I have just told a collegue about your instructions Shaik Akthar, and for the project he is working on it works. I cant try mine right now but I am pretty sure it should work for me. Thanks a lot for your help, all this time I never new VB had its own packaging feature. I will keep you posted when I give it a go. Thanks a lot again
Last edited by Don Gino; Aug 28th, 2008 at 1:53 am.
Reputation Points: 16
Solved Threads: 2
Junior Poster
Don Gino is offline Offline
102 posts
since Oct 2006
Aug 28th, 2008
0

Re: VB with MS Access

Any problems get back. If solved mark the thread as solved

Regards
Shaik Akthar
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Aug 29th, 2008
0

Re: VB with MS Access

I am having a few other problems, not related. Thanks for your info, I think that part is now solved.
Reputation Points: 16
Solved Threads: 2
Junior Poster
Don Gino is offline Offline
102 posts
since Oct 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Vb6 office 2000
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: I need help for adding URDU in a Word Process





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC