Changing Drive letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Instead of importing, try linking. You probably don't want to keep them in
your current database after you are done with them anyway.
 
Back
Top