Microsoft Access

[Ruslan Zasukhin]

On 4/11/06 10:44 PM, "Brandon" <bwarlick at sunbelt-graphics.com> wrote:

Hi Brandon,

>> We need the Access application to be able to add/delete/modify records
> 
>> in a Valentina Database. Is this possible?
> 
>> But can you explain sense of this ?
> 
> I was trying to be clear that we needed full read/write capability within
> Access. Without ODBC, the only way I know for Access to work with Valentina
> data will be the Valentina COM support. This will work within Access using VBA
> programming. 

yes

> But, other objects within access, such as reports, forms, queries would not be
> able to work with the Valentina Database (I assume.)

So it seems, you want to use GUI of Access as front-end to database?
Well, few times people have express such idea....

Also was pointed that 4D DBMS also can be good front-end to Valentina
engine.

>> You develop Valentina-based application? In Director? Else?
> We have developed two applications:
> 1. Microsoft Access application
> 2. RealBasic application

Both on Windows?
Or RB on MAC and Access on Windows?
 
> Currently, the Microsoft Access application is using the Access
> database format. We would like to continue to use the existing Microsoft
> Access application (GUI, reports, etc - 2 years of work) but change the
> underlying database from the Access database format to a client/server
> solution. 

Okay I see point.

> I really like everything I have learned about Valentina. But,
> without ODBC, it will be difficult for the Access application to easily
> work with Valentina data.

So it seems you have no easy way to Valentina here...hmm.
Does Access support JDBC also ?

> Another reason we are looking into Valentina is the really good support for
> Realbasic. We are just now trying to select a client/server solution for our
> RealBasic application.

Let me know if questions.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]