Changing Drive letters

[Gil, Not the Fish]

I have a Payroll program I wrote and customized just for me, a bookkeeper.
My files got pretty large so I wanted to put some on CD's, like every 3
months worth, to speed up the application. I created a blank database and
copied the tables into it and then copied them to CD; all went well; I can
open the database on the CD and the tables are there. I planned on
retreiving just the table I need to look up something but I can't seem to
access the table; I keep getting an error message. I only need read-only
access because I just want them for reference. Using DAO I tried this:
DoCmd.CopyObject , "Hourly Benefits", acTable, "D:\Payroll.mdb"
Which I want to copy the Hourly Benefits table to the current database so my
application programs can look at whatever data I want to see, like # of days
a person took for sick or vac. I've read the Access & VB Help about the
Drive Prpoperty and I'm not sure if I need to set up the drive b/4 I can use
it?? As many of you have said, the Help can be not too helpful. Can you
help me figure this out. Thanx I'm using 2003

 

[Klatuu]

Instead of importing, try linking. You probably don't want to keep them in
your current database after you are done with them anyway.