Run-time database

[Nandini]

I have cerated one bibliographic database using Access 2003. I want to make a
run-time version for this. Office 2003 Professional edition is installed in
my computer. What should I do?
With regards,

 

[a a r o n . k e m p f]

In Microsoft's own words....
The following comes from Microsoft article Q300216.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."

 

[Gina Whipp]

The title to which Aaron refers to is:

How to keep a Jet 4.0 database in top working condition in Access 2000

Link: http://support.microsoft.com/kb/300216

Maybe you could find something more recent and pertinent?
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

message
In Microsoft's own words....
The following comes from Microsoft article Q300216.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."

 

[Gina Whipp]

You would VSTO 2005 which as far as I know is no longer available for Office
2003. You might try Amazon or some site like that to see if you can get a
copy.

 

[Tom van Stiphout]

On Tue, 30 Dec 2008 18:50:02 -0800, Nandini

The cheapest solution is to try running the app in the free version of
Access 2007 runtime. Generally speaking A2003 MDBs run just fine in
A2007 runtime.

Or you can purchase a license to distribute the A2003 runtime.

-Tom.
Microsoft Access MVP

 

[Gina Whipp]

Tom,

I thought those were no longer available?

 

[Tom van Stiphout]

On Tue, 30 Dec 2008 23:35:34 -0500, "Gina Whipp"

MSFT doesn't sell A2003 stuff anymore AFAIK, but current
licenseholders can sell theirs.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Tue, 30 Dec 2008 22:18:42 -0700, Tom van Stiphout

Also, you can hire a software development company with a valid license
to create a runtime distribution for you.

-Tom.
Microsoft Access MVP

 

[a a r o n . k e m p f]

oh come on; it's all the same format

The title to which Aaron refers to is:

How to keep a Jet 4.0 database in top working condition in Access 2000

Link:  http://support.microsoft.com/kb/300216

Maybe you could find something more recent and pertinent?
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

messageIn Microsoft's own words....
The following comes from Microsoft article Q300216.

---------------------------------------------------------------------------­---------------------------------------------------------------------------­-----
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."
---------------------------------------------------------------------------­---------------------------------------------------------------------------­-----



- Show quoted text -

 

[Gina Whipp]

Okay, thanks for clearing that up...

 

[Nandini]

If I install Visual Studio 2005 Service Pack 1 Update for Windows Vista, then
would it become possible for me to make the run-time version of my access
database? Please let me know.
with best regards,

 

[Gina Whipp]

NO, that is a Service Pack for the program... a program you don't have.

 

[Douglas J. Steele]

It's not simply Visual Studio 2005 you need: it must be Visual Studio Tools
For Office (VSTO).

To further complicate things, there were versions of VSTO that didn't
include the Access 2003 Developer Extensions. You must have Access 2003
Developer Extensions in order to package the run-time with your application.

 

[BruceM]

Did you just find that article? It has become your new favorite response.
Yes, I know it is something from Microsoft. No, I don't think it is meant
to invalidate Access/Jet as a multi-user database, but rather to issue a
caveat about the *specific situation* described (high-stress,
high-concurrency, etc.).


message
In Microsoft's own words....
The following comes from Microsoft article Q300216.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
"Microsoft Jet is a file-sharing database system. A file-sharing
database is one in which all the processing of the file
takes place at the client. When a file-sharing database, such as
Microsoft Jet, is used in a multiuser environment,
multiple client processes are using file read, write, and locking
operations on the same shared file across a network. If,
for any reason, a process cannot be completed, the file can be left in
an incomplete or a corrupted state. Two
examples of when a process may not be completed is when a client is
terminated unexpectedly or when a network
connection to a server is dropped.

Microsoft Jet is not intended to be used with high-stress, high-
concurrency, 24x7 server applications, such as Web,
commerce, transactional, and messaging servers. For these type of
applications, the best solution is to switch to a true
client/server-based database system such as Microsoft Data Engine
(MSDE) or Microsoft SQL Server. When you use
Microsoft Jet in high-stress applications such as Microsoft Internet
Information Server (IIS), customers have reported
database corruption, stability issues such as IIS crashing or locking
up, and also a sudden and persistent failure of the
driver to connect to a valid database that requires re-starting the
IIS service."

 

[Nandini]

I have installed Visual Studio 2005 Tools For Office Second Edition Runtime.
Control panel shows the installation, but I didnt find out anything of this
in programmes. Operating system of my Pc is widows vista. Would you like to
help me please?
With best regards,

 

[Gina Whipp]

Because....

The Microsoft Visual Studio 2005 Tools for Office Second Edition (VSTO 2005
SE) redistributable package installs the Visual Studio Tools for Office
runtime, which is required to run solutions built using VSTO 2005 or VSTO
2005 SE. This runtime supports solutions built for Microsoft Office 2003 or
the 2007 Microsoft Office system.

You said you do not have VSTO 2005, without it you won't see it. OR did you
get VST 2005?

 

[a a r o n . k e m p f]

you don't need the VSTO _RUNTIME_ you need to get a real copy of VSTO

 

[Nandini]

If I install VSTO 2008, it would be helpful for me?
With best regards,

 

[Gina Whipp]

I do not know, I have not looked at it. For first thought is that it
wouldn't.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

If I install VSTO 2008, it would be helpful for me?
With best regards,

 

[Douglas J. Steele]

I don't believe so.

Microsoft tends to only support a single version of the Access run-time at a
time, and it was only the Access 2003 run-time that was ever part of VSTO
(previous versions were included as part of special versions of Office), and
the Access 2007 run-time is once again distributed a different way, so I
don't believe anything was included in the VSTO 2008.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

If I install VSTO 2008, it would be helpful for me?
With best regards,