Re: Sybase to Access

Its the IT dept thats not trusted. They must not see the data. Think I
will just have to encrypt the fields that are sensitive.

The Grand Master

aaron.kempf@xxxxxxxxx wrote:
like for passwords and stupid stuff like that?

yeah I've got a couple of functions to do it; i just dont know if i see
the point.

encryption within a database is fucking pointless.
you just can't use SQL authentication for ANYTHING on ANY SERVER and
you're fairly secure-- out of the box

-Aaron


Master Programmer wrote:
Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aaron.kempf@xxxxxxxxx wrote:
Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:
Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

.