473,698 Members | 2,379 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Selecting Database Path

Hi all,
I have an inventory application I'm writing for the company I work for
and realized the path for the Access database might reside on a network
drive. I have used Microsoft's Add Data Source method of adding the db to
the app. How could I customize this so the path can be changed. I found
that the connection is a ReadOnly property and cannot be changed.

Thanks,

Tony K

Jul 24 '07 #1
3 1592
I'm assuming that you're using VB.NET for your application.

When you run the add data source wizard in VS2005, it will create an
application variable called "ConnectionStri ng" in your applications's config
file ("MyInventoryAp p.exe.config", for example). That can be changed by any
text editor.

Were you wanting the user to be able to change it via the user interface?

"Tony K" <no************ @kingprogrammin g.comwrote in message
news:uu******** *****@TK2MSFTNG P06.phx.gbl...
Hi all,
I have an inventory application I'm writing for the company I work for
and realized the path for the Access database might reside on a network
drive. I have used Microsoft's Add Data Source method of adding the db to
the app. How could I customize this so the path can be changed. I found
that the connection is a ReadOnly property and cannot be changed.

Thanks,

Tony K

Jul 24 '07 #2
Yes, I was hoping to be able to program say a "Tools" form and allow the
user to select where the database resides then write that info to a config
file or store that path in the registry or something like that.

Tony K
"Chris" <ch*********@sb cgloal.netwrote in message
news:SM******** ***********@new ssvr23.news.pro digy.net...
I'm assuming that you're using VB.NET for your application.

When you run the add data source wizard in VS2005, it will create an
application variable called "ConnectionStri ng" in your applications's
config file ("MyInventoryAp p.exe.config", for example). That can be
changed by any text editor.

Were you wanting the user to be able to change it via the user interface?

"Tony K" <no************ @kingprogrammin g.comwrote in message
news:uu******** *****@TK2MSFTNG P06.phx.gbl...
>Hi all,
I have an inventory application I'm writing for the company I work for
and realized the path for the Access database might reside on a network
drive. I have used Microsoft's Add Data Source method of adding the db
to the app. How could I customize this so the path can be changed. I
found that the connection is a ReadOnly property and cannot be changed.

Thanks,

Tony K

Jul 24 '07 #3
Chris,
How would I access the config file? The filename is
Inventory.exe.c onfig and the info that I would need to access is:

<connectionStri ngs>
<add
name="Daily_Foo ds_Inventory.My .MySettings.Inv entory_manageme nt_databaseConn ectionString"
connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;Data
Source=&quot;|D ataDirectory|\I nventory management database.mdb&qu ot;"
providerName="S ystem.Data.OleD b" />
</connectionStrin gs>

Tony K
"Chris" <ch*********@sb cgloal.netwrote in message
news:SM******** ***********@new ssvr23.news.pro digy.net...
I'm assuming that you're using VB.NET for your application.

When you run the add data source wizard in VS2005, it will create an
application variable called "ConnectionStri ng" in your applications's
config file ("MyInventoryAp p.exe.config", for example). That can be
changed by any text editor.

Were you wanting the user to be able to change it via the user interface?

"Tony K" <no************ @kingprogrammin g.comwrote in message
news:uu******** *****@TK2MSFTNG P06.phx.gbl...
>Hi all,
I have an inventory application I'm writing for the company I work for
and realized the path for the Access database might reside on a network
drive. I have used Microsoft's Add Data Source method of adding the db
to the app. How could I customize this so the path can be changed. I
found that the connection is a ReadOnly property and cannot be changed.

Thanks,

Tony K

Jul 24 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2483
by: Ones Self | last post by:
Hi, I have a tree structure which is maintained through the use of a path enumerated column: CREATE TABLE items ( item_id NUMERIC NOT NULL, path VARCHAR2(64) NOT NULL );
1
2562
by: Ramesh | last post by:
hi, I am selecting fields from three table for manupulating data and i want to display total number of records selected. But i am always getting -1 value, eventhough 1000 of records are selected. Below is my code. here strSelectSQL value is strSelectSQL = "Select emp.Empno, emp.FirstName, emp.LastName, emp.DB, emp.DOJ,emp.Grade,emp.yearofexperience,
6
2055
by: aaj | last post by:
Hi all I use a data adapter to read numerous tables in to a dataset. The dataset holds tables which in turn holds full details of the records i.e. keys, extra colums etc.. In some cases I need to use parts of the tables in datagrids, and here is where my problem lies
3
15719
by: larry mckay | last post by:
anyone have the code to select and listview item or row (subitems) after a doubleclick event from a listview. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
6
2001
by: rdemyan via AccessMonster.com | last post by:
I don't understand why I can get the following to work: ------------------------------------------------------------------------------ -- SELECT A.*, B.* FROM TableA AS A, TableA AS B IN 'C:\......' WHERE A.USER_ID = B.USER_ID; ------------------------------------------------------------------------------ --
3
1781
by: Mchine34 | last post by:
I have created an xslt that sorts the following xml on node: Path XSLT: <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" indent="yes"/> <xsl:template match="/"> <xsl:apply-templates/>
0
214
by: Tony K | last post by:
Hi all, I have an inventory application I'm writing for the company I work for and realized the path for the Access database might reside on a network drive. I have used Microsoft's Add Data Source method of adding the db to the app. How could I customize this so the path can be changed. I found that the connection is a ReadOnly property and cannot be changed. Thanks, Tony K
1
1269
by: sunny74 | last post by:
I am writing a ASP.NET 2.0 web based application in which I want the user to create & select a Folder using Windows Explorer.After the user creates and selects the folder, on pressing OK I should be able to get the PATH of the folder for storing in a database. The problem is that there is nothing like FolderBrowserDialog in WinForms which allows me to select a Folder and get its path. I got a good article in Code project but its written...
5
1755
by: hollyquinn | last post by:
Hi I am working with a web application where I am selecting values from a SQL Server 2005 database and then loading the values into different controls on my page. Most of the values load with no problem, except for those columns where the value of the selected row in the column could be a null. I get the following error message: The value for column 'COLUMN NAME' in table 'TABLE NAME' is DBNull. I've tried in my Sql select statement to...
0
8675
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9160
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8897
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7729
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6521
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3050
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2331
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.