Access 2000 to 2003 - Microsoft Access / VBA

Debbie

I have an application in Access 2000 with lots of code, ADO included.
I am getting a new machine with Office 2003. Is there anything I need
to know before converting the database?

Thanks.

Nov 13 '05 #1

Subscribe Reply

1123

Brad\(ey

"Debbie" <de***********@hotmail.com> wrote in message
news:4d**************************@posting.google.c om

I have an application in Access 2000 with lots of code, ADO included.
I am getting a new machine with Office 2003. Is there anything I need
to know before converting the database?

Thanks.

Problems I've encountered
- Stricter naming convensions (an A97 database I was converting for the
police has a field name [Applicant's ID]. Needless to say apostrophies
are no longer allowed). (In my opinion don't use spaces either).
- Running an A2000 database in A2003, conditional formatting no longer
worked properly
- By default you will get security warning messages on opening DBs. This
can be turned off on each individual PC. Else go buy yourself a digital
certificate to sign your DBs with.

ps. Convert to A2000 format... then users of A2000, A2002 and A2003 can
use your DB.
--
regards,

Bradley

Nov 13 '05 #2

Similar topics

2866

converting access db to mysql

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

Microsoft SQL Server

5728

Access 2003 Default File Format

by: Wayne Aprato | last post by:

I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...

Microsoft Access / VBA

2314

Access 2003 with a 2000 database

by: Jeff | last post by:

Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...

Microsoft Access / VBA

5251

Access 2000 vs. Access 2003

by: deko | last post by:

Is it possible to develop an Access app in Access 2003 that will run on Access 2000? Is it just a matter of selecting "Access 2000" from the Default File Format drop down list on the Advanced Tab...

Microsoft Access / VBA

2502

Create Access 2000 MDB from Access 2003

by: KEMDignam | last post by:

I have upgraded my computer to Access 2003, but I have not converted my databases since all of my clients still use Access 2000. I need to create a new MDB, but Access is telling me that I will...

Microsoft Access / VBA

4482

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...

Microsoft Access / VBA

3171

Created on Access 2003, but.......................

by: Mell via AccessMonster.com | last post by:

I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...

Microsoft Access / VBA

1743

VB and an Access 2003

by: Ecohouse | last post by:

I'm using VB and an Access 2003. The db was originally created in Access 2000, but the computer had to have things reinstalled and now has Access 2003. So I was wondering if there are any...

Microsoft Access / VBA

2308

Create Access 2003 db

by: banba_ca | last post by:

When I create a new db from the main Access window or thru Vb (set newdb = ...) I always end up with Access 2000 file format. I would like to get 2002 - 2003 file format. The reason is that when I...

Microsoft Access / VBA

2725

Access 2000 to 2003 conversion missing reference and freezing errors

by: NEWSGROUPS | last post by:

I am in the midst of trying to convert about 25 Access 2000 to Access 2003. The new environment consists of Office/Access 2003 and Outlook 2003. When converting the back ends I have no problems....

Microsoft Access / VBA

7207

What is ONU?

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

General

7095

Changing the language in Windows 10

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

Windows Server

7294

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

C / C++

7361

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

5026

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

Microsoft Access / VBA

3183

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

Networking - Hardware / Configuration

1523

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

C# / C Sharp

749

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

403

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

General