Build Song Database Locks up Laptop

[ddouglass]

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.

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.