Re: Access / DAO - What's the Future

Hi Trevor,

"TrevorS" <tstokes@xxxxxxxxxx> wrote in message
news:1158937679.936507.53830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We are using Access as the "repository" for a C++ MFC application. It's
single user.
The schema is complex (100 tables) and can be a few hundred MBytes in
size.

We are starting to reach the limits: occassionl "Query too Complex" and
"Max Lock Files Exceeded". Although some of these we have tackled and
got around through better design.

We recently moved to Visual Studio 2005 and of course no longer have
the benifit of DAO wizards for creating RecordSets and refreshing them
when the schema changes. This too we have got around for now - just
using old classes as a model and creating them by hand.

We are about to start the next phase of our product and it will stress
the database even more.

The questions:

o Would you recommend that we change to SQL Server Express?

Most definitely. Perhaps you might consider Sql Server Everywhere, too
(single user, no install required - just copy&paste assemblies).

o What are our migration options? Do we have to convert everything to
ADO right away? I assume we can't use DAO with SQL Server. If we could
we migrate slowly - using ADO (or ODBC) for new classes.

Not sure about migration. However if you want to take advantage of .net then
you should go with ado.net and its native providers or even better, use an
ORM (i.e. LLBLGenPro - does many things for you, like wizards, but better)
if it fits your needs.

o Or should we use ODBC?

ODBC via ado.net is still an option but .. .see above.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


.

Relevant Pages

  • Re: multiple cascade paths
    ... You should not have them if your schema is designed properly. ... make you understand that I tried to show that a proper design can have ... am a SQL Server MVP, for crying out loud - you can safely assume that I ...
    (comp.databases.ms-sqlserver)
  • Re: Need help on how to organize users and objects
    ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
    (microsoft.public.sqlserver.security)
  • Re: 3 Simple Security SQL Statements
    ... In SQL 2005, when you create an object, you specify the schema that the ... Kalen Delaney, SQL Server MVP ... Schema for a database role, that seems like the best setup. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
    (microsoft.public.sqlserver.security)
  • Re: same application on multiple schemas
    ... As for the "comparison" with Sql Server, it was not intended to ask ... why Oracle does "not" support sql server behaviour:) I know oracle (I ... For every customer that will use our application, ... will use schema "SchemaA" ...
    (comp.databases.oracle.server)
  • Re: Access / DAO - Whats the Future
    ... when the schema changes. ... (single user, no install required - just copy&paste assemblies). ... ADO right away? ... Miha Markic [MVP C#, ...
    (microsoft.public.dotnet.framework.adonet)