Moving to Access 2007 - Microsoft Access / VBA

anthony

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

Subscribe Reply

1659

Allen Browne

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.comwrot e in message
news:3a******** *************** ***********@y5g 2000hsf.googleg roups.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

anthony

Many thanks, as always

Dec 20 '07 #3

Similar topics

45539

Access 2007 Custom Menu Bars

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 comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access 2007 to open an Access 2003 database that has custom menu bars they display as they did in Access...

Microsoft Access / VBA

8557

Moving an MDB to Access 2007 with user-level security

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 security on it (mdw). When i move it over to a system that has Access 2007 and try to open it, I get a user name and password prompt. The admin username and password from the other system doesn't work. Is there anything special I need to do? If I could I would actually love to remove this...

Microsoft Access / VBA

4162

Moving STMMLOG to another location

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 to move just STMMLOG out of there to another location away from where it is? I'd like to either 1). Move STMMLOG without moving db2diag 2). Prohibit the making of the stmm.1.log file(s).

DB2 Database

1915

Moving focus from 1 form to another

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 if a similar claim is found the claim view form will open listing the similar claims. The data entry clerk can view 1 of the claims and by doubling clicking on the claim number some info from the claim view will be used to populate fields on the data entry screen. The following code is used...

Microsoft Access / VBA

11512

Access 2007 acwzmain acwztool

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 problems/inconsistencies in migrating applications to Access 2007 from previous versions. We don't have a lot of Access applications, but even a dozen or so can be an interesting challenge. I have loaded a few that were created in Access 2003 into Access 2007 and all of the ones I have tried have come up...

Microsoft Access / VBA

7659

Access 2007 Runtime on Machine With Older Version?

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. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my...

Microsoft Access / VBA

224

6398

Moving to new form of usenet ideas?

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 away from usenet because of all the spam and cooks that have been showing up. The rate of spammer seem to be growing exponentially(ok, not really but it feels like it). I think maybe its time to do something about it. What I'd like to see happen is an "upgrade" to usenet. I do not like th forum...

C / C++

6309

2007 and moving to last record on subform

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. ..Form.SetFocus ..Form!.SetFocus RunCommand acCmdRecordsGoToLast ..Form! = Now() End With

Microsoft Access / VBA

4633

Calculate a Moving Average and Update Table

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 Ending (date) ItemNbr (double) Sales Dollars (double) Sales Units (double) Promo (Text) -- is null or "X" AvgWklyDollars (double) AvgWklyUnits (double) I have a vba module which I thought would work, but it doesn't. I think the problem is an embedded SQL Totals Top 8 query, which doesn't...

Microsoft Access / VBA

8826

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8503

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6166

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4155

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4306

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General