View Single Post
  #8  
Old June 4th, 2007, 03:16 PM
ddouglass ddouglass is offline
Super Moderator
 
Join Date: Nov 2004
Location: Ace, TX (5 miles past Nowhere)
Posts: 9,395
Quote:
Originally Posted by gd123 View Post
Take the External Drive that you are using on the Laptop, which won't build right, and hook it to any other Computer.

When the Computer assigns a Drive Letter, change the Drive Letter to what your Laptop uses.

Build the DB.

Transfer the newly built Songs.MDB to the Laptop.

Now, the Drive letter in the Songs.Mdb will point to the correct External HD Path.

Or, you could disregard any Drive Letter that is assigned, by the Computer you are using to build your DB, and EDIT the Songs.MDB's Drive Letter, with MSAccess, to match what your Laptop uses.



MfgName




DiskID




Track




Duration




SongTitle




Artist




Path
X



BookID




Language




Genre




Duet




Multiplex




RecordID




Type






Edit the PATH Column and REPLACE THE DRIVE Letter:
< Current Drive Letter>
with

ex:
D:\MTU\1\DK098-16.kma
I:\MTU\1\DK098-16.kma

In the FIND field, use: D:\ <---whatever your Letter is
In the REPLACE field, use: I:\ <----To whatever you need it to be

In the MATCH field, use: START OF FIELD
GD123, I like your method with MSAccess, but you might want to point out for them NOT to convert the db when open it in newer versions of MSAccess.
__________________
Dale Douglass
2nd Generation Karaoke
I am not a member of the MTU Staff.
Reply With Quote