Create Access 2003 db - Microsoft Access / VBA

banba_ca

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

Jan 18 '07 #1

Subscribe Reply

2334

'69 Camaro

Hi.

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.

Select the Tools -Options... menu, then select the "Advanced" tab. Change
the "Default File Format" from Access 2000 to Access 2002-2003 in the combo
box on the top right of the dialog window. Select the "OK" button to save
your change. New databases will be in the Access 2002-2003 database 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.

Something else is causing the problem, because Jet 4.0 (Access 2003) can
read Jet 4.0 (Access 2000 database format) files.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ba******@yahoo .comwrote in message
news:11******** *************@1 1g2000cwr.googl egroups.com...

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

Jan 18 '07 #2

Arno R

"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAMschreef in bericht news:UO******** *************** *******@adelphi a.com...

<snipped>
>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.
Something else is causing the problem, because Jet 4.0 (Access 2003) can
read Jet 4.0 (Access 2000 database format) files.

HTH.
Gunny

Not only Jet 4.0 Jet can also read and write earlier versions.
Access 2003 (and all earlier versions) can even link to Access 2.0 databases.

IME *every* Access version can link to *any other* earlier version.
(Don't know about Access 2007)

Arno R

Jan 19 '07 #3

Baz

Tools menu-->Options-->Advanced tab-->Default File Format

<ba******@yahoo .comwrote in message
news:11******** *************@1 1g2000cwr.googl egroups.com...

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

Jan 19 '07 #4

Similar topics

5709

Access Denied trying to create New Instantance of Object

by: Ian | last post by:

The beginning of my assembly that I am getting the access error from looks like this. ********************************* Imports System.EnterpriseServices Imports System Imports System.Collections Imports System.Configuration Imports System.Data Imports System.Data.Common Imports System.Reflection

.NET Framework

1760

Create Access 97 MDE from Access 2003

by: Ira S | last post by:

Any way to create an Access 97 MDE (programmatically) from within an Access 2003 application. I can do it from within my Access 97 adn when I do it from within my Access 2003 app it create a 2003 mde. Any way to force 97 from the 2003? Ira

Microsoft Access / VBA

2932

Create database in Access 2003 gets Access 2000 formatted DB

by: Susan Bricker | last post by:

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

Microsoft Access / VBA

2518

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

11102

ActiveX Component can't create object

by: Susan Bricker | last post by:

Hi. I have a routine (BldEmail) that is causing an error on my user's PC but not on mine. HELP!!! I have to fix this tonight. She reports an error with err.number=429 and the error message "ActiveX Component can't create object" out of my BldEmail routine. The routine is called to dynamically build an email note and put it in the Drafts folder. It uses late binding and has the following code: Dim objOutlook As Object

Microsoft Access / VBA

2298

Can't create New Proj. with XP/.NET 2003

by: Marc Miller | last post by:

Hi all, I have 2 dev. machines, the 1st is Win 2000 with .NET 7.0 and the 2nd is XP Pro with .NET 2003. My Web Server is Win 2000 Server with IIS 5.0. I can create a new project on my test server from the 1st machine, but I receive an 'HTTP/1.1 500 Internal Server error" from my Web Server. My userid/password are the same on all 3 machines.

ASP.NET

1521

Cannot create project in Windows Server 2003

by: Jack G | last post by:

I've been trying to create a new web application project in Visual Studio 2003 running on a Windows Server 2003. I get the message Window titled Web Access Failed The default Web access mode for this project is set to file share, but the project folder at http://localhost/NewWebPage cannot be opened witht he path 'G:\Zoning\NewWebPage' the error returned was: Unable to create Web project 'NewWebPage'. The file path...

ASP.NET

2716

MS Access 2003 - automatically create reports/subreports based on criteria

by: neoteny2 | last post by:

I need MS Access to automatically create reports/subreports based on specific criteria. I am building a database in Access 2003 with different locations/sites. I have the "sites" table created containing site info, including an empty field for "date". I also have a report format already created displaying the site info. I need Access to ask the user for a date, calculate three additional dates using the entered date (adding or subtracting...

Microsoft Access / VBA

3359

Cannot create ASP.Net project in Visual Studio .Net 2003

by: JonSteng | last post by:

..Net Visual Studio Professional 2003 Version 7.1.3088 ..Net Framework 1.1 SP1 Version 1.1.4322 IIS 5.1 Windows XP Professional SP2 Micron T3000 Laptop (1.5 GHz; 1GB RAM; 40GB HD with 17GB Free) I installed FrontPage server extensions to IIS on my computer while following instructions in a Microsoft ASP.Net MCSD training book. After installing the FrontPage Server Extensions I cannot create a new

ASP.NET

8402

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

8315

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

8829

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

8508

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

5633

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

4323

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

2733

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

1962

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

1627

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