[AccessD] Slightly OT

Hi Martin

Hard to say without knowing anything about the use of these databases
and the complexity of the frontends.

Without redesigning the frontends, you would be stuck with ODBC
connection which may be fully acceptable but then - also in the light
of potential licensing cost - you could as well use an alternative
(open source and/or low cost) engine.

I guess administering of users and rights to this myriad of databases
could be the highest of all running cost.

/gustav


> Comments

> We want to take a couple of hundred Access databases and move them to SQL
> Server. WHat sort of problems do you see in terms of

> Performance
> Security
> Re design
> Backup
> Staffing in terms of DBAs

> anything else???


> Martin