Re: Copy an entire database and paste to new database in Access 20

Tech-Archive recommends: Speed Up your PC by fixing your registry

Rather than try to use Copy/Paste, consider using an Append Query.

(and you have my curiosity up -- why are you taking data out of one table
and putting it into another? If the ONLY reason has to do with sorting, you
can't and won't be able to use a new table for that.)

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Chrystela" <Chrystela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23ACBE57-00CD-4769-95B1-AB65B42EF4EC@xxxxxxxxxxxxxxxx
No, I am sorry. I have a database with 3 tables in it. I need to sort and
delete in those tables to create a new table with that information, yet,
they
initial tables are read only. I was trying to copy an entire table of
information and paste it into a new database/table in order that I could
sort, delete, or what ever else I needed to do to get the end report
needed
from that data.
The table has 61191 records or lines in it. So, I certainly do not want to
manually do the above mentioned.
I hope that I am clear enough with what I am trying to do and I appreciate
your continued help.

"Jeff Boyce" wrote:

Sorry, I'm still not following.

The way I "copy" a database (by the way, this may be a terminology
issue --
in Access, a "database" is NOT a table, it is the entire .mdb file) is to
copy the .mdb file using Windows Explorer and paste it where I want it,
with
a new name, if necessary.

What are you doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Chrystela" <Chrystela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:496912D6-77C5-48E3-B205-24D925C6C8D7@xxxxxxxxxxxxxxxx
It is all in Access 2003. I receive no error message.
To copy; I highlighted the entire database and copied, then, in the new
database I highlighted the entire database and then pasted.

The problem is when I paste, the resulting database is only the size of
the
"new" database that I open. Therefore, I have less than a tenth of the
database that I am trying to copy and paste.

The new database does not expand to Accommodate the size of the paste.


"Jeff Boyce" wrote:

I may be missing something...

You have an old database in Access 2003 that works (read-only).

When you try to copy/paste, Access tells you that there's not enough
room
for it?!

Which version are you copying/pasting to?

How are you trying to copy/paste?

What error message/number do you receive, if any?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Chrystela" <Chrystela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FFBF7FCF-99B1-4D95-AB23-AD9C82FC0FF9@xxxxxxxxxxxxxxxx
I am trying to copy a very large database that is in read only in
Access
2003
and then paste that into a new database. The problem is that when I
open a
new database it is not large enough to hold the copy. Any
suggestions.








.

Relevant Pages

  • Re: duplicating database on 2nd dataset
    ... Why would your "second" database not need the same tables as ... Microsoft Office/Access MVP ... reports and queries), but insert new underlying tables - where the data is ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is this possible??
    ... "Jeff Boyce" wrote: ... all those disparate data sources would have to share common ... Microsoft Office/Access MVP ... a database that they can click on a client's ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is this possible??
    ... all those disparate data sources would have to share common ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... a database that they can click on a client's ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Copying the last record to a new record
    ... We could append this recordset as mytimestamp) to the database, sort the record source by mytimestamp descand move to the first record - that would get us to a copy of the last record as our new record. ... "Jeff Boyce" wrote: ... you're treating it as if it were a spreadsheet, ... >> Microsoft Office/Access MVP ...
    (microsoft.public.access.macros)
  • Re: Which the best option ?
    ... set up the tables so that there is something in common between the ... You have to tell the database ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)