Connect VBapplication to Access database

[touchstone57]

I'm using Windows XP (SP2)

I have done all you said but to now avail, I extracted the files to the download folder and double clicked SetupSP6 and got the error message.

Click here to view error message

Or in text format
===================================
16 bit windows subsystem

NTVDM has encountered a System Error
Access is denied.
Choose 'Close' to terminate the application
===================================

[Sidewinder]

I have followed the instructions myself and am unable to recreate the message you're generating. There are only two exe files in the directory where the components were expanded (acmesetup.exe and setupsp6.exe). Double clicking on setupsp6 brings up a screen titled: "Visual Studio 6.0 Service Pack 6 Setup".

Suprisingly, I can  run this from the command prompt and/or the cmd prompt and/or Windows Explorer.

I can only suggest the downloaded file is corrupt or something else is going on here. I can think of no reason why the DOS VM got involved in this.

 

[touchstone57]

I'm not sure why this is. I have downloaded the file at least 3 times now and I get the same message...what does it mean 16 bit sub system? because I'm using 32 I'm sure...

It seems like one error turns into another

[Sidewinder]

Couldn't find much info on the net concerning the NTVDM problem in Windows XP. NTVDM is the 16-bit virtual machine inside Windows needed to run 16-bit programs. If you have legacy programs, it might be called into action, but many people will never even see it.

Try seeing if any entries in the event viewer give any hints as to what is going on:

Control Panel==>Administrative Tools==>Event Viewer

Check both the Application and the System logs. Maybe, just maybe they'll offer a hint of the problem. I'm quite sure the SP6 installer is a 32-bit program.

This problem only gets stranger and stranger.

[touchstone57]

I'm not sure what it says in the event viewer but I have made some pictures.

For application view click here

For system view click here

Note: May require enlarging for better viewing

Please tell me if anymore information is required.

[Sidewinder]

There is nothing in the logs that point to anything. How long was the lag from when you ran setupsp6 and you viewed the logs? Try the setup again and as soon as it fails, check the logs.

I would think you'd get an entry in Application log for the MsiInstaller or maybe for the NTDVM itself. Any clue would be a godsend at this point.

[touchstone57]

That is the log files only a few seconds after I ran the setup...what can the first error mean? the about Nview 

[Sidewinder]

The Nview entry (or any other entry) can be double clicked for more information. In any case the error occurred on 08/01/2007 which is either January in the UK or next August in the US. 

I'm at a complete loss. Maybe someone will come along that can help. I'm still stumped about how his relates to the NTDVM.

Good luck.

Since you apparently have the entire Visual Studio suite, try updating the suite from the link in post #10.

[touchstone57]

well I tried running the Visual Studio service pack also but with the same results...

Now I'm completely stumped...and I need to get VB fixed so I can work on my assignment

thanks for all of your help anyway

[touchstone57]

BREAKING NEWS
   =============

Yes I have some good news  , I finally managed to get it to install service pack 6! I was just playing around with it almost having lost all hope, and I decided I would unpack the setup files to a different directory than the one my file was downloaded to...I sent it to My videos (just for fun) and it installed successfully.

Now we get back to the original task at hand, to connect my Vb application to the database....

Fingers crossed

Hope all goes well

[Sidewinder]

I'm glad you finally got the update installed. Still don't understand why the location of the expanded files would make a difference, but I'm not one to argue with success.

Let's hope this fixes the problem you first posted, way back when.

Good luck.

[touchstone57]

Just to report back, I changed the "connect to" database to Access 2000 and now my program is working perfectly with no errors.

Thank for all of your time and help 

[mhk_nzs]

somebody please give the command how to link VB to Access database....

[Sidewinder]

Please do not hijack other poster's threads. You have a better chance of getting an answer if you post your own thread.

If I remember correctly, VB6 and VB.Net have wizards to connect to a database. You can also connect a control to a database using the property page during forms design or you can do it the old fashioned way and do it directly in the code.