To copy the entire database, exit Access and copy the file via Windows
Explorer. In Access, "Save As" is used to make copies of objects or to
convert objects within the current file, which isn't what you want.
In Access, a table only exists as an object within a larger database file so
*technically* you can only copy it to another database if you want to
maintain its original "tableness".
However, you can export the *contents* of a table into various formats,
including text file or an Excel file: select the table then File>Export, and
select a file format. One of the options in this dialog is .mdb, which
allows you to copy the table *into* another database.
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"Bernie" <(E-Mail Removed)> wrote in message
news:2DBD88A5-546F-49C9-B42D-(E-Mail Removed)...
> Hi Rick:
> I'd love to be able to do that but, for some reason the "save as" button
> in
> access doesn't work like the other office applications so I still don't
> know
> how to save the entire database. None of the help books discuss this so
> if
> you can help, I'd greatly appreciate it!
> THX!!!
>
> "Rick B" wrote:
>
>> Not sure about a table, but you could save the whole access database
>> file.
>>
>> --
>> Rick B
>>
>>
>>
>> "Bernie" <(E-Mail Removed)> wrote in message
>> news:37F67F8E-FEF8-4978-980B-(E-Mail Removed)...
>> >
>>
>>
>>
|
Similar Threads
