Re: Guide for switching to .ADP from .MDB

Hi ,
If I am correct then you are opting for this option in migrating the
MDB application
"Create a two-tier application. (front-end/back-end application)".
Create an Access database front-end to an SQL Server database back-end
so that you can create a front-end/back-end application. The main
advantage of this migration method is a low transition cost because no
modifications are needed to the front-end database objects.Also this
approach requires very little application modification since the code
is still using the Jet database engine. Users continue to interact
with a familiar interface, and the SQL Server provides centralized data
storage, backup and recovery options, a multi-user environment, an
integrated security model, and other advantages. But the main
disadvantages and the biggest drawback of this method are that queries
are still processed locally, and a large amount of network traffic is
generated. So ADP is the best approach on ecan opt for when migrating
an MDB application from Access to SQL server.

Regarding teh upload problem related to the two tables will the import
data feature of SQL do the task for migrating the data from the MDB to
SQL. I had done that in the same manner when the Upsize functionality
failed to upsize 3 of the tables in an application.

thanks
sd_

.

Relevant Pages

  • Re: Optimization of data migration
    ... I read the article and got puzzled by the "source physical file". ... something equivalent when migrating to SQL Server? ... database and copy the data "as is" in a staging database. ...
    (microsoft.public.sqlserver.dts)
  • Occasional ODBC Timeouts From Access 2000 When Writing Record
    ... I just inherited a database that has an MDB client (front-end only) accessing ... records on SQL Server 7. ... update a record it will timeout giving the ODBC timeout error, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Moving to MS SQL
    ... Personally-- I thnk that RAID5 should be reliable enough. ... One additional major point is security: SQL Server can be much more ... Availability also has other aspects, such as redundancy, database ... migrating to SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Guide for switching to .ADP from .MDB
    ... >Create an Access database front-end to an SQL Server database back-end ... and the SQL Server provides centralized data ... >an MDB application from Access to SQL server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiuser Interface on shared servicer with SQL Backend
    ... front-end, and that they have only ONE intance of it open on their pc. ... I agree with Tony that this doesn't look like a SQL Server issue at ... The database has been placed in a state by user 'Admin' on machine [computer ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
Loading