473,881 Members | 1,629 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
May 11 '06 #1
49 3259
Hi, Mell.
If they have Ms Access 2000 or higher, will they be able to use these dbs
with all code, etc?
If you developed the database application in Access 2000 database format
(the default for Access 2003), didn't use any Access 2002 or 2003 -specific
objects or methods in the code, and didn't convert it into an MDE database
file, then users with Access 2000 or newer will be able to use and read the
database file.

If the file is in Access 2002-2003 database format, then the Access 2000 and
earlier versions won't be able to open the database. If you converted it
into an MDE database file, then only users with Access 2003 will be able to
open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Mell via AccessMonster.c om" <u18304@uwe> wrote in message
news:60194ed649 b70@uwe...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

May 11 '06 #2
Great!

That sums it up!

Thank you so kindly....

'69 Camaro wrote:
Hi, Mell.
If they have Ms Access 2000 or higher, will they be able to use these dbs
with all code, etc?


If you developed the database application in Access 2000 database format
(the default for Access 2003), didn't use any Access 2002 or 2003 -specific
objects or methods in the code, and didn't convert it into an MDE database
file, then users with Access 2000 or newer will be able to use and read the
database file.

If the file is in Access 2002-2003 database format, then the Access 2000 and
earlier versions won't be able to open the database. If you converted it
into an MDE database file, then only users with Access 2003 will be able to
open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.

[quoted text clipped - 3 lines]

Please explain


--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 11 '06 #3
You're welcome. Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Mell via AccessMonster.c om" <u18304@uwe> wrote in message
news:601a181c00 7c7@uwe...
Great!

That sums it up!

Thank you so kindly....

'69 Camaro wrote:
Hi, Mell.
If they have Ms Access 2000 or higher, will they be able to use these
dbs
with all code, etc?


If you developed the database application in Access 2000 database format
(the default for Access 2003), didn't use any Access 2002 or
2003 -specific
objects or methods in the code, and didn't convert it into an MDE database
file, then users with Access 2000 or newer will be able to use and read
the
database file.

If the file is in Access 2002-2003 database format, then the Access 2000
and
earlier versions won't be able to open the database. If you converted it
into an MDE database file, then only users with Access 2003 will be able
to
open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.

[quoted text clipped - 3 lines]

Please explain


--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200605/1

May 11 '06 #4
Although you could have two different versions of the same database
and sync them at regular intervals so that everyone can see and
contribute to what everyone else can see and contribute to. It is not
elegant and it is costly on disk space and probably doubles the amount
of traffic down your network lines but it works cos I did it for a
while until I found a permanent fix.

However, from my recent experience I would recommend exporting your
Access file to SQL Express or some other database engine and then just
using Access as a front end to that. My firm actually managed to
convert access dbs to MySQL without too much trouble so we don't even
have to pay for our industrial database...how is that for
cheapskating?

On Thu, 11 May 2006 11:32:21 -0700, "'69 Camaro"
<Fo************ **************@ Spameater.orgZE RO_SPAM> wrote:
You're welcome. Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Mell via AccessMonster.c om" <u18304@uwe> wrote in message
news:601a181c0 07c7@uwe...
Great!

That sums it up!

Thank you so kindly....

'69 Camaro wrote:
Hi, Mell.

If they have Ms Access 2000 or higher, will they be able to use these
dbs
with all code, etc?

If you developed the database application in Access 2000 database format
(the default for Access 2003), didn't use any Access 2002 or
2003 -specific
objects or methods in the code, and didn't convert it into an MDE database
file, then users with Access 2000 or newer will be able to use and read
the
database file.

If the file is in Access 2002-2003 database format, then the Access 2000
and
earlier versions won't be able to open the database. If you converted it
into an MDE database file, then only users with Access 2003 will be able
to
open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.
[quoted text clipped - 3 lines]

Please explain


--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200605/1

May 11 '06 #5
Snuff <sn*****@all2wo rry4.com> wrote in
news:aq******** *************** *********@4ax.c om:
Although you could have two different versions of the same
database and sync them at regular intervals so that everyone can
see and contribute to what everyone else can see and contribute
to. It is not elegant and it is costly on disk space and probably
doubles the amount of traffic down your network lines but it works
cos I did it for a while until I found a permanent fix.
The above looks to me to be complete and utter gibberish. It makes
absolutely no sense in any of its parts.
However, from my recent experience I would recommend exporting
your Access file to SQL Express or some other database engine and
then just using Access as a front end to that. My firm actually
managed to convert access dbs to MySQL without too much trouble so
we don't even have to pay for our industrial database...how is
that for cheapskating?


