472,328 Members | 1,168 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

Moving to Access 2007

I have an old database which started out life in the Access 2 days!
It's full of lots of stuff which I'm not convinced is relevant any
longer. Would a good way forward be to create a new, blank database in
Access 2007 and then import the existing objects, re-create the
relationships etc? That way I can just bring in the stuff that's
currently in use and, hopefully, have a better chance of avoiding
database corruption. The alternative, I suppose, is to convert the
whole database and then delete the unwanted objects but the former
seems a cleaner approach
Dec 20 '07 #1
2 1561
Yes: importing the A2 stuff into a new (blank) database could be a good
idea.

It gives you much finer control over what's going on. If there are problems
(e.g. a corrupt form), importing the other stuff is probably the only way to
do it.

Unless you have reason to suspect problems with the relationships or
duplicated indexes, you can import those. Access does that by default. (You
do have to redesign the Relationships Window layout, of course.)

Some of the code could need updating. If you have gone to other versions
after 2, it may be using the Compatibility Layer. This kind of thing is not
difficult to replace. If it has only ever been in Access 2, you may need to
update some 16-bit things (e.g. API calls.)

You may find that the Seed of the AutoNumbers has gone haywire after
importing. If so, this code will loop through the tables and fix it for you:
http://allenbrowne.com/ser-40.html

Other suggestions on updating from Access 1/2:
http://allenbrowne.com/gotcha27.html
or from Access 97:
http://allenbrowne.com/ser-48.html
and info about the changes to adjust to in Access 2007:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"anthony" <an*************@gmail.comwrote in message
news:3a**********************************@y5g2000h sf.googlegroups.com...
>I have an old database which started out life in the Access 2 days!
It's full of lots of stuff which I'm not convinced is relevant any
longer. Would a good way forward be to create a new, blank database in
Access 2007 and then import the existing objects, re-create the
relationships etc? That way I can just bring in the stuff that's
currently in use and, hopefully, have a better chance of avoiding
database corruption. The alternative, I suppose, is to convert the
whole database and then delete the unwanted objects but the former
seems a cleaner approach
Dec 20 '07 #2
Many thanks, as always
Dec 20 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

27
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that...
4
by: mrouleau | last post by:
I am sorry if this is the wrong group to ask, if so please point me in the correct direction. My problem is I have an MDB file with user-level...
7
by: bwmiller16 | last post by:
Folks - DB2 V9.2 on SUSE 9 Is there a way other than moving the entire /sqllib/db2dump/ (Default database path (DFTDBPATH) = /home/db2inst1...
0
by: jvitti | last post by:
I recently upgraded from Access 2000 to Access 2007 and I am having trouble with moving the focus from 1 form to another. While doing data entry...
1
prn
by: prn | last post by:
Hi folks, I'm relatively new to Access, but I seem to have drawn the short straw, so I have the assignment for my workplace of looking for...
17
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file....
224
by: Jon Slaughter | last post by:
Sorry for all the cross posting but I'm interesting in getting a serious discussion about how usenet has become lately. Many people are moving...
2
by: arthur.dayton | last post by:
I am using Access 2007. I'm trying to set the control on a subform to the current time. My code is: Private Sub Command7_Click() With Me....
0
by: SuzK | last post by:
I am trying to calculate in VBA in Access 2002 a moving average and update a table with the calculations. Fields in my WeeklyData table are Week...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.