Posted by Steve Jorgensen on 11/01/05 10:36

On Tue, 01 Nov 2005 08:09:08 +0000, Trevor Best <nospam@localhost.invalid>
wrote:

>db55 wrote:
>> This is somewhat easy.
>>
>> Basically you need to port or transfer your Access tables to a SQL DB
>> and then link the Access DB/App. to the SQL tables on the SQL Server.
>> If you keep the table names the same, the code etc shouldn't need
>> altering, bu I would test it first.
>>
>
>If only it were that easy :-)

What Trevor is getting at is that it's easy to take an average Access app,
change the tables into links to tables on the server, and have it technically
function. Unfortunately, many of the design decisions commonly built with a
JET back end are not appropriate for a C/S app, and perform dismally in that
context.

• Next in forum: SQL query question
• Prev in forum: Re: Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
• Thread view: Re: Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?

[Reply to this message]