Create database in Access 2003 gets Access 2000 formatted DB

Susan Bricker

I just purchased a new PC that came with MS Office 2003 (Professional
Ed.). I opened MS Access 2003 and created a new database but it opened
with a "note in the window header bar" that says "Access 2000 File
Format".

1. Why did this happen?
2. Should I delete this database and start again?
3. I am not exactly sure what level of software the end user will be at
(I am creating this database for use by someone else), but I have been
assured that they have MS Access.

Did I do something wrong here? Suggestions, please.

Thanks, much.

Sueb

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #1

Subscribe Reply

2936

Scott McDaniel

No, you didn't do anything wrong. The default format for 2002 and 2003 is
2000. You can change it if you want by clicking Tools - Database Utilities -
Convert. It would be a REALLY good idea if you would learn more about your
enduser environment. There have, of course, been changes since 2000, and if
your enduser is going to be using 2000 you would have to maintain the 2000
format, and make SURE you didn't use a 2002-2003 specific items (like the
FileDialog, for example).
"Susan Bricker" <sl*****@verizo n.net> wrote in message
news:42******** **@127.0.0.1...

I just purchased a new PC that came with MS Office 2003 (Professional
Ed.). I opened MS Access 2003 and created a new database but it opened
with a "note in the window header bar" that says "Access 2000 File
Format".

1. Why did this happen?
2. Should I delete this database and start again?
3. I am not exactly sure what level of software the end user will be at
(I am creating this database for use by someone else), but I have been
assured that they have MS Access.

Did I do something wrong here? Suggestions, please.

Thanks, much.

Sueb

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #2

Mark

Following on from Scott's advice, you can set access to create new databases
in 2002 format by clicking on tools - options - advanced and select which
ever format as the default.

Mark

"Scott McDaniel" <scott@NO_SPAM_ HEREthedatabase place.net> wrote in message
news:nO******** ************@co mcast.com...
No, you didn't do anything wrong. The default format for 2002 and 2003 is
2000. You can change it if you want by clicking Tools - Database Utilities -
Convert. It would be a REALLY good idea if you would learn more about your
enduser environment. There have, of course, been changes since 2000, and if
your enduser is going to be using 2000 you would have to maintain the 2000
format, and make SURE you didn't use a 2002-2003 specific items (like the
FileDialog, for example).
"Susan Bricker" <sl*****@verizo n.net> wrote in message
news:42******** **@127.0.0.1...

I just purchased a new PC that came with MS Office 2003 (Professional
Ed.). I opened MS Access 2003 and created a new database but it opened
with a "note in the window header bar" that says "Access 2000 File
Format".

1. Why did this happen?
2. Should I delete this database and start again?
3. I am not exactly sure what level of software the end user will be at
(I am creating this database for use by someone else), but I have been
assured that they have MS Access.

Did I do something wrong here? Suggestions, please.

Thanks, much.

Sueb

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #3

Susan Bricker

Scott,

Thank you for the information ... and Yes, I am in the process of
finding out what environment the user will have (level of Windows and MS
Access). I was just trying to get a jump on the project.

While I have your attention ... could I ask another question?

I am getting a warning concerning Macro security. I understand that is
due to the level of security that is set (currently set to Medium). How
crucial is this setting if the project is only going to a single user
and it won't be on a server and no one else will be using it? Can I
safely reduce the security setting for Macros to Low?

Thanks.

Sue

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #4

Similar topics

13060

ORA-01503: Create controlfile failed

by: Shashikant Khandelwak | last post by:

Hi ! I am trying to install oracle 9i Standard edition on a windows 2000 SP4 machine. I get through the entire installation up to running the Database Configuration Assistant. While it tries to make the database, it gets to the "Creating and starting Oracle instance" stage, and then the errors start. I get: ORA-01503: CREATE CONTROLFILE failed. ORA-00205: error in identifying control file. check alertlog for more

Oracle Database

2137

Help Needed With Bizarre Database Behaviour In Access 2003

by: Wayne Aprato | last post by:

I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am seeing the following behaviour: Some of the fields on the continuous main form which is a list of jobs with their related details "flicker". While this is going on the form seems to function as it should and isn't locked up. If I click and hold...

Microsoft Access / VBA

488

429 – ActiveX can't create object

by: Alex Shirley | last post by:

Hi We have various machines with Windows 2000 Pro and Windows XP Pro. Note all machines have Office XP Pro installed + Outlook 2003. Server is Windows 2003 Server with Exchange 2003. Note that all machines have latest patches/service packs etc. We have a Microsoft Access 2002 database that sends out mails via MAPI.Session to Outlook 2003.

Microsoft Access / VBA

2334

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 database? Why you ask! A client has a 2000 database. Currently using 2000 runtime for most employees to work with database. A couple use 2003 to use database, no problems. They have a mix of versions of other products such as Word, Excel - 97,...

Microsoft Access / VBA

2527

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 have to convert the database to 2003 before it will make an MDB. What are my options? If I convert the database, I assume that Access 2000 and A2k runtime will no longer be able to read the MDE. Can I re-install A2k on my machine? Is there...

Microsoft Access / VBA

2345

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 try to link from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it can't find the table in the target (2000) database. And no, I can't convert on the fly. Any suggestoins would be appreciated. ....Banba

Microsoft Access / VBA

12438

Can Access create Word documents?

by: etuncer | last post by:

Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is this: can Access create the document and place it as an OLE object to the relevant table? Any help is greatly appreciated. Ricky

Microsoft Access / VBA

5702

'you do not have exclusive access to the database...'

by: Zippy | last post by:

I recently updated one of my clients from Access 97 front-end to Access 2003. (Database still in 97 format). They have about 5 networked PCs. On one of these PCs only, the user gets a warning message when logging in: 'you do not have exclusive access to the database at this time ... may not be able to save changes'. The message keeps on reappearing. If he hits ok about 30 times, it eventually goes away. Can someone help?

Microsoft Access / VBA

1535

Use Catalog.Create to make an earlier version .mdb

by: Tim Dunne | last post by:

I created an application in Access 2007. One of the features required by the client is to create an .mdb file with one table in it for their use (strange yes -- I provided alternate solutions, but their IT guy insists). I use adox and the following line of code to do this: cat.Create "Provider='Microsoft.Jet.OLEDB.4.0';" & _ "Data Source='" & strPath & "'" It works fine, but defaults to an access 2002-2003 format. I need the...

Microsoft Access / VBA

8888

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, 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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8752

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9401

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

9113

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

6702

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

4519

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

4784

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

2635

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

2157

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