OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Create Base database from VB.Net?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
dpbaker
Newbie
Newbie


Joined: 08 Sep 2005
Posts: 3

PostPosted: Sun Dec 19, 2010 7:35 am    Post subject: Create Base database from VB.Net? Reply with quote

I have an application that creates incident reports inside Microsoft Access MDB databases. Managers can then simply double-click on the MDB file to open it and check the incidents.

I would like to do something similar now that we have scrapped Microsoft Office & moved to OpenOffice.

Is there any way to create any database from within VB.Net that can be opened in Base with a double-click? Managers are not happy with the way they have to open MDB files - use the wizard, register (or not), save the ODB then finally open the database. They want to just double-click and open.

Is there any other database format that I could create that Base will open immediately? Or can I create ODB files directly from VB.Net?

Thanks,

Dave
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Sun Dec 19, 2010 10:04 am    Post subject: Reply with quote

Dave,
Sounds like you're putting a square-peg in a round-hole in this case with OOo. Simply install the free MS Access Runtime on each managers computer. Versions for MS Access 2010/2007 are available (free) from Microsoft.
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
dpbaker
Newbie
Newbie


Joined: 08 Sep 2005
Posts: 3

PostPosted: Sun Dec 19, 2010 7:36 pm    Post subject: Reply with quote

Unfortunately the application creates the reports into MSAccess 97 format. None of the new viewers can read Access 97 files without converting and of course the runtime viewers can't convert either. And there are licencing issues with the Access 97 runtime viewer even if it could be found after 13 years!

So, the choice is either write for OpenOffice or write for latest version of MSAccess and force users to get MS Office (which probably won't make it past the bean counters).

I saw a post here:
http://weblogs.asp.net/jmandia/archive/2003/09/26/29277.aspx
that gave me hope that something like this might be possibly, though finding any more info has so far proven unsuccessful.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Dec 20, 2010 2:46 pm    Post subject: Reply with quote

As long as Windows is still the operating system in use, you can install the freely available database drivers for MS Access (some "connectivity tools" downloadable from microsoft.com), connect a Base file to your mdb and define a database report. Even Calc can be used as report engine for data from arbitrary databases.
Reusing most of the existing databases is the strength of both frontends OOo Base and MS Access.
You can use the office API by means of COM, .NET or any of the supported scripting languages. Normally this makes no sense if you do not understand the underlying application.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
dpbaker
Newbie
Newbie


Joined: 08 Sep 2005
Posts: 3

PostPosted: Wed Dec 22, 2010 8:04 am    Post subject: Reply with quote

Villeroy wrote:
You can use the office API by means of COM, .NET or any of the supported scripting languages.

So, in theory I should be able to use the Base through the API with VB.Net 2010 to create a Base database that I can just double-click to open?
If so, are there any resources that you know of that you could point me to? I haven't had much luck so far with anything newer than 2002.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group