Running a database without ms access

[jean]

Hi

It took me close to one year to build a database. This database
contains 46 tables, 237 queries, 105 forms and 180 reports.

My question

Is it possible to make something with it so people who don't have
Microsoft Access can use it exactly the same than if they had Ms
Access.

If the answer is yes, what are the steps to do it ?

thanks

 

[Stefan Hoffmann]

hi Jean,

It took me close to one year to build a database. This database
contains 46 tables, 237 queries, 105 forms and 180 reports.

Quite a piece of work.

Is it possible to make something with it so people who don't have
Microsoft Access can use it exactly the same than if they had Ms
Access.

Exactly the same? No.

If the answer is yes, what are the steps to do it ?

But almost: The Access Runtime.

Link in one line:

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en


mfG
--> stefan <--

 

[jean]

hi Jean,

On 19.04.2010 17:01, jean wrote:> It took me close to one year to build adatabase.  This database

Quite a piece of work.


Exactly the same? No.


But almost: The Access Runtime.

Link in one line:

http://www.microsoft.com/downloads/details.aspx?familyid=d9ae78d9-9dc....

mfG
--> stefan <--

Will that work if i develop the database with ms access 2003 ?

and if i use a dll (mousehook.dll) what will happened with that ?

thanks for helping me

 

[Stefan Hoffmann]

hi Jean,

Will that work if i develop the database with ms access 2003 ?
http://office.microsoft.com/en-us/access/HA011208861033.aspx

and if i use a dll (mousehook.dll) what will happened with that ?

Depedends on the the library, but most libraries will work. If it's the
mousehook.dll I know then yes.

Basically you have to create a mde from your mdb. And test the complete
functionality.
The biggest problem: any unhandled VBA error will result in a shutdown
of the application. So you need error handling in all your methods or
use something like SimplyVBA Global Error Handler:

http://www.everythingaccess.com/simplyvba-global-error-handler.htm


mfG
--> stefan <--

 

[jean]

hi Jean,



   http://office.microsoft.com/en-us/access/HA011208861033.aspx


Depedends on the the library, but most libraries will work. If it's the
mousehook.dll I know then yes.

Basically you have to create a mde from your mdb. And test the complete
functionality.
The biggest problem: any unhandled VBA error will result in a shutdown
of the application. So you need error handling in all your methods or
use something like SimplyVBA Global Error Handler:

   http://www.everythingaccess.com/simplyvba-global-error-handler.htm

mfG
--> stefan <--

Hi

1 - I have convert the MDB file format 2000 to format 2002-2003 (don't
know why it was format 2000 as I have created it with Ms Office
2003 !!!! anyway ...)

2 - I convert the MDB file format to MDE format
I also have checked a lot of functionnality and looks OK (as it is too
long to test everything I consider this as a practice) Mostly I want
to learn steps to be able to use this program without having Ms Access
installed.

3 - I have try to run the "AccessDeveloperExtensions" application, but
it failed because I don't have the 2007 version of MS Access on my
computer

So what should I do next ?

thanks

 

[James A. Fortune]

Hi

1 - I have convert the MDB file format 2000 to format 2002-2003 (don't
know why it was format 2000 as I have created it with Ms Office
2003 !!!! anyway ...)

2 - I convert the MDB file format to MDE format
I also have checked a lot of functionnality and looks OK (as it is too
long to test everything I consider this as a practice) Mostly I want
to learn steps to be able to use this program without having Ms Access
installed.

3 - I have try to run the "AccessDeveloperExtensions" application, but
it failed because I don't have the 2007 version of MS Access on my
computer

So what should I do next ?

thanks

'jean',

Here are some links related to using the free Access 2007 runtime:

Basics for Building Access 2007 Runtime-Based Solutions
http://msdn.microsoft.com/en-us/library/cc136539.aspx

Deploying Access 2007 Runtime-Based Solutions
http://msdn.microsoft.com/en-us/library/bb501030.aspx

Transitioning Your Exisiting Access Applications to Access 2007
http://msdn.microsoft.com/en-us/library/bb203849.aspx

Introduction to the Access 2007 Developer Extensions and Runtime
http://office.microsoft.com/en-us/access/HA102188681033.aspx?pid=CH102222081033

Customize the Ribbon
http://office.microsoft.com/en-us/access/HA102114151033.aspx?pid=CH100621911033

Show trust by adding a digital signature
http://office.microsoft.com/en-us/access/HA102345621033.aspx?pid=CH100621891033

Command-line switches for Access
http://office.microsoft.com/en-us/access/HA101666051033.aspx?pid=CH100621861033

Integrating Workflows into Access 2007 Applications
http://msdn.microsoft.com/en=us/library/aa902694.aspx

Deploy an Access 2007 Application
http://office.microsoft.com/en-us/access/HA102188641033.aspx?pid-CH102222081033

Adding Programs to Access 2007 Deployment Packages
http://msdn.microsoft.com/en-us/library/bb687991.aspx

Choosing Output Devices at Runtime in Access 2007
http://mmsdn.microsoft.com/en-us/library/ee336132.aspx

Creating Managed Add-ins for Access 2007
http://msdn.microsoft.com/en-us/library/aa902693.aspx

Access 2007 specifications
http://office.microsoft.com/en-us/access/HA100307391033.aspx?pid=CH100621861033

James A. Fortune
(e-mail address removed)