Re: Sybase to Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • Strange ADO.NET/Sybase/Sybase OLEDB problem
    ... we have developed in VB.NET and that accesses a Sybase database using the ... Sybase OLEDB driver via ADO.NET. ... Every morning about 5am, the windows service checks a specified directory, ... MergeData stored proc has started to finish prematurely before it has ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: Decouple SQL queries from class in OOP design
    ... then the arguments to the storeCart stored procedure have to be rather ... I have to be familiar with database schema, ... > support returning arbitrary numbers of rows through SELECT statements. ... > SYBASE does support that, and with SYBASE you have a lot of room to ...
    (comp.object)
  • Re: Sybase Market
    ... relational database management systems and database-related products. ... "Sybase" is also commonly used to refer to Adaptive Server Enterprise, ... a deal with Microsoft to share the source code for Microsoft to ...
    (comp.databases.sybase)
  • Re: Zombie handles when trapped by a signal
    ... Now that I know that the Sybase ... The concept is to do the execute with a timeout. ... > database server automatically is not correct. ... even after the DBD-Sybase bug is fixed. ...
    (perl.dbi.users)