If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running a database without ms access
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 |
#2
|
|||
|
|||
Running a database without ms access
hi Jean,
On 19.04.2010 17:01, jean wrote: 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/d...displaylang=en mfG -- stefan -- |
#3
|
|||
|
|||
Running a database without ms access
On Apr 19, 11:11*am, Stefan Hoffmann wrote:
hi Jean, On 19.04.2010 17:01, jean wrote: 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/d...d=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 |
#4
|
|||
|
|||
Running a database without ms access
hi Jean,
On 19.04.2010 17:27, jean wrote: Will that work if i develop the database with ms access 2003 ? http://office.microsoft.com/en-us/ac...208861033.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/simp...or-handler.htm mfG -- stefan -- |
#5
|
|||
|
|||
Running a database without ms access
On Apr 19, 11:46*am, Stefan Hoffmann wrote:
hi Jean, On 19.04.2010 17:27, jean wrote: Will that work if i develop the database with ms access 2003 ? * *http://office.microsoft.com/en-us/ac...208861033.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/simp...or-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 |
#6
|
|||
|
|||
Running a database without ms access
On Apr 20, 9:46*am, jean wrote:
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/ac...CH102222081033 Customize the Ribbon http://office.microsoft.com/en-us/ac...CH100621911033 Show trust by adding a digital signature http://office.microsoft.com/en-us/ac...CH100621891033 Command-line switches for Access http://office.microsoft.com/en-us/ac...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/ac...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/ac...CH100621861033 James A. Fortune |
Thread Tools | |
Display Modes | |
|
|