p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Visual Basic 2005 Basics (http://p2p.wrox.com/forumdisplay.php?f=137)
-   -   connecting to database (http://p2p.wrox.com/showthread.php?t=63435)

stealthdevil November 1st, 2007 01:49 PM

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


planoie November 1st, 2007 03:18 PM

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

stealthdevil November 5th, 2007 01:31 PM

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



All times are GMT -4. The time now is 02:24 AM.

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