
June 4th, 2007, 03:16 PM
|
Super Moderator
|
|
Join Date: Nov 2004
Location: Ace, TX (5 miles past Nowhere)
Posts: 9,395
|
|
Quote:
Originally Posted by gd123
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.
|