INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Visual Basic 2008 Express

Visual Basic 2008 Express

(OP)
Does anyone know what features are missing from VB 2008/ VB 2010 Express that
are present in the fu1l versions? For example has the facility to amend data on a
database been disabled?

RE: Visual Basic 2008 Express


Google and Wikipedia are your friends. That was literally the first result of a search for 'visual studio express version limitations'

https://en.wikipedia.org/wiki/Microsoft_Visual_Stu...

The info you want is under the heading "2005–2010 products".

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

RE: Visual Basic 2008 Express

(OP)
Hello Jebenson
Thank you for your quick reply.
According to Wiki, VB 2008 and 2010 Express are compatible with MS Access and SQL Server.

However they only seem to have 'read only' access rights as any updates don't actually take place.

The following code, adapted from a Microsoft web-site doesn't work, while at the same time does not
trigger any error.

Try
Me.TestTableAdapter.Update(Me.AphDb1DataSet1.Test)
Me.AphDb1DataSet1.Test.AcceptChanges()
Me.TestTableAdapter.Update(Me.TestBindingSource.Contains(Me.AphDb1DataSet1))
Catch
MsgBox("Update NOT successful ! " & Err.Number)
End Try

RE: Visual Basic 2008 Express


First, try removing the line "Me.AphDb1DataSet1.Test.AcceptChanges()" and see if that works.

Second, make sure you have all the Command objects (InsertCommand, UpdateCommand and DeleteCommand) set for the TableAdapter.

Third, what database are you using, SQL Server or Access? If it's Access, check the "Copy to Output Directory" setting in Server Explorer, as it defaults to "Copy always." In this case, check the bin\Debug directory for a copy of the database, and I'll bet you'll find the data there. Changing this setting to "Do not copy" will make the application use the database you selected and not a copy. Here's a link with more information about the Copy to Output Directory setting:

https://msdn.microsoft.com/en-us/library/ms246989%...

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

RE: Visual Basic 2008 Express

(OP)
Thanks very much, Jebenson.

Point 2 solved the problem.

Regards

Ken01

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close