This, too, looks like malarkey.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 11 '06 #6
Hi, Snuff.
Although you could have two different versions of the same database <snip> It is not
elegant and it is costly on disk space and probably doubles the amount
of traffic down your network lines but it works cos I did it for a
while until I found a permanent fix.
Please explain why you went to the trouble to build two versions of the same
database for Access 2000, 2002, and 2003 users when one Access 2000 database
format front end or back end would have accommodated any of them.
However, from my recent experience I would recommend exporting your
Access file to SQL Express or some other database engine and then just
using Access as a front end to that.
This is always an option, but upsizing to another database engine requires
time and effort to accommodate connections, linked tables, queries, stored
procedures, VBA code, and possibly security. The effort requires
availability of the correct skill set, and time requires labor costs, so
unless there's a really good reason to upgrade the database engine to
another one, such as security, or significantly increased concurrent
transactions that are slowing processing due to record locks, or the need
for logged transactions, or movement of the backend to a WAN, et cetera,
then one shouldn't be migrating from Jet.
My firm actually managed to
convert access dbs to MySQL without too much trouble so we don't even
have to pay for our industrial database
Your firm didn't convert Access to MySQL. Your firm migrated the data,
because MySQL can't accommodate the other Access database objects, such as
forms, reports, modules, et cetera. The queries probably remain in the
Access front end as well, although they may have needed changing to
accommodate pass-through queries. Which may, in turn, have required VBA
code changes in the forms that previously relied upon being able to update
the bound data set automatically with the built-in features. If these
changes needed to be done, then the money spent on the labor for the
migration cost your firm "something. "

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Snuff" <sn*****@all2wo rry4.com> wrote in message
news:aq******** *************** *********@4ax.c om... Although you could have two different versions of the same database
and sync them at regular intervals so that everyone can see and
contribute to what everyone else can see and contribute to. It is not
elegant and it is costly on disk space and probably doubles the amount
of traffic down your network lines but it works cos I did it for a
while until I found a permanent fix.

However, from my recent experience I would recommend exporting your
Access file to SQL Express or some other database engine and then just
using Access as a front end to that. My firm actually managed to
convert access dbs to MySQL without too much trouble so we don't even
have to pay for our industrial database...how is that for
cheapskating?

On Thu, 11 May 2006 11:32:21 -0700, "'69 Camaro"
<Fo************ **************@ Spameater.orgZE RO_SPAM> wrote:
You're welcome. Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Mell via AccessMonster.c om" <u18304@uwe> wrote in message
news:601a181c 007c7@uwe...
Great!

That sums it up!

Thank you so kindly....

'69 Camaro wrote:
Hi, Mell.

> If they have Ms Access 2000 or higher, will they be able to use these
> dbs
> with all code, etc?

If you developed the database application in Access 2000 database format
(the default for Access 2003), didn't use any Access 2002 or
2003 -specific
objects or methods in the code, and didn't convert it into an MDE
database
file, then users with Access 2000 or newer will be able to use and read
the
database file.

If the file is in Access 2002-2003 database format, then the Access 2000
and
earlier versions won't be able to open the database. If you converted
it
into an MDE database file, then only users with Access 2003 will be able
to
open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and
tutorials .
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

>I created databases on Access 2003 and I want to deploy them to users.
>My
> code was also done using 2003.
[quoted text clipped - 3 lines]
>
> Please explain

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200605/1

May 12 '06 #7
"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM>
wrote in news:nv******** *************** *******@adelphi a.com:
My firm actually managed to
convert access dbs to MySQL without too much trouble so we don't
even have to pay for our industrial database


Your firm didn't convert Access to MySQL. . . .


Not only that -- they also didn't convert to an "industrial
database," as MySQL is not even close, even with InnoDB tables.

This is one of the reasons I basically called the whole post
gibberish. It looked to me like one of Don Mellon's trolling
efforts.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 12 '06 #8
David W. Fenton wrote:
Your firm didn't convert Access to MySQL. . . .


Not only that -- they also didn't convert to an "industrial
database," as MySQL is not even close, even with InnoDB tables.


I'm not familiar with MySql, but am about to jump into it in a big way
in the next little while, so forgive me if this sounds like a dopey
question, but...

