Help with remote Data Access.

GeneBuchite · May 16th, 2010, 10:26 AM

I am new to Visual Basic 2010. I have been writing and maintaining a database solution for my small business since 2005. I started With MIcrosoft Access, Then upgraded to Visual Basic 6. John Connell & Wrox Publishing helped me to understand all I need to know to devolop my apps. I am currently using Windows xp an looking to upgrade to windows7, thus the need to upgrade to visual Studio 2010. "Beginning MS vb 2010" by wrox Publishning has been a great help with getting started using a local database, agian "WROX" to my rescue.
The Application curently stores a Database on my local machine. Local Machine handles most of the original data input. there are 3 other computers on the network that connect to the data base, they read, and write to the database on the main computer.

I am looking for a simular solution in visual studio, but so far am just banging my head against the wall. Can anyone point me in the right direction?

guess I will start by joining the wrox.booxs24x7.com reference library.
Thank you for any help you can give.

Gene

GeneBuchite · May 16th, 2010, 02:01 PM

Oh Wow. This wasnt so hard. All I had to do was use the Database object rather than the SQL approach that navigate to my network drive:\path AND DATABASE... Much like I did in VB6. First I had to upgrade my data to ADO Rather then DAO. Access 2000 MAnd this easy for me. Thanks to all who dstarted a reply.

CalmSeas · May 31st, 2010, 06:16 PM

I struggled with this for a short while, I'm new to VB 2010 most of my experience was with R:Base. (Please no flames);)

I think I found a small error because it didn't work for me, but who knows it might be me. As with most programming, once you get it to work, it works well. On page 490 of the Beginners Visual Basic 2010 at the top of the page there were some commands to facilitate using variables in an SQL INSERT syntax. The set of commands in the book says; objCommand.parameters...("@au_id", txtAuId.Text) but in my application I was getting a syntax error "Text is not a member of String". This command syntax worked for me;

Code:

 objCommand.Parameters.AddWithValue("@Column Name", txtvarName.ToString)

. The ToString instead of Text was the problem. The Intellisense didn't have the Text in it but did have the ToString in it. Like I said, I'm new and still grasping at using and understanding classes,methods, etc. so if I didn't describe it correctly, forgive me.

Glenn Brown