PC Review


Reply
Thread Tools Rate Thread

Auto update from director info

 
 
Gary
Guest
Posts: n/a
 
      8th Jan 2008
Hello all,

I am trying to make a database of my karaoke songs to be able to print song
list request books.

Is there a way of using Access (2000 Premium) to automatically update its
records from a directory/file structure so every time a song is added,
deleted or changed in the MS Windows filw system access updates its records?

I store all my songs in this format:

c:\documents and settings\gary\my documents\my karaoke\ARTIST\ARTIST -
SONG (CDG).mp3

The only information I require from this is the ARTIST and SONG from the
file name to be stored in 2 MS Access fields that automatically update when I
open the access database.

I currently use a complicated method using Word and Excel that involves too
much manual work! (see:
http://www.microsoft.com:80/communit...a-c789c9f4d366)

Thank you in advance!
Gary
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refernce other files and auto update info Riptide Microsoft Excel Misc 1 13th Jan 2010 09:23 PM
Re: Export Active Director Info to csv file Paul Williams [MVP] Microsoft Windows 2000 Active Directory 3 14th Jan 2007 11:13 PM
Re: Export Active Director Info to csv file Len A Microsoft Windows 2000 Active Directory 0 10th Jan 2007 11:48 PM
Re: Export Active Director Info to csv file Ace Fekay [MVP] Microsoft Windows 2000 Active Directory 0 10th Jan 2007 04:13 PM
Auto Update Info from Different Sheets? silencebreaking Microsoft Excel Misc 3 12th Jun 2006 03:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:32 AM.