I have a table with one field that ia a hyperlink to a pdf file that opens
a specific file.
Since these files are very big, I would need to change the hyperlink path,
so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is distributed in
several machines in several places (not connected) and in each machine the
CDROM drive have it's own letter (D: or E: ...).
But I still have another problem: I can find the CDROM drive from some code
that I copied somewhere, but what happens if the computer doesn't have a
CDROM drive? It can have only a DVD drive or a CD RW.
I think the best way to solve my problem should be to ask the user in what
drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.
Can anyone help me with code to perform this?
I don“t know enought VB for this.
Thanks in advance
Maria Joao 5 2350
Maria Joćo wrote: I have a table with one field that ia a hyperlink to a pdf file that opens a specific file. Since these files are very big, I would need to change the hyperlink path, so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is distributed in several machines in several places (not connected) and in each machine the CDROM drive have it's own letter (D: or E: ...).
But I still have another problem: I can find the CDROM drive from some code that I copied somewhere, but what happens if the computer doesn't have a CDROM drive? It can have only a DVD drive or a CD RW.
I think the best way to solve my problem should be to ask the user in what drive are the pdf files and then I would like all the hyperlinks re-directionated to the ney path.
Can anyone help me with code to perform this? I don“t know enought VB for this.
Thanks in advance
Maria Joao
Hi Maria,
how about storing only paths relative to the database in the table
(e.g. "\folder1\subfo lder1\file1.pdf ")
then get the databases directory via Application.Cur rentProject.Pat h
and sticking that in front of the relative path to get the complete path..
Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath it,
you can copy the whole shebang to wherever you wish..
Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..
Joerg
--
Joerg Glissmann
remove pants to reply.. :-)
Hi,
I think your idea should be the perfect solution, but I still have some
problems:
- If the DB is copied to the Hard drive, then the
Application.Cur rentProject.Pat h doesn't go to the CDRom.
- I could work only from the CD drive, but the database closes because of an
error. I f you can help me with this, I could work only from the CD and
everythig would be OK (except from some delay from working in a CDRom
drive).
Please help me whit this
Thanks in advance
Maria Joao
"Joerg Glissmann" <sp*******@glis smann.de> wrote in message
news:B43kc.2$i6 .222@psinet-eu-nl... Maria Joćo wrote: I have a table with one field that ia a hyperlink to a pdf file that
opens a specific file. Since these files are very big, I would need to change the hyperlink
path, so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is distributed
in several machines in several places (not connected) and in each machine
the CDROM drive have it's own letter (D: or E: ...).
But I still have another problem: I can find the CDROM drive from some
code that I copied somewhere, but what happens if the computer doesn't have a CDROM drive? It can have only a DVD drive or a CD RW.
I think the best way to solve my problem should be to ask the user in
what drive are the pdf files and then I would like all the hyperlinks re-directionated to the ney path.
Can anyone help me with code to perform this? I don“t know enought VB for this.
Thanks in advance
Maria Joao
Hi Maria,
how about storing only paths relative to the database in the table (e.g. "\folder1\subfo lder1\file1.pdf ") then get the databases directory via Application.Cur rentProject.Pat h and sticking that in front of the relative path to get the complete path..
Advantage: as long as the database is in the root folder of your application and the data files reside in the correct folder underneath it, you can copy the whole shebang to wherever you wish..
Disadvantage: If you intend to distribute the whole thing via CD, people need to copy it to their hard disk first (and maybe remove the write protection on the file) to alter any table entries.
Just my 2ct..
Joerg
-- Joerg Glissmann remove pants to reply.. :-)
Hey Maria,
Application.Cur rentProject.Pat h gives you the current path where the Access
application sits, so it's no wonder it doesn't change to the CDROM drive...
(My suggestion was to copy the application including the data files to the
hard disk, but of course that takes a lot of space..)
I feared that the database has a problem when you run it off a write
protected medium (i.e. CDROM).
I found a hint at googling for the problem: http://support.microsoft.com:80/supp...180766&SD=MSKB
(also referenced at http://www.kbalertz.com/Feedback_180766.aspx )
Which gives you a sample code that returns the first CDROM drive letter.
(Don't worry, you only have to copy & paste the first gray area, the second
one with the rather few lines show how to use it..)
Hope that helps,
Joerg
Maria Joćo wrote: Hi,
I think your idea should be the perfect solution, but I still have some problems:
- If the DB is copied to the Hard drive, then the Application.Cur rentProject.Pat h doesn't go to the CDRom. - I could work only from the CD drive, but the database closes because of an error. I f you can help me with this, I could work only from the CD and everythig would be OK (except from some delay from working in a CDRom drive).
Please help me whit this
Thanks in advance
Maria Joao "Joerg Glissmann" <sp*******@glis smann.de> wrote in message news:B43kc.2$i6 .222@psinet-eu-nl...
Maria Joćo wrote:
I have a table with one field that ia a hyperlink to a pdf file that opens a specific file. Since these files are very big, I would need to change the hyperlink path, so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is distributed in several machines in several places (not connected) and in each machine the CDROM drive have it's own letter (D: or E: ...).
But I still have another problem: I can find the CDROM drive from some code that I copied somewhere, but what happens if the computer doesn't have a CDROM drive? It can have only a DVD drive or a CD RW.
I think the best way to solve my problem should be to ask the user in what drive are the pdf files and then I would like all the hyperlinks re-directionated to the ney path.
Can anyone help me with code to perform this? I don“t know enought VB for this.
Thanks in advance
Maria Joao
Hi Maria,
how about storing only paths relative to the database in the table (e.g. "\folder1\subfo lder1\file1.pdf ") then get the databases directory via Application.Cur rentProject.Pat h and sticking that in front of the relative path to get the complete path..
Advantage: as long as the database is in the root folder of your application and the data files reside in the correct folder underneath it, you can copy the whole shebang to wherever you wish..
Disadvantag e: If you intend to distribute the whole thing via CD, people need to copy it to their hard disk first (and maybe remove the write protection on the file) to alter any table entries.
Just my 2ct..
Joerg
-- Joerg Glissmann remove pants to reply.. :-)
--
Joerg Glissmann
remove pants to reply.. :-)
Ok
But if the computer doesn't have a CDROM drive? It can have only a DVD drive
or a CD RW. Does this work properly? I don't have a machine to try this.
Thanks
Maria Joao
"Joerg Glissmann" <sp*******@glis smann.de> wrote in message
news:XK7kc.4$i6 .284@psinet-eu-nl... Hey Maria,
Application.Cur rentProject.Pat h gives you the current path where the
Access application sits, so it's no wonder it doesn't change to the CDROM
drive... (My suggestion was to copy the application including the data files to the hard disk, but of course that takes a lot of space..)
I feared that the database has a problem when you run it off a write protected medium (i.e. CDROM).
I found a hint at googling for the problem: http://support.microsoft.com:80/supp...180766&SD=MSKB (also referenced at http://www.kbalertz.com/Feedback_180766.aspx )
Which gives you a sample code that returns the first CDROM drive letter. (Don't worry, you only have to copy & paste the first gray area, the
second one with the rather few lines show how to use it..)
Hope that helps,
Joerg
Maria Joćo wrote:
Hi,
I think your idea should be the perfect solution, but I still have some problems:
- If the DB is copied to the Hard drive, then the Application.Cur rentProject.Pat h doesn't go to the CDRom. - I could work only from the CD drive, but the database closes because
of an error. I f you can help me with this, I could work only from the CD and everythig would be OK (except from some delay from working in a CDRom drive).
Please help me whit this
Thanks in advance
Maria Joao "Joerg Glissmann" <sp*******@glis smann.de> wrote in message news:B43kc.2$i6 .222@psinet-eu-nl...
Maria Joćo wrote:
I have a table with one field that ia a hyperlink to a pdf file that
opens
a specific file. Since these files are very big, I would need to change the hyperlink
path,
so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is
distributed in
several machines in several places (not connected) and in each machine
the
CDROM drive have it's own letter (D: or E: ...).
But I still have another problem: I can find the CDROM drive from some
code
that I copied somewhere, but what happens if the computer doesn't have
aCDROM drive? It can have only a DVD drive or a CD RW.
I think the best way to solve my problem should be to ask the user in
what
drive are the pdf files and then I would like all the hyperlinks re-directionated to the ney path.
Can anyone help me with code to perform this? I don“t know enought VB for this.
Thanks in advance
Maria Joao
Hi Maria,
how about storing only paths relative to the database in the table (e.g. "\folder1\subfo lder1\file1.pdf ") then get the databases directory via Application.Cur rentProject.Pat h and sticking that in front of the relative path to get the complete
path.. Advantage: as long as the database is in the root folder of your application and the data files reside in the correct folder underneath
it,you can copy the whole shebang to wherever you wish..
Disadvantag e: If you intend to distribute the whole thing via CD, people need to copy it to their hard disk first (and maybe remove the write protection on the file) to alter any table entries.
Just my 2ct..
Joerg
-- Joerg Glissmann remove pants to reply.. :-)
-- Joerg Glissmann remove pants to reply.. :-)
Hmm.. I would have to try that as well.. I'll have to leave that up to you.
Joerg
Maria Joćo wrote: Ok
But if the computer doesn't have a CDROM drive? It can have only a DVD drive or a CD RW. Does this work properly? I don't have a machine to try this.
Thanks
Maria Joao
"Joerg Glissmann" <sp*******@glis smann.de> wrote in message news:XK7kc.4$i6 .284@psinet-eu-nl...
Hey Maria,
Application.C urrentProject.P ath gives you the current path where the
Access
application sits, so it's no wonder it doesn't change to the CDROM
drive...
(My suggestion was to copy the application including the data files to the hard disk, but of course that takes a lot of space..)
I feared that the database has a problem when you run it off a write protected medium (i.e. CDROM).
I found a hint at googling for the problem:
http://support.microsoft.com:80/supp...180766&SD=MSKB
(also referenced at http://www.kbalertz.com/Feedback_180766.aspx )
Which gives you a sample code that returns the first CDROM drive letter. (Don't worry, you only have to copy & paste the first gray area, the
second
one with the rather few lines show how to use it..)
Hope that helps,
Joerg
Maria Joćo wrote:
Hi,
I think your idea should be the perfect solution, but I still have some problems:
- If the DB is copied to the Hard drive, then the Application. CurrentProject. Path doesn't go to the CDRom. - I could work only from the CD drive, but the database closes because of an error. I f you can help me with this, I could work only from the CD and everythig would be OK (except from some delay from working in a CDRom drive).
Please help me whit this
Thanks in advance
Maria Joao "Joerg Glissmann" <sp*******@glis smann.de> wrote in message news:B43kc.2 $i6.222@psinet-eu-nl...
Maria Joćo wrote:
>I have a table with one field that ia a hyperlink to a pdf file that
opens
>a specific file. >Since these files are very big, I would need to change the hyperlink
path,
>so that I could send the hyperlink to one CDROM. > >I can do this part, but my problem ist that this DataBase is distributed in
>several machines in several places (not connected) and in each machine
the
>CDROM drive have it's own letter (D: or E: ...). > >But I still have another problem: I can find the CDROM drive from some
code
>that I copied somewhere, but what happens if the computer doesn't have a CDROM drive? It can have only a DVD drive or a CD RW. > >I think the best way to solve my problem should be to ask the user in
what
>drive are the pdf files and then I would like all the hyperlinks >re-directionated to the ney path. > >Can anyone help me with code to perform this? >I don“t know enought VB for this. > >Thanks in advance > >Maria Joao >
Hi Maria,
how about storing only paths relative to the database in the table (e.g. "\folder1\subfo lder1\file1.pdf ") then get the databases directory via Application.Cur rentProject.Pat h and sticking that in front of the relative path to get the complete path.. Advantage : as long as the database is in the root folder of your applicati on and the data files reside in the correct folder underneath it, you can copy the whole shebang to wherever you wish..
Disadvantag e: If you intend to distribute the whole thing via CD, people need to copy it to their hard disk first (and maybe remove the write protectio n on the file) to alter any table entries.
Just my 2ct..
Joerg
-- Joerg Glissmann remove pants to reply.. :-)
-- Joerg Glissmann remove pants to reply.. :-)
--
Joerg Glissmann
remove pants to reply.. :-) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Maria Joćo |
last post by:
I have a table with one field that ia a hyperlink to a pdf file that opens
a specific file.
Since these files are very big, I would need to change the hyperlink path,
so that I could send the hyperlink to one CDROM.
I can do this part, but my problem ist that this DataBase is distributed in
several machines in several places (not connected) and in each machine the
CDROM drive have it's own letter (D: or E: ...).
But I still have...
|
by: hecsan07 |
last post by:
I am a novice programmer.
I want to have a hyperlink that looks like so: www.mycoolsite.com?a=21132.
On click I want to extract the query string and use it to query a table
within a DB (SQL Server). The stored procedure takes the query string as a
parameter and returns the actual URL the page is going to be redirectted. I
can do this using a button, but I have done little work with ASP.NET
hyperlinks. I've never used a link to query a DB...
|
by: serge calderara |
last post by:
Dear all,
I have a label control on a form for which the .Text property is update from
a dataset field.
Then on the same page I have place an Hyperlink control fore which when
click, it jump to an url with the lable.Text property as parameter
For that I have done it as follow :
</asp:label><asp:label id="lblReelId" runat="server" </asp:label>
|
by: serge calderara |
last post by:
Dear all,
I have the following item on my form :
<asp:HyperLink id="lblEvtNb" runat="server"
NavigateUrl="Event.aspx?id=">Click here</asp:HyperLink>
I need to pass as url parameter an Id which is a label.Text string of my form
At the end the url should be : "Event.aspx?Id=32"
|
by: SAL |
last post by:
Has anyone worked with the System.Web.UI.WebControls.HyperLink? I am trying
to find examples on how to use it.
What I am trying to do is assign a Hyperlink to a document (i.e. .doc, .pdf,
..txt, etc.) programmatically. I am using VB.net, and ASP.net in VS.net 2003
with Framework 1.1.
Right now, I have a DBGrid on a ASP.net page that displays documents and
checkboxes for each row displayed. If a user checks one or more of these...
| |
by: Chris |
last post by:
I have an access database that we share on a public drive. Also there
is a folder in the same drive that has PDF documents. On my computer, I
can pull up the PDF document off the hyperlink but on my friends PC,
when you click the hyperlink, it flickers and the PDF file doesn't
load. Any advice from the Pros would be helpful.
Chris
|
by: David Thielen |
last post by:
Hi;
I have help html pages for each page of my ASP.NET webapp. So for the page
datasource.aspx, I have help\datasource.htm.
Bu what I want when the hyperlink is clicked, for it to look for the
following files in order (assuming I am running from the us):
help\datasource_en_US.htm
help\datasource_en.htm
help\datasource.htm
|
by: Zippy |
last post by:
I've been using the hyperlink base in A97 healthily and happily for some
time.
I'm now trying to do the same in A2003 and having problems:
If I set the hyperlink base to c:\temp and link in 'c:\temp\myfile.doc',
it saves 'temp\myfile.doc' as the hyperlink, instead of just the
filename. Then, of course, when it tries to open it, it cannot find the
file 'c:\temp\temp\myfile'
What's this supposed to mean? Must the hyperlink base be...
|
by: ssmeshack |
last post by:
Hai all,
Im having problem to set minimum height to <td> tag. It only takes height only not min-height. Im ie7 browser and developing web based system in Visual Web Deveploper 2008 (C# .Net).
Here is the entire code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="_Default" %>
<%@ Register TagName="Ticket" Src="~/UserControl/Ticket.ascx" TagPrefix="uc1" %>
<%@ Register TagName="User"...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |