Which Database ???

[fbyrne]

Hi,

I have a question - a few actually.

Firstly, I want to develop a small business app that will primarily be run on a standalone machine. In some instances, it may be run on more that one client on a single site. Less frequently, it may need to be deployed on to several client machines, at more than one site.

My questions are these...

I want to develop this app, possibly using a small, convienient local db, more than likely Access. When it comes to deploying this app, it may be easier to leave the Access db on those standalaone sites, or even on theose multi-user, single site installations, with shared Access db.

What do I do for the multi site installations?

I was hoping there was a way of developing the app using Access, and then easily porting onto a SQL Server/SQL Anywhere db as needed, without having to do much more than re-compile the app.

Am I asking for the impossible?

Cheers

[Lothar Haensler]

ever thought about using MSDE Microsoft data engine?
It's a small SQLServer engine that you can use (e.g. on your standalone PC).
You want get anything that's easier to "upgrade".

If you want to stick to access you can use the Upsizing wizard that comes with Access to move your MDB to SQLserver.