473,386 Members | 1,754 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Use Access DB without Access

Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks
Nov 12 '05 #1
8 10287
First of all you must have the office developers edition which gives you the
tools and the licence to distribute the access run-time. The developers
edition version you get must be the same as the access version you're using;
97, 2000 or 2002(XP).

Stewart
"Francisco" <fd******@ufl.edu> wrote in message
news:8a*************************@posting.google.co m...
Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks

Nov 12 '05 #2
The Developer's version of Office Professional includes the ability to package
the Access run-time components for distribution. You use the Package &
Deployment wizard to create an executable file that can be installed on the
target PC. (MS has changed the name from Developer's version to something else
for Office 2003).

If you are the one who does not have Access installed, then you'll need to talk
to the person who developed the database and ask them to create a distribution
file. Hopefully, they will have a copy of the Developer's version of Office.

____________________________________

"Francisco" <fd******@ufl.edu> wrote in message
news:8a*************************@posting.google.co m...
Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks
Nov 12 '05 #3
"Tom Wickerath" <AOS168 @ comcast . net> wrote in message
news:Hn********@news.boeing.com...
The Developer's version of Office Professional includes the ability to package the Access run-time components for distribution. You use the Package &
Deployment wizard to create an executable file that can be installed on the target PC. (MS has changed the name from Developer's version to something else for Office 2003).

FYI Tom: The Access Runtime DOES NOT create an executable file. It is
basically the full Access system without the ability to modify forms and a
few other things.

Ruben Baumann
If you are the one who does not have Access installed, then you'll need to talk to the person who developed the database and ask them to create a distribution file. Hopefully, they will have a copy of the Developer's version of Office.
____________________________________

"Francisco" <fd******@ufl.edu> wrote in message
news:8a*************************@posting.google.co m...
Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks

Nov 12 '05 #4
"R Baumann" <ry**@9yahoo.com> wrote in message
news:vp************@corp.supernews.com...
"Tom Wickerath" <AOS168 @ comcast . net> wrote in message
news:Hn********@news.boeing.com...
The Developer's version of Office Professional includes the ability to package
the Access run-time components for distribution. You use the Package &
Deployment wizard to create an executable file that can be installed on

the
target PC. (MS has changed the name from Developer's version to

something else
for Office 2003).

FYI Tom: The Access Runtime DOES NOT create an executable file. It is
basically the full Access system without the ability to modify forms and a
few other things.

Ruben Baumann
If you are the one who does not have Access installed, then you'll need

to talk
to the person who developed the database and ask them to create a

distribution
file. Hopefully, they will have a copy of the Developer's version of

Office.

____________________________________

"Francisco" <fd******@ufl.edu> wrote in message
news:8a*************************@posting.google.co m...
Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks


FYI R Baumann
The developer's version DOES create an executable file. I think if you
re-read Tom's reply you will see that everything he has said is true. This
is not the same as saying that you can create a file which can run without
msaccess.exe.

Fletcher
Nov 12 '05 #5
On Tue, 28 Oct 2003 22:18:51 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:

I disagree. The developer's version DOES NOT create an executable
file. When you run the Package and Deployment Wizard (P&DW), as one of
the files in the package it includes setup.exe, which may be the
executable file you are referring to. But that file is not created;
it's a static file capable of installing the CAB file created with
P&DW.
The Access application is not turned into an executable file either.
Rather a special "runtime" version of Access is included with the
setup program, and it is used in the shortcut to run the app:
<path to>msaccess.exe <path to>myapp.mdb
or .mde as the case may be.

<soapbox>
Users should not be concerned about this. Some think VB is superior
because you can create real EXEs. Not entirely true. VB, just like
Access, relies on a whole host of DLL and other components to do part
of the work. Just copy a VB executable to a virgin machine and you'll
see it doesn't work. Same for C++. In this environment you *can*
create standalone executables, which can be copied to virgin machines
and will work, but that is unusual. Most of these apps rely on
external MFC DLLs or other runtime DLLs to do part of the work.
And even if you have a standalone EXE, doesn't that app rely on the
DLLs that make up the Windows operating system, such as user32.exe,
etc?
</soapbox>

-Tom.
"R Baumann" <ry**@9yahoo.com> wrote in message
news:vp************@corp.supernews.com...
"Tom Wickerath" <AOS168 @ comcast . net> wrote in message
news:Hn********@news.boeing.com...
> The Developer's version of Office Professional includes the ability to

package
> the Access run-time components for distribution. You use the Package &
> Deployment wizard to create an executable file that can be installed on

the
> target PC. (MS has changed the name from Developer's version to

something
else
> for Office 2003).
>


FYI Tom: The Access Runtime DOES NOT create an executable file. It is
basically the full Access system without the ability to modify forms and a
few other things.

Ruben Baumann
> If you are the one who does not have Access installed, then you'll need

to
talk
> to the person who developed the database and ask them to create a

distribution
> file. Hopefully, they will have a copy of the Developer's version of

Office.
>
> ____________________________________
>
> "Francisco" <fd******@ufl.edu> wrote in message
> news:8a*************************@posting.google.co m...
> Hi,
> How can I use a MS-Access DB in a computer without Access installed? I
> read something about a "runtime" utility, but I don't know how to use
> it.
> Any help?
> Thanks


FYI R Baumann
The developer's version DOES create an executable file. I think if you
re-read Tom's reply you will see that everything he has said is true. This
is not the same as saying that you can create a file which can run without
msaccess.exe.

Fletcher


Nov 12 '05 #6
I was, indeed, referring to the Setup.exe file and, without stating so, the
associated .CAB file as well. I was not necessarily aware that Setup.exe is a
static file. In any case, it is written to (ie. "created") in the target folder
for a person to use. It very well may be copied from some other location on
their hard drive. Thanks for the education.

______________________________

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:9s********************************@4ax.com...
On Tue, 28 Oct 2003 22:18:51 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:

I disagree. The developer's version DOES NOT create an executable
file. When you run the Package and Deployment Wizard (P&DW), as one of
the files in the package it includes setup.exe, which may be the
executable file you are referring to. But that file is not created;
it's a static file capable of installing the CAB file created with
P&DW.
The Access application is not turned into an executable file either.
Rather a special "runtime" version of Access is included with the
setup program, and it is used in the shortcut to run the app:
<path to>msaccess.exe <path to>myapp.mdb
or .mde as the case may be.

<soapbox>
Users should not be concerned about this. Some think VB is superior
because you can create real EXEs. Not entirely true. VB, just like
Access, relies on a whole host of DLL and other components to do part
of the work. Just copy a VB executable to a virgin machine and you'll
see it doesn't work. Same for C++. In this environment you *can*
create standalone executables, which can be copied to virgin machines
and will work, but that is unusual. Most of these apps rely on
external MFC DLLs or other runtime DLLs to do part of the work.
And even if you have a standalone EXE, doesn't that app rely on the
DLLs that make up the Windows operating system, such as user32.exe,
etc?
</soapbox>

-Tom.
"R Baumann" <ry**@9yahoo.com> wrote in message
news:vp************@corp.supernews.com...
"Tom Wickerath" <AOS168 @ comcast . net> wrote in message
news:Hn********@news.boeing.com...
> The Developer's version of Office Professional includes the ability to

package
> the Access run-time components for distribution. You use the Package &
> Deployment wizard to create an executable file that can be installed on

the
> target PC. (MS has changed the name from Developer's version to

something
else
> for Office 2003).
>


FYI Tom: The Access Runtime DOES NOT create an executable file. It is
basically the full Access system without the ability to modify forms and a
few other things.

Ruben Baumann
> If you are the one who does not have Access installed, then you'll need

to
talk
> to the person who developed the database and ask them to create a

distribution
> file. Hopefully, they will have a copy of the Developer's version of

Office.
>
> ____________________________________
>
> "Francisco" <fd******@ufl.edu> wrote in message
> news:8a*************************@posting.google.co m...
> Hi,
> How can I use a MS-Access DB in a computer without Access installed? I
> read something about a "runtime" utility, but I don't know how to use
> it.
> Any help?
> Thanks


FYI R Baumann
The developer's version DOES create an executable file. I think if you
re-read Tom's reply you will see that everything he has said is true. This
is not the same as saying that you can create a file which can run without
msaccess.exe.

Fletcher

Nov 12 '05 #7
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:9s********************************@4ax.com...
On Tue, 28 Oct 2003 22:18:51 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:

I disagree. The developer's version DOES NOT create an executable
file. When you run the Package and Deployment Wizard (P&DW), as one of
the files in the package it includes setup.exe, which may be the
executable file you are referring to. But that file is not created;
it's a static file capable of installing the CAB file created with
P&DW.
The Access application is not turned into an executable file either.
Rather a special "runtime" version of Access is included with the
setup program, and it is used in the shortcut to run the app:
<path to>msaccess.exe <path to>myapp.mdb
or .mde as the case may be.

<soapbox>
Users should not be concerned about this. Some think VB is superior
because you can create real EXEs. Not entirely true. VB, just like
Access, relies on a whole host of DLL and other components to do part
of the work. Just copy a VB executable to a virgin machine and you'll
see it doesn't work. Same for C++. In this environment you *can*
create standalone executables, which can be copied to virgin machines
and will work, but that is unusual. Most of these apps rely on
external MFC DLLs or other runtime DLLs to do part of the work.
And even if you have a standalone EXE, doesn't that app rely on the
DLLs that make up the Windows operating system, such as user32.exe,
etc?
</soapbox>

-Tom.

I do understand what the Developer's version will do for you - and have
created a number of run-time applications. The only reason I posted was
that it seemed that Tom W's statement "... includes the ability to package
the Access run-time components for distribution..." is clearly posted by
someone who understands what's going on. R Baumann's "FYI Tom: The Access
Runtime DOES NOT create..." seemed a little patronising and to somewhat miss
the point.

Anyway, I still maintain that an exe file is created - certainly in the
sense if you create an installation disk - the CD starts out blank and ends
up with, among other stuff, setup.exe file on it. In that sense it has been
created, but I understand this is a slightly silly discussion to be having.

Fletcher
Nov 12 '05 #8
Access runtime can be installed from some MSOffice 2000 CDs. I noted that if
you do a full install of the MSOffice 2000 CD (check every box), MS Access
runtime is installed.

Note: I have only noticed this on Dell OEM CDs. Also I see no reference to
the runtime in the installation wizard. Some Access sample application must
be on this CD. We run full Access97 so this feature was more of a problem
then a help.

"Francisco" <fd******@ufl.edu> wrote in message
news:8a*************************@posting.google.co m...
Hi,
How can I use a MS-Access DB in a computer without Access installed? I
read something about a "runtime" utility, but I don't know how to use
it.
Any help?
Thanks

Nov 12 '05 #9

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

Similar topics

9
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main...
3
by: Bruce | last post by:
I recently 'upgraded' a number of our applications to Access 2003 from Access 97. There are a few things I like about the newer (post 97) versions of Access but they've also introduced a number of...
3
by: Mike Wilson | last post by:
Is there a way to open an OLE DB database from within Access? I would like to use the Access GUI with its table and query explorer to examine a database only available through an OLEDB provider...
33
by: Uwe Range | last post by:
Hi to all! A customer of mine told me some days ago that her IT-people told her ACCESS would not be such a good idea for continuing with our project, because Access will not be continued in the...
71
by: Lauren Wilson | last post by:
Hello folks, Would love yo get all informed opinions and/or facts on the following: Over the last few weeks I have spent quite a bit of time reviewing all the Access and .NET stuff I could...
55
by: AnandaSim | last post by:
I just had a google through this NG but have not seen mention of Erik Rucker's blog entry and the new Jet: http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx mentioned by Mike...
8
by: carriolan | last post by:
Hi I have an MS Access based application almost ready for distribution to the public and I find that even though I have compiled it into an MDE file, tables and queries can still be be imported if...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
16
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
Oralloy
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,...
0
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...

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.