[AccessD] Access to SQL Server

Martin,

I have recently tried to convert a stressed (concurrency wise) access97 back end to SQL server,
data conversion went smoothly, apart from rectifying memo field corruption in one table.

The forms worked fine and ignored the fact that i had swapped the access linked tables for ODBC
links to the SQL server. The problem came when i was opening recordsets and it was asking for
bizarre parameters, (dbSeeChanges)

For purity i love SQL server database power and stored procedures and the extras like getting the
database to back itself up nightly, and would not hesitate to convert access databases to SQL or
MSDE (is it still called MSDE?)

It's just convincing the client that a 1 gig access backend is 'pushing it' <g>

Regards

Chris

----- Original Message -----
From: Martin Reid
To:  "Access Developers discussion and problem solving"<accessd at databaseadvisors.com>
Sent: Wed, 31 Mar 2004 21:49:03 +0100
Subject: [AccessD] Access to SQL Server

If your employer/customer asked you to move all your Access databases onto a
central SQL Server what problems other than code rewrite would you bring up?

What would stop you doing this or maybe think twice before starting?

I am working on a project which looks at moving all of an organisations
databases to SQL Server over a period of time. This is not a real project
but we are trying to see how developers would react to the possibility. I am
really interested in the view point of the actual people who may have to do
this.

One of the areas I am looking at is performance and issues surrounding
redesign. for example at the university we have many small Access dbs which
duplicate student data. It would be fairly easy to remove this duplication
by moving them to SQL Server and linking to a core set of data making it
very easy for us to mange this type of installation.

Comments.opinions etc appreciated


Martin

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com