Re: Linking to tables in Firebird or other db


"Jennifer Carr" <jscarr@xxxxxxxxx> wrote in message
news:1134426816.288655.88330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I have an Access 2003 application that is split into two .mdb files for
> the interfaces and data. This app is distributed on a CD to be used on
> computers that have no internet access. When someone needs an updated
> dataset the backend .mdb is refreshed from a load of Oracle tables and
> sent on CD so that the user only needs to replace a single file. The
> front end links to the tables in the back end.
>
> The problem is that the amount of data required is steadily growing and
> has now surpassed the 2GB file size limit. I need to leave the front
> end in Access as this is a big nasty dog of an app written by someone
> else and I don't have time to tackle a rewrite right now (as much as
> I'd love to). What I'd like to find, ideally, is an open-source
> database that can be distributed as a file or set of files that Access
> can link to. As I have no control over machine configurations I'd
> prefer to stay away from creating DSNs, installing software or
> registering DLLs if possible. I've been playing with Firebird and it
> looks like it would work admirably if I could work out how to get
> Access to link to its tables but haven't had much luck so far. I'd be
> grateful for any ideas or suggestions.
>

I don't know for certain if it will meet your needs, but you might want to
take a look at PostgreSQL. It's open source and quite scalable.

--
Randy Harris
I'm pretty sure I know everything that I can remember.

.

Relevant Pages

  • Re: QRe: Legacy Access 2 VB 4 app, Word 11 merge on XP Pro SP2 client
    ... I would simply write a short interim app ... > linked tables to connect to the data in the legacy .mdb files. ... it's not a DLL but essentially the whole of Access 2.0 with the ... > location for your Office 2003 installation, ...
    (microsoft.public.access.conversion)
  • Linking to tables in Firebird or other db
    ... I have an Access 2003 application that is split into two .mdb files for ... the interfaces and data. ... This app is distributed on a CD to be used on ... sent on CD so that the user only needs to replace a single file. ...
    (comp.databases.ms-access)
  • Re: Linking to tables in Firebird or other db
    ... >the interfaces and data. ... This app is distributed on a CD to be used on ... >sent on CD so that the user only needs to replace a single file. ... the data across multiple MDB files. ...
    (comp.databases.ms-access)
  • Re: Access mdb file
    ... >>> I have a small app that does some reporting from legacy dbf files. ... What do I need to access mdb files from ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Architectural feedback
    ... The skeleton's not too far off of the general picture I've been thinking. ... Just to make sure we're clear, when you mention interfaces, do you mean (I'm ... > for this app? ... >> core app must reside on the client or may be run from the server. ...
    (microsoft.public.dotnet.general)
Loading