Sybase to Access

[codercode]

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?

[vbnetdev]

see

http://72.14.205.104/search?q=cache:...s&ct=clnk&cd=3
"codercode" <wo********@gma il.comwrote in message
news:11******** *************@8 0g2000cwy.googl egroups.com...

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?

[Cor Ligthert [MVP]]

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?

Just my thought reading your message,

Cor

"codercode" <wo********@gma il.comschreef in bericht
news:11******** *************@8 0g2000cwy.googl egroups.com...

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?

[vbnetdev]

LOL

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:uM******** ******@TK2MSFTN GP06.phx.gbl...

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?

Just my thought reading your message,

Cor

"codercode" <wo********@gma il.comschreef in bericht
news:11******** *************@8 0g2000cwy.googl egroups.com...

>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?

[aaron.kempf]

I agree.

Anyone using MDB for __anything__ in the year 2006 should be fired and
then spit upon

-Aaron


Cor Ligthert [MVP] wrote:

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?

Just my thought reading your message,

Cor

"codercode" <wo********@gma il.comschreef in bericht
news:11******** *************@8 0g2000cwy.googl egroups.com...

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?

[Master Programmer]

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?

[aaron.kempf]

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?

[Master Programmer]

Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aa*********@gma il.com 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?

[aaron.kempf]

to encrpyt text or the connection string argument?

ADP supports both without a problem

-aaron

Master Programmer wrote:

Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aa*********@gma il.com 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?

[aaron.kempf]

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

aa*********@gma il.com 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?