Re: Sybase to Access

I've had Access apps with 25 mb of data that can't support a half dozen
users.

MDB shouldn't be used for a single user nor a single record.

If MS had a decade-long policy of preaching SQL over MDB then _MAYBE_ I
would be willing to accept SQL 2005 _CRAP_ that is built into VB 2005.

As it is; I can't reccomend SQL 2005 _anywhere_ since it's not
supported on TRANSMETA (_BLADES_ and tablets), it doesn't support SQL
Agent; and it doesn't support replication like MSDE 2.0 did

-Aaron


RobinS wrote:
Why would Access bite with a 30MB database -- that's nothing.
I've had apps with an Access database that was 500MB, and the
performance was fine.

It would be better to migrate to SQLServer Express, but using
Access won't kill him.

Robin S.
---------------------------------
"sstory" <nothank@xxxxxx> wrote in message
news:uLrM4NpLHHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
Not sure of the question.

1.) Access would really bite with a 30MB database--not recommended.
2.) Access could use link tables to link to Sybase perhaps and give
you "access" to it. then again, why would you use Access if that were
possible instead of just getting the drivers to connect directly to
Sybase.
3.) If it is a problem you might consider migrating to MySQL.
"codercode" <wong.jamin@xxxxxxxxx> wrote in message
news:1166120551.784318.13300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?




.

Relevant Pages

  • RE: Import from Sybase SQL Anywhere 9
    ... I found similar issue reported and it seems to be caused by olddb driver ... searching the Sybase newsgroups for information on configuring the Sybase ... ianywhere.com support staff. ... Migrating a Microsoft Access Application into a .NET Solution that Uses SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase to Access
    ... would be willing to accept SQL 2005 _CRAP_ that is built into VB 2005. ... supported on TRANSMETA, ... I've had apps with an Access database that was 500MB, ... Access could use link tables to link to Sybase perhaps and ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Tiger Stock
    ... a lot of money selling applications based on their own platform. ... larger players support more interfaces, ... Coming back to a point in the last paragraph: Lack of support for SQL ... So if we take that off the table and compare companies, ...
    (comp.databases.pick)
  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)