Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 1st, 2007, 01:49 PM
Friend of Wrox
 
Join Date: May 2006
Location: Jonesboro, AR, USA.
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Default connecting to database

Hi,

I'm working with VB.Net in Visual Studio 2005. I want to create a connection to an Access DB I have created. There is a pop up asking if I want to bring the database into my project or create the connection onto the network where the database is now. It says if I copy to the project it will be recopied each time the App runs. Just thought I'd ask which direction I should go with this as I am not really sure. Pros?/Cons?

Thanks,
Dave

  #2 (permalink)  
Old November 1st, 2007, 03:18 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

I imagine "recopied each time the apps runs" would be filed under the "con" column.

Have you considered using SQL server express instead of access, if it free and give you the benefit of a "real" SQL server instead of the problems that tend to come from using Access.

-Peter
  #3 (permalink)  
Old November 5th, 2007, 01:31 PM
Friend of Wrox
 
Join Date: May 2006
Location: Jonesboro, AR, USA.
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply planoie!

I did actually start out trying to use SQL Server Express. I just got a little overwhelmed, so I went back to access since I know access. How hard do you think it would be to use SQL Server? I wasn't really finding the info. I needed when I was trying to learn SQL Server. If you could point me in the right direction I would appreciate it very much.

Thanks,
Dave



Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to Database bryantms ASP.NET 3.5 Basics 3 July 9th, 2008 12:34 AM
Connecting to a database mfos Classic ASP Basics 0 December 20th, 2006 07:59 AM
connecting to a database nehalw VB.NET 0 January 5th, 2005 05:59 AM
database connecting princeofdhump Classic ASP Databases 3 August 7th, 2004 02:46 AM
Connecting To DataBase in WAN simsimlhr C# 3 March 29th, 2004 04:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.