how do I copy and rename a database in Access

[Guest]

I have staretd a new job and my boss has unexpected maternity leave with
complications...it's a new year and I wasn't thinkingand kept adding 2007
stuff in 2006 database. I need to copy 2006, rename and delete what I don't
need...it will let me copy and rename but when I try to open form it won't
let me...I acn open teh table but it's linking I guess to 2006. I am not
Access savvy but want my boss to think I can handle this while she is
out...can someone help please. How to copy and rename a database for new
year? Thanks

 

[Jeff Boyce]

"...copy and rename a database..."?

Do you mean you have an Access table that holds 2006 data, and you want
another table to hold 2007 data? (this is NOT a good use of Access, rather
more like what you'd do with a spreadsheet)

Do you mean you have an Access database (EVERYTHING, not just the tables)
that you want to copy and rename?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Joseph Meehan]

I have staretd a new job and my boss has unexpected maternity leave
with complications...it's a new year and I wasn't thinkingand kept
adding 2007 stuff in 2006 database. I need to copy 2006, rename and
delete what I don't need...it will let me copy and rename but when I
try to open form it won't let me...I acn open teh table but it's
linking I guess to 2006. I am not Access savvy but want my boss to
think I can handle this while she is out...can someone help please.
How to copy and rename a database for new year? Thanks

Access can hold a lot of data, like two gigs.

It is almost always preferred to keep all the data in one database and
one table. In your case you would likely want to add a "Year" field (Don't
call it year, that can get confusing.) and add the year 2006 or 2007 to it.
If there already is a date field that has an appropriate date, that will do.

Then you filter the data to include only the current year. You can do
filtering in forms, reports and queries. The other data is always right
there, but hidden to most users.