Hi all,
I'm working with a VB app, using DAO 3.6, that used to generate Access
'97 databases using the following code:
Set dbsNew = wrkDefault.Crea teDatabase(strL PAccessInv, dbLangGeneral,
dbVersion30)
I was able to have it create databases in Access 2000 by changing
"dbVersion3 0" to "dbVersion4 0". Do I generate a database in Access
2003 by changing the code to something like "dbVersion5 0" or do I need
to re-write the code in ADO or is there some other issue I'm not aware
of? The new databases consist of tables with data only, nothing else.
Thanks.
Robin 3 6205
The "Access" databases you are generating are, in actuality, Jet database
engine databases. The Jet database engine used by Access 2003 is the same
Jet 4.0 database engine used with Access 2000, so your "dbVersion4 0" ought
to work just fine. There have been eight (8) SPs to Jet 4.0, and I suggest
you make sure you obtain and apply all of them.
Larry Linson
Microsoft Access MVP
"Robin" <du************ **@yahoo.com> wrote in message
news:19******** *************** ***@posting.goo gle.com... Hi all,
I'm working with a VB app, using DAO 3.6, that used to generate Access '97 databases using the following code:
Set dbsNew = wrkDefault.Crea teDatabase(strL PAccessInv, dbLangGeneral, dbVersion30)
I was able to have it create databases in Access 2000 by changing "dbVersion3 0" to "dbVersion4 0". Do I generate a database in Access 2003 by changing the code to something like "dbVersion5 0" or do I need to re-write the code in ADO or is there some other issue I'm not aware of? The new databases consist of tables with data only, nothing else.
Thanks.
Robin
Larry,
Thanks very much for your advice. I checked, and it seems that I have
version 4.0.8618.0 (Security Bulletin MS04-014) of msjet40.dll -- so
I'm as current as I can get. Is what you're saying that by using
"dbVersion4 0" the code below should generate a database in Access2003
rather than 2000?
Thanks again,
Robin
"Larry Linson" <bo*****@localh ost.not> wrote in message news:<jCF1d.570 1$MS1.401@trndd c02>... The "Access" databases you are generating are, in actuality, Jet database engine databases. The Jet database engine used by Access 2003 is the same Jet 4.0 database engine used with Access 2000, so your "dbVersion4 0" ought to work just fine. There have been eight (8) SPs to Jet 4.0, and I suggest you make sure you obtain and apply all of them.
Larry Linson Microsoft Access MVP
"Robin" <du************ **@yahoo.com> wrote in message
news:19******** *************** ***@posting.goo gle.com... Larry,
Thanks very much for your advice. I checked, and it seems that I have version 4.0.8618.0 (Security Bulletin MS04-014) of msjet40.dll -- so I'm as current as I can get. Is what you're saying that by using "dbVersion4 0" the code below should generate a database in Access2003 rather than 2000?
No, what I was trying to say is that _Access_ is not involved in your
database in any way at all. VB interfaces directly to the Jet database
engine -- what you are generating is a _Jet_ database.
But, few of us, and especially Microsoft, are careful to draw that
distinction and often resort to the verbal shortcut of calling it an "Access
database".
Access 2000 uses Jet 4.0, to which all 8 SPs should have been applied.
Access 2003 uses Jet 4.0, to which all 8 SPs should have been applied. As
far as I know the "difference s" between a database generated by Access 2000
and one generated by Access 2003 and saved in "Access 2003 format" are all
in the database objects: queries, forms, reports, macros, and modules, not
in the tables or the data itself.
Larry Linson
Microsoft Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: edo |
last post by:
100 Day Analysis
Following is a summary of articles spanning a 100 day period,
beginning at 10 Sep 2003 06:41:30 GMT and ending at
19 Dec 2003 04:09:06 GMT.
Notes
=====
- A line in the body of a post is considered to be original if it
|
by: Wayne Aprato |
last post by:
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:
"The Visual Basic for Applications project in the database is
corrupt."
Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the...
|
by: Mike |
last post by:
Hi
Hi
We are currently upgrading from access 97 to office 2003 on site. We
would like to upgrade our access databases to Access 2003 but we wish
to remove Microsoft access software from our end users so that we can
control the creation of databases. Is there a way that our end users
can still use these upgraded access databases without having access
2003 installed on their machines. The mdes will reside on a server so
they can be...
|
by: com |
last post by:
Extreme Web Reports 2005 - Soft30.com
The wizard scans the specified MS Access database and records
information such
as report names, parameters and subqueries. ...
www.soft30.com/download-1-11975.htm - 31k - Cached - Similar pages
MDBSecure 1.0.8.0 - Soft30.com
Utility which makes it easy to create secure MS Access Databases, ...
MS Access
2000/2003 format. 30 day money back guarantee, 30 day trial. ...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
| |
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, etc?
Please explain
--
Message posted via http://www.accessmonster.com
|
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting there, but is there a way they can find out if that
application was put there from a CD or email or created at work?
Hint: It's not on a client/server database, just native jet database mdb
created on Access 2003 (default 2000)...
|
by: sparks |
last post by:
My boss and I both have access 97 and access 2003 installed on our
systems.
Lately he has been having a lot of problems. Databases that won't
close. The database looks like it closes but access will not. And
other weird things...I just passed it off as just MS nothing new.
Yesterday I asked him to look at a little project...nothing much of
anything. I put it up on our server and he opened it and went into
design view. Its a form with...
|
by: Bruce |
last post by:
I have a number of Access 2000 format databases on a Windows 2003
server. For some reason I can no longer compact these databases
directly on the server using Access 2003. Access 2000 seems to
compact them just fine however. If I copy the database to my local
workstation Access 2003 will compact it just fine. On the server
however, when I use Access 2003, it creates a compacted copy of the
original database and names it dbn.mdb (where...
|
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...
|
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...
| |
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
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...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |