473,561 Members | 3,144 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Upgrading a databse to ms access 2007? Help

Hi
I need help. I have a ms access 2003 database that I would like to
upgrade to ms access 2007. The first time I opened I had to fix a few
references it wanted a DAO2535.TLB file witch I gave it, and a
utility.mda file witch I think i gave it. The instructions on
Microsoft's web sight were not very clear where to put the utility.mda
so I am not sure if I have it at the right place. The Database does
not ask for it anymore.

I have tried to run it as a 2003 file and as a converted accdb file,
the problem is that I have a subform that is controlled by a query and
it only shows the first result instead of a list of results. The
strange part is when i start the program in the first few seconds it
show every thing but then the list disappears and only the first one
shows up. It all works fine with access 2003.

There are a bunch of other small bugs. It seam like it is slow to
refresh when switching tabs.

Am I wasting my time trying to make this thing work?
Is there some setting that I just don't have right?
Should I keep it as a mdb file or as a accdb?
Can any one help me?

This is just my hobby and right now I am frustrated!

Thanks
Clarence Wollman

Nov 1 '07 #1
3 7057
On Nov 1, 3:29 pm, cwoll <clarencewoll.. .@gmail.comwrot e:
Hi
I need help. I have a ms access 2003 database that I would like to
upgrade to ms access 2007. The first time I opened I had to fix a few
references it wanted a DAO2535.TLB file witch I gave it, and a
utility.mda file witch I think i gave it. The instructions on
Microsoft's web sight were not very clear where to put the utility.mda
so I am not sure if I have it at the right place. The Database does
not ask for it anymore.

I have tried to run it as a 2003 file and as a converted accdb file,
the problem is that I have a subform that is controlled by a query and
it only shows the first result instead of a list of results. The
strange part is when i start the program in the first few seconds it
show every thing but then the list disappears and only the first one
shows up. It all works fine with access 2003.

There are a bunch of other small bugs. It seam like it is slow to
refresh when switching tabs.

Am I wasting my time trying to make this thing work?
Is there some setting that I just don't have right?
Should I keep it as a mdb file or as a accdb?
Can any one help me?

This is just my hobby and right now I am frustrated!

Thanks
Clarence Wollman
I empathize as I have also tried to upgrade. My bosses were skeptical
when I told them of the serious bugs in 2007. I am still under a
mandate to upgrade, and will have to do so with experimentation to
find out what works and what doesn't. It hasn't been out long enough
for the needed bug-fixes and work-arounds to be published.
As to your particular problem, you haven't given enough details to
provide a clue as to why it isn't working. What kind of form is it?
What kind of control displays the data? Is the form and or control
linked directly to a table or query? Or is the data manipulation
taking place through code? Did all of the indexes and other
relationships of the suspect table show up in the new database?
In your case, I would recommend dumbing down the form until it starts
working... that should give you a clue of where to look to find the
problem.

Nov 1 '07 #2
On Nov 1, 3:22 pm, OldPro <rrossk...@sbcg lobal.netwrote:
On Nov 1, 3:29 pm, cwoll <clarencewoll.. .@gmail.comwrot e:
Hi
I need help. I have a ms access 2003 database that I would like to
upgrade to ms access 2007. The first time I opened I had to fix a few
references it wanted a DAO2535.TLB file witch I gave it, and a
utility.mda file witch I think i gave it. The instructions on
Microsoft's web sight were not very clear where to put the utility.mda
so I am not sure if I have it at the right place. The Database does
not ask for it anymore.
I have tried to run it as a 2003 file and as a converted accdb file,
the problem is that I have a subform that is controlled by a query and
it only shows the first result instead of a list of results. The
strange part is when i start the program in the first few seconds it
show every thing but then the list disappears and only the first one
shows up. It all works fine with access 2003.
There are a bunch of other small bugs. It seam like it is slow to
refresh when switching tabs.
Am I wasting my time trying to make this thing work?
Is there some setting that I just don't have right?
Should I keep it as a mdb file or as a accdb?
Can any one help me?
This is just my hobby and right now I am frustrated!
Thanks
Clarence Wollman

I empathize as I have also tried to upgrade. My bosses were skeptical
when I told them of the serious bugs in 2007. I am still under a
mandate to upgrade, and will have to do so with experimentation to
find out what works and what doesn't. It hasn't been out long enough
for the needed bug-fixes and work-arounds to be published.
As to your particular problem, you haven't given enough details to
provide a clue as to why it isn't working. What kind of form is it?
What kind of control displays the data? Is the form and or control
linked directly to a table or query? Or is the data manipulation
taking place through code? Did all of the indexes and other
relationships of the suspect table show up in the new database?
In your case, I would recommend dumbing down the form until it starts
working... that should give you a clue of where to look to find the
problem.
Yes that is part of my problem. There are so many things that don't
work right I don't know were to start. I am under pressur to make it
work in access 2007.

What I would really like is for someone to look at it and see what
they think.

All you input is appreciated!
Like I say I am not a Pro.
Clarence Wollman

Nov 1 '07 #3
On Thu, 01 Nov 2007 22:54:37 -0000, cwoll <cl************ *@gmail.com>
wrote:

If you want a professional to look at it, perhaps "Microsoft Solution
Provider" in your yellow pages is a good place to start.
DAO2535 is a very old library and should not be needed. Select DAO 3.6
and fix what does not compile (Code Window Debug Compile).
Same thing with Utility.mda. Unless you are one of the VERY few who
knows what that thing does, uncheck it and fix what is broke.

The choice of MDB or ACCDB should be made based on needed features. If
you just want (need?) to upgrade, stay with MDB. The last thing you
need is one more variable.
You know you can run A2003 files in A2007, right? I just question the
need to upgrade.

-Tom.
>On Nov 1, 3:22 pm, OldPro <rrossk...@sbcg lobal.netwrote:
>On Nov 1, 3:29 pm, cwoll <clarencewoll.. .@gmail.comwrot e:
Hi
I need help. I have a ms access 2003 database that I would like to
upgrade to ms access 2007. The first time I opened I had to fix a few
references it wanted a DAO2535.TLB file witch I gave it, and a
utility.mda file witch I think i gave it. The instructions on
Microsoft's web sight were not very clear where to put the utility.mda
so I am not sure if I have it at the right place. The Database does
not ask for it anymore.
I have tried to run it as a 2003 file and as a converted accdb file,
the problem is that I have a subform that is controlled by a query and
it only shows the first result instead of a list of results. The
strange part is when i start the program in the first few seconds it
show every thing but then the list disappears and only the first one
shows up. It all works fine with access 2003.
There are a bunch of other small bugs. It seam like it is slow to
refresh when switching tabs.
Am I wasting my time trying to make this thing work?
Is there some setting that I just don't have right?
Should I keep it as a mdb file or as a accdb?
Can any one help me?
This is just my hobby and right now I am frustrated!
Thanks
Clarence Wollman

I empathize as I have also tried to upgrade. My bosses were skeptical
when I told them of the serious bugs in 2007. I am still under a
mandate to upgrade, and will have to do so with experimentation to
find out what works and what doesn't. It hasn't been out long enough
for the needed bug-fixes and work-arounds to be published.
As to your particular problem, you haven't given enough details to
provide a clue as to why it isn't working. What kind of form is it?
What kind of control displays the data? Is the form and or control
linked directly to a table or query? Or is the data manipulation
taking place through code? Did all of the indexes and other
relationship s of the suspect table show up in the new database?
In your case, I would recommend dumbing down the form until it starts
working... that should give you a clue of where to look to find the
problem.

Yes that is part of my problem. There are so many things that don't
work right I don't know were to start. I am under pressur to make it
work in access 2007.

What I would really like is for someone to look at it and see what
they think.

All you input is appreciated!
Like I say I am not a Pro.
Clarence Wollman
Nov 2 '07 #4

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

Similar topics

13
2625
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine, but I would like to have all the office apps on the same version. So I have a few questions: 1) Is the file format the same as 2002? Can 2002...
0
1848
by: Klaus Herzberg | last post by:
Hallo, with a access-application i send reports via email/SendObject. After installing office 2007 beta the Sendobject doesn't work. Also after deinstalling office 2007. The error: 2046 "the command or action 'sendobject' isn't available now" Any ideas? thanks. klaus.
6
1597
by: JimLad | last post by:
Hi, We have a major ASP app that we are in the process of upgrading to ASP.NET 1.1 and probably on to ASP.NET 2.0 in the middle of next year. (We will also be upgrading to SQL2K5 at the same time). The current architecture is heavily based on the client side, both for validation and data access. The asp page is returned and then data is...
3
2248
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in...
14
2760
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in...
13
1424
by: pandathum | last post by:
Popping out of lurkdom for a moment. I've got a 2003 upgrade package here on my desk. Should I skip it and head straight to 2007? Thoughts? All the databases I'm supporting or writing are in 2000 format. I've kept an install of 97, just in case, but I think it may be safe to ditch it now. Tia
5
1574
by: Bobby | last post by:
Hi, I have an application which is written in Access 2003, with a SQL server 2000 back end. The application uses a lot of VBA, as well as quite a few macros. We are about to upgrade to Office 2007. What are the main issues I should look out for? Thanks for any help
3
1401
by: Lauren Quantrell | last post by:
I recently upgraded to SQL Server 2005 from SQL Server 2000, and Access 2007 from 2003. When I run a ADP created in Access 2000 (which worked fine in Access 2002 and 2003) in Access 2007 everything is fine, but when I go back and run it in Access 2000, all the sprocs are renamed: SprocName;1 (with ";1" added to each sproc name) so they are...
2
1958
by: Jiwei06xie | last post by:
Hi All, I am trying to upgrade an Access 2000 DB to 2007 (using linked tables and ODBC to connect to backend SQL 2000 database). In my DB, I have a mainswitch board and some command buttons on it. When I click the command button it should open another form to show some records. My problem is that some of the buttons work fine but some others...
0
7644
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7568
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7614
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...
0
7928
tracyyun
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...
0
6206
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5469
isladogs
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...
0
5185
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...
1
1180
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
892
bsmnconsultancy
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...

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.