Why could they not have changed db engines from jet to MySql? MySql has
odbc drivers, I would think, so linked tables or pass through queries
should be possible, similar to my own experience with Access and Oracle?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
May 12 '06 #9
Hi, David.
Not only that -- they also didn't convert to an "industrial
database," as MySQL is not even close, even with InnoDB tables.
I'm willing to cut some slack on use of terminology to people who post in
this newsgroup, as I'm an Oracle DBA who has worked with industrial
databases for a few of the largest corporations and government organizations
in America. If the data was migrated from an Access database whose maximum
capacity is 2 GB, then even after migration to another database engine it
just doesn't compare on the same scale to what I'm used to with Oracle.
However, most people who deal with Access are dealing with much a smaller
field of data sets and database applications than what I expect with Oracle
users, so their moving to any client/server database engine makes it likely
to seem "industrial " to them.
It looked to me like one of Don Mellon's trolling
efforts.
Yes. It does. But it was posted from the UK, so I'll assume it's not him.
Although he could be on vacation, I just don't imagine him going that far
away.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1... "'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM>
wrote in news:nv******** *************** *******@adelphi a.com:
My firm actually managed to
convert access dbs to MySQL without too much trouble so we don't
even have to pay for our industrial database


Your firm didn't convert Access to MySQL. . . .


Not only that -- they also didn't convert to an "industrial
database," as MySQL is not even close, even with InnoDB tables.

This is one of the reasons I basically called the whole post
gibberish. It looked to me like one of Don Mellon's trolling
efforts.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

May 12 '06 #10

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

Similar topics

10
5581
by: MLH | last post by:
I print to a device that creates a PDF. Knowing the filename, how can I then embed the PDF into the body text of an OutLook Express outbound email & send to a specified address in a table? I want recipient addressees to see the report in the body text window of their email when they open it. I was thinking also about attaching the PDF file to the eMail for those having "text only" email software. I need to automate both of these tasks from...
1
5760
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 same as it was in Access 2002? I am running Access 2002 at the moment. Is there any reason for testing purposes etc, for me to purchase Access 2003 if I am going to recompile the Access 97 mdb files into Access 2000 format mde files which...
0
1219
by: Marc | last post by:
I have a Vb 6.0 project The VB 6.0 project with a just a click of the button...exports the calender rows from OUtlook to a MS Access file ( a DB and a table with the calender rows are created) and from this table a crystal report is created.The Db and table don't exist beforehand...they are created.. Right now for test purposes...I have a test machine set-up with just Outlook 2003 set-up and on that test machine I manually tried to...
10
3063
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the Runtime? I just purchased Office 2003 Professional. Is Access 2003 Runtime included with that or not? It APPEARS that the only way I can get Access 2003 Runtime is to
47
4558
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 company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
2
5709
by: CLarkou | last post by:
My program developed in Access 2003 includes 2 MDE files. Both of them are signed with VeriSign certificate. Program was installed on 2 client machines with Office 2003. One of the machines didn't have Access, so Runtime was installed, and the other machine had Access. On both machines, first MDE was opened without any problem. When they try to open second MDE, the got the error "Cannot open a database created with a previous version...
3
1399
by: =?Utf-8?B?SmVmZnJleQ==?= | last post by:
Just got the book, ASP.NET by Greg Buczek (Osborne). The first part of book listed many aspx codes, not created by VS 2003 or VS 2005. How can these aspx files be coded? NotePad or VB 6? The book did show the web pages with IE for these aspx files. If not VS 2003 or VS 2005, then it must be VS 6. I have an old VS 6, so I ran the aspx file of Chap 1, the IE browser showed only the background gif file. What's wrong? Can ASP.NET...
1
2174
by: kickergirl | last post by:
I created a database in MS Access 2000 that is being used by another person using Access 2003. Everytime they open the database and close it, a "db1" copy of the database is created. This does not happen when I open the database on my network. Has anyone ever heard of this phenomenon and/or know of a solution? Thanks!
0
1083
by: NHComp | last post by:
Hi, I use Access 2007 on my home computer but the office uses the 2003 version. Using 2007 I created a new database and saved it in the 2003 format. When I work in the office the forms and queries work fine in the 2003 software, but when I try to open a previously created report nothing happens (not even an error mesage). I can't even create a new report in v2003 for the database. Any idea what the problem could be? Thanks, Judy
0
9927
marktang
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...
0
9776
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,...
0
10717
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10814
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,...
0
10401
tracyyun
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...
0
9552
agi2029
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...
0
5977
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4597
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
3
3223
bsmnconsultancy
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...

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.