>This is all kind of confusing... It sounds like you have VFP as your data server - and the IT management wants to move to Access and Oracle. I don't see any need to work with Access at all. Are you going to work with the Oracle data in Access or something?
>
>A logical progression for upsizing from VFP is Oracle or SQL Server... if they choose Access they are limiting themselves and going down in capabilities.

PMFJI but not necessarily, Wayne. Oracle + Access may be a very viable solution for certain businesses that need a heavy-duty robust enterprise database like Oracle along with an ad-hoc user-friendly querying and reporting tool like Access. In this type of setup, Access is not used as a data store but simply a simple way to connect to the Oracle data and give end users the capability to build reports or even simple GUI's to that data store. Obviously the serious front-end development would be done using a programming language like VB or Java in this scenario.

The reason I mention this is because my friend at State Street works in a department where they're running Oracle with a Java front-end for their enterprise system but for ad-hoc reporting he uses Access to connect to the Oracle data, build recordsets and design reports quickly and easily. By the way, he swears by these tools and won't hear of using anything else. He's kind of myopic in my opinion (a good JVP word). But whatever works, I guess.

-JT