Re: Sybase to Access

Bummer for you. I've had VB desktop applications using Access as a
back-end that had 75 users and 500MB+ of data, with no problem
whatsoever. There's no reason that wouldn't work for sstory, if he
didn't want to use SQLServer.

Robin S.
----------------------------------
<aaron.kempf@xxxxxxxxx> wrote in message
news:1167768642.603440.102460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: sqlstring -- a library to build a SELECT statement
    ... > short-circuiting behaviors regarding them (the resultant bytecode will ... How to best add further sql function support? ... > database does not support a given function (or operator, ... > case-insensitive in MS SQL Server but case-sensitive in PostgreSQL). ...
    (comp.lang.python)
  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • RE: How to relate a SQL based entity with an Object based entity in Entity Framework
    ... As for "mixing the SQL and Non-SQL. ... The ADO.NET entity framework and EDM mainly focus on the object mapping ... between code level and backend database source. ... support some class/objects mapping to non-database source, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Create new publication error
    ... This occurs when you have sql 2000 as publisher and 2005 ... This issue could occur if the user might be orphaned on the database you ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.replication)
  • RE: Adding Full Text Search to SBS 2003 - Yes I have searched and Read Everything
    ... You receive a "The database this server is using does not support search" ... SQL Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
Loading