#### update paths when files are moved

I am using access to keep a database to track projects that my company
is working on. I have a number of tables, including
ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
paths of all of the important files for each project. ProjectFiles is
a child to ProjectDescriptions, holding the paths of a number of files
for each project.

Files often get moved around apart from the database - my question is,
is there a way to link the files to the [paths] field in ProjectFiles
so that if a file gets moved manually it automatically updates
the .mdb file? What other solutions would there be to this problem?

Thanks,
Bigrabid


 0
Bigrabid
4/26/2007 3:00:37 PM
access 16762 articles. 3 followers.

2 Replies
418 Views

Similar Articles

[PageSpeed] 40

On Apr 26, 10:00 am, Bigrabid <jwbac...@gmail.com> wrote:
> I am using access to keep a database to track projects that my company
> is working on. I have a number of tables, including
> ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
> paths of all of the important files for each project. ProjectFiles is
> a child to ProjectDescriptions, holding the paths of a number of files
> for each project.
>
> Files often get moved around apart from the database - my question is,
> is there a way to link the files to the [paths] field in ProjectFiles
> so that if a file gets moved manually it automatically updates
> the .mdb file? What other solutions would there be to this problem?
>
> Thanks,
> Bigrabid


 0
Bigrabid
4/27/2007 4:23:48 PM
On 26 Apr 2007 08:00:37 -0700, Bigrabid <jwbackes@gmail.com> wrote:

>I am using access to keep a database to track projects that my company
>is working on. I have a number of tables, including
>ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
>paths of all of the important files for each project. ProjectFiles is
>a child to ProjectDescriptions, holding the paths of a number of files
>for each project.
>
>Files often get moved around apart from the database - my question is,
>is there a way to link the files to the [paths] field in ProjectFiles
>so that if a file gets moved manually it automatically updates
>the .mdb file? What other solutions would there be to this problem?
>
>Thanks,
>Bigrabid

I'm not visualizing this, I guess. Do you want Windows Explorer, or DOS, or
any of the myriad tools someone could use to move files to open your database
and update the table? If so, then no, there's no way.

John W. Vinson [MVP]

 0
John
4/27/2007 5:45:28 PM

Similar Artilces:

Update for MS Money 2005?
I have Money 2005. Is there an update to MS Money for Canadian users? Thanks in advance for any answers. We need a bit more information! Are you having problems with M2005 or is this just a post-Christmas/New Year random query when you are trying to get away from the in-laws? -- Regards Bob Peel, Microsoft MVP - Money For unofficial FAQs see http://money.mvps.org/ or http://umpmfaq.info/ I do not respond to any emails that I have not specifically asked for. "Daniel" <Daniel@discussions.microsoft.com> wrote in message news:E86EAB89-21DE-4505-ACAD-647278D736BD@microso...

updating sheets based on data in first sheet
Another payroll question, I have a workbook that contains 26 sheets, one for each bi-weekl payroll period. I would like to set it up so when i add a new employe the rest of the sheets also update automatically with that employee name and information. I have been able to acheive this to a limited degree using th =sheet1!a1 formula, but this only updates the info in the first cel and particularly the first column. I would like to acheive this using the first sheet, since at th end of the year I would like to be able to calculate ytd figure easily. Thank -- Message posted from http://www.Exc...

Problem with Script Updating
I am using a script to update the “1099 Type” field for Master Vendor table. The script basically is a basic if-then statement. This script is run “Before Document Commit” and it’s not updating correctly, its flip-flopping the results. When the script is set to run Before Document Commit I have the “Destination mapping” field “1099 Type” set to “Use Script”. Script below: If SourceFields("Send 1099") = "N" Then DestinationFields("Options.1099 Type").Value = 1 Else DestinationFields("Options.1099 Type").Value = 4 End If I have also tried this s...

Publisher 2007 and Microsoft Updates
I created a newsletter yesterday - everything fine - use Publisher all the time. Then an automatic update came down this morning and I can't open the file - it says "Publisher cannot open file" Other documents in Publisher are opening - any ideas? http://support.microsoft.com/kb/972566/ -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Kim" <Kim@discussions.microsoft.com> wrote in message news:8754339B-99DC-4D09-83AD-6B34D8215274@microsoft.com... >I created a newsletter yesterday - everythin...

Microsoft Update only updates Windows Defender

Outlook data file check
Hello, I am using Outlook 2007 on XPSP2. Quite often on startup I get a message the Outlook is doing a file check and performance may be slow. I also often get on computer startup a message requesting me to send an error report to Microsoft that includes a few episodes of Outlook not responding. Any idea what this could be about and how to prevent both? -- Thanks, Bob ...

Backing Up Money Files
Do any versions of Money allow backing up data to cds, rather than floppy discs? All of them allow it in the sense that they don't prevent or preclude it. None of them allow it in the sense of enabling it by providing their own CD burning engine. See http://www.bollar.org/msmoney/#Q51 for the FAQs treatment of this incredibly FAQ. "Wade" <wstarl@bellsouth.net> wrote in message news:083201c38627$333d0770$a401280a@phx.gbl... > Do any versions of Money allow backing up data to cds, > rather than floppy discs? A good strategy would be to back up to second hard disk,...

Update question
Soory if this is the wrong place to ask this, but cannot find a NG proper to Windows 7. I currently run Windows Vista and am getting tired of Vista's decision to tell me that it is going to shut down in less than a minute. So have decided to upgrade to Windows &. I note that I can purchase an upgrade versiom for 64 quid from Amazon or an apparently full version of Windows 7 Home premium for 89 quid. My question is this - If I buy the upgrade version will I only be able to load it on a new PC in the future if I already have windows Vista installed? i.e For any future cl...

Outlook 2003 died mysteriously after update
Setup in a nutshell... System: Lenovo T500 laptop OS: Vista Business SP1 32-bit Software: Office Outlook 2003 SP3 Problem... So I'm using this setup for over a year, everything OK. Yesterday I did two things and now Outlook dies (quietly, sans error message) immediately after startup. It show the splash screen, displays my inbox, and *poof* disappears. What I did earlier... 1. Windows Update installed: KB9766662, KB979306, KB979099, KB975929 2. At the same time, while searching for another program to uninstall I stumbled upon (and uninstalled) Windows LIVE Toolbar and...

Lost File Share
Before 15 January, I had 2 PC's set to share a calendar (via email). However, on 15 January, one of the PC's received the following message: "Oulook caused invalid page fault in module fldpub.dll at 015f:4c51a697". I went to the support page and printed the resolutions for that error. However, since then, the calendar does not share. How can I share (via email) again? Thanks, Best International Sales ...

Save excel file as text file with ; as separator
Dear Sir I change the list separator(under control panel) from " , " to " ; " in win2000 and winxp. I write macro that will save the excel file as text file with ';' separator but the result is still a ',' but this program can work on win98. The coding is as below Worksheets("ProdPrice").Activat Cells.Selec Selection.Cop Workbooks.Ad Windows("Book1").Activat Range("A1").Activat ActiveSheet.Past ChDir "C:\ ActiveWorkbook.SaveAs Filename:="C:\ClientInfo\Prodprice.txt", FileFormat:=xlCSV, CreateBackup:=Fals Windo...

Pasted image file property inspector???
Hi, In a process of answering a request for proposal, our team worked over night writing down the answer in Word, pasting images here and there. The .doc file is now so big that it is almost impossible to send it by mail. Of course we made a pdf but for archiving in our knowledge base (.doc format for latter use) I really need to get its file size down. I know that we pasted things with a not appropriate format/resolution. Do you know a way to simply display in a palette pasted image file property (size and type) This would help finding the ones needing optimization. Is there such plug-in...

Linking Workbooks and minimising file sizes
Spec: presently have a "user" workbook of about 70 worksheets. this will be sent to managers. Am trying to make a Rough Work worksheet which will contain all raw data needed for calculations in the "user" workbook. I dont want the managers to see/receive the "Rough Work" file. E.G. Monthly figs in rough work sheet are used to calculated "% of work acheived this year" in the user workbook. Problem: 1) how do i link the data AND keep file size down?? 2) how can i split up the "user" workbook into manageable chunks which can, for example...

How update entity in post update?
I created a handler for Update post callout for Opportunity. I want update some fields of the opportunity on the PostUpdate. However, if I call the Update method of CRMOpportunity in the PostUpdate I will create a recursive post callout. Can somebody help me? Thank you for pay attention []'s Vin�cius Pitta Lima de Ara�jo You need to check the OrigObjectXML field to see what fields were updated and then act appropriately. Matt Parks MVP - Microsoft CRM ---------------------------------------- ---------------------------------------- On Wed, 4 Aug 2004 17:43:17 -0300, "Vin�cius ...

Cannot install update KB979906 for .NET Framework 1.1 SP1
Running : Windows XP media center edition SP3 Have tried installing KB979906 a few times and also downloaded update manually but cannot install this update. Receiving error 0x643.Is it safe to uninstall the .NET Framework 1.1 and re-install as possibly corrupt , without having to uninstall/re-install all other .NET frameworks 2 , 3 and 3.5 including the updates that go with them? .. Hello sherlockomes, you might want to look at the following kb article to see if this will help with the error 80070643. <http://windows.microsoft.com/en-US/windows-vista/Windows-Update-error...

file exist
hi, what is the command to check if file exist ? thanks. Lior Montia wrote: > hi, > > what is the command to check if file exist ? > > thanks. Dir("path to file") It will return the name of the file if it exists and "" if it does not. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com "Lior Montia" <liorm@matrix.co.il> wrote in message news:f053kh$edi$1@news2.netvision.net.il... > hi, > > what is the command to check if file exist ? > > thanks. > > Dir() will...

Preferred file group
Our application records transactional events (maybe 300K to 500K rows per day) on a separate file group called HISTORY. I was wondering if there are performance considerations when creating indices on this history table. That is, do I get a performance improvement if the index resides in the default file group or if it resides in my HISTORY file group. Thanks in advance, Gary Hi ary, You can create a seprate file for the indexes, that would help as the index read/writes would be from a seperate file. Sriram www.sqllike.com > Our application records transactional event...

Getting path from the full path and file name
Hello again, This is my second question today. The question is how to get just the path info from a string that contains path and file name information. I am looking an MFC or WinAPI function to do that because I don't want to do it manually. Thanks, "msnews.microsoft.com" <fwr> schrieb im Newsbeitrag = news:uzyJa\$q1DHA.1700@TK2MSFTNGP12.phx.gbl... : Hello again, :=20 : This is my second question today. The question is how to get just the = path : info from a string that contains path and file name information. I am : looking an MFC or WinAPI function to do that becaus...

latest update too MSCFV2
Hi, I have MSCFV2 version 6.5.7825.0. Could someone inform me if this is the latest download? Looks like you have 6.5.7825.0 from 05/21/2006, but there is a newer version - 6.5.7831.0 from 06/01/2006. C. Smith Enso Technologies, Incorporated http://www.ensotech.com On Tue, 13 Jun 2006 04:25:02 -0700, Paul <Paul@discussions.microsoft.com> wrote: >Hi, > >I have MSCFV2 version 6.5.7825.0. Could someone inform me if this is the >latest download? Christopher Smith csmith@ensotech.com Enso Technologies, Incorporated http://www.ensotech.com Also - meant to post this in t...

Print record once, update Yes/No field verifiying print
I would like to print a group of records, then have a Yes/No field [Printed] updated in my Jobs table with an update query showing the records were printed. Then next time the report runs, In my query criteria I will test for True values on the Yes/No field. Then only the records with the Yes/No field marked No will print. Any suggestions? Thanks Tommyboy,there's more to this question than meets the eye. For an explanation of what's involved, see: Has the record been printed? at: http://allenbrowne.com/ser-72.html The article includes a free sample database that dem...