how do you burn cd of old database

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

Guest

I got a new computer at work and one of my big databases did not get
transferred. I want to copy the database from the old computer onto a disc
and then download it to the new computer. The name of the file doesn't show
up when I do a search, yet I can find it manually and open it! The usual
way of moving a file to the Nero burner doesn't work for this particular
file. I also noticed that the Mail Merge in Word won't work with this file
anymore, although I have used it for years. Any suggestions? It is an
important customer prospect file and I have no way to reenter all the info
without a disc, short of printing it and starting over....I'd have to reenter
names and addresses or over 1000 prospects! HELP!!!
 
Access doesn't "Save As" an mdb file. If you want to put an Access
database on to a flash drive you close Access and go to My Computer or
Windows Explorer. Find the mdb file's icon and drag (or copy and paste)
it onto the drive's icon.

With a CD drive in Windows XP it's the same, except that you next have
to tell Windows to write the file to the CD.

You mentioned that the file was not found when you did a search. That
could be explained by the file's having been hidden. To cover that
possibility, right-click on the file's icon and select Properties. On
the General tab of the Properties dialog, make sure that "Hidden" is not
checked.

If you can't find the file's icon, open My Computer. Go to the Tools
menu, select Folder Options... and click on the View tab. Under Advanced
Settings, select "Show Hidden Files and Folders" and uncheck "Hide
extensions for known file types".
 
Thank you for the help John. I was finally able to copy the word docs to the
flash drive. Didn't seem to work to copy them to CD... I still can't figure
our how to copy the database. The only way I can find it is to go to my
recent documents in Access and open it from there. I can't find it anywhere
else, so it's not possible to drag and drop or even to copy and paste. I
tried the "properties" and it was not hidden
and the "Hide extensions for known file types" was already unchecked. I
just don't know what to do next. Any more ideas? I may be able to copy the
data with copy and paste but I need to copy the format as well. Thanks
again.
 
Once you've opened the database in Access, hit Ctrl-G, which takes you
to the Immediate pane of the VBA editor.

Type
?CurrentDB.Name
and the response should give you the name and location of the the mdb
file.
 
God Bless YOU JOHN!!! I found the path and now I should be able to save it
to a flash drive. I can't open the flash on this computer because I don't
have Microsoft Access on it (I'm on my home computer now) but I will try it
at work on Monday and I will let you know. At least now I know how to find
them! Thank you thank you!!!!

Do you also know how to copy an Outlook Express address book to a disc or
flash drive? If not, I can write them down and transfer manually....there
are only maybe 30 or so, but if you can help I would really appreciate it!!!
 
In Outlook Express, look on the File menu. There are Export and Import
items that you can use to transfer data via disk files.
 
Back
Top