Upgrading from Access?

P

Phaedrus82

My company currently has an Access database, but due to security limitations
we want to move to a client-server based technology.

We have a fairly small database, so we don't need anything terribly
powerful. We are looking for a relatively simple and inexpensive solution,
so we have been considering MSDE or SQL Server Express Edition.

Does anyone have any suggestions as to what product might best fit our
needs? Any suggestions would be welcome.

Thanks,

Chris
 
A

Albert D.Kallal

You don't mention the number of users, but certainly MSDE, or sql server
express are free to use.

However, if you continue to display all of the tables in ms-access when you
use sql server, then you gain nothing in terms of security. Users can still
open he data, hit delete key and delete all records in a table when you use
sql server. And, they can paste the data into excel and email it out. So,
unless you design restrictions into your application, then often moving to
sql server does not help.

I am assuming you are going to continue to use ms-access for the "front end"
part, as you can't make forms, or reports in sql server.

And, do note that you can by using the startup options in ms-access "hide"
all of the access interface, and you don't need security, or even to write
code to do this. And, if you distribute a mde to each user, then changing of
forms, and reports is not possible. So, you can keep them out of the table
view, and they will not be able to change forms if you use a mde (and, you
likely will have to do this if you move the data to sql server, but continue
to use ms-access for the forms and reports anyway).
 
Top