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 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
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
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="|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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
);
|
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,
|
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
|
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!
|
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;
------------------------------------------------------------------------------
--
| |
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/>
|
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
|
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...
|
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...
|
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...
|
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...
| |
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,...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |