473,382 Members | 1,204 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

converting a 97 database to 2003

When I converted a database yesterday I noticed one little thing I had
not seen before.
Any fields on the forms that were visible=no became visible = yes
after the conversion..

Is there any other little things like this that come up that I have
not thought of?

thank you for any info about this

Jerry

Jul 13 '06 #1
2 1320
Jerry, the converter sometimes makes mistakes. On rare occasions, I have
seen it convert a text box into a label. Naturally, the converted form was
unusable, as Access had no idea how to handle a label with a Control Source.

For a list of other issues, see:
Converting from Access 97 to Access 2000 and later
at:
http://allenbrowne.com/ser-48.html

The article covers setup issues, conversion issues, and usability issues.

--
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.

"sparks" <js******@swbell.netwrote in message
news:up********************************@4ax.com...
When I converted a database yesterday I noticed one little thing I had
not seen before.
Any fields on the forms that were visible=no became visible = yes
after the conversion..

Is there any other little things like this that come up that I have
not thought of?

thank you for any info about this

Jerry

Jul 14 '06 #2
On Fri, 14 Jul 2006 12:42:01 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:
>Jerry, the converter sometimes makes mistakes. On rare occasions, I have
seen it convert a text box into a label. Naturally, the converted form was
unusable, as Access had no idea how to handle a label with a Control Source.

For a list of other issues, see:
Converting from Access 97 to Access 2000 and later
at:
http://allenbrowne.com/ser-48.html

The article covers setup issues, conversion issues, and usability issues.
well I have been very happy with the conversions and to have it set
all visible was a minor thing but it surprised me. So I had to ask if
there were other things that I should look out for since it didn't
show any errors on conversion.

Big thanks for the link I will have to read up some more.

its those things that dont give errors that scare me

but then I did c++ programming and one syntax error is 103 errors in
the debugger.
no errors means I messed up LOL

Jerry

Jul 14 '06 #3

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

Similar topics

17
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...
2
by: John Ortt | last post by:
Hi All, I have a database in Access 97 which works fine but our company is converting from NT4 to XP Pro and in the process changing Office 97 for Office 2003. I have tried to convert the 97...
3
by: Dave | last post by:
Hi, I wrote a VBA program to read and process data from an ODBC source and put it into an Access database. I want to make the program into an MDE file and run it on systems with Access 2003. ...
2
by: Christine.Misseri | last post by:
Hi all, I'm sure someone knows about this problem. I have an Access database designed in Access 2000, connected to an ORACLE 8i back end. On the ORACLE side I have stored procedures, triggers...
1
by: hadu | last post by:
What is the advantage of converting from MSaccess 2000 database to Msaccess 2003 database?
10
by: NEWSGROUPS | last post by:
I work for an organization that is migrating from Access 2000 to Access 2003. About 5 or 6 years ago we migrated from Access 97 to Access 2000 with no problem. Will I have trouble converting these...
1
LMHelper
by: LMHelper | last post by:
I am in the process of switching an Access Database that was originally designed in Access 97 and they need it to switch over to Access 2000-2003 Database Version. We have run into errors when...
12
LMHelper
by: LMHelper | last post by:
I am in the process of switching an Access Database that was originally designed in Access 97 and they need it to switch over to Access 2000-2003 Database Version. We have run into errors when moving...
1
by: murraystewart | last post by:
I have spent days building a database in access 2003 and the found it needs to run on Access 97, I did the conversion but the form is not opening with an error message "you loaded a form or report...
5
by: mjvm | last post by:
Hi, My database (Access 2003) is split with the back end on the server and each person with a front end that is linked. Over time the computers/laptops are being replaced and almost everyone is on...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.