Re: access and sql

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 12/22/04


Date: Wed, 22 Dec 2004 10:50:43 -0500

You can't make SQL Server the front-end, at least not with commonly
accepted definitions of the terms front-end and back-end. If you are
trying to link to a Jet database from SQL Server, see SQL BooksOnline
in the "Adding a linked server" topic.

--Mary

On Tue, 21 Dec 2004 13:19:40 -0800, vincent arntjen
<arntjenvincent@hotmail.com> wrote:

>
>hey,
>
>i want to use access as a back-end database and sql as front-end .
>
>i already made the entire access db but not the db in sql !
>
>how do i start ???
>
>THANKS IN ADVANCE
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Re: Pros and Cons of SQL v/s MDB
    ... do you know of a backup system that can be ... >that can have over 100 users on the same back-end. ... >Now, up-sizing to SQL server is often, bu not always the ... >>After the last corruption, which was recovered by ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A97 to SQL?
    ... You could migrate your data to a SQL-Server back-end, and link to your data there. ... You might have to redevelop portions of your front-end to work better with SQL-Server data. ... I am starting to wonder whether the time has come to move to something bigger, like SQL server. ... Currently I am regularly adding little enhancements, new reports, etc etc, to the A97 mdb FE, and it's very useful that I can do this. ...
    (microsoft.public.access.conversion)
  • Re: Logging queries against a .mdb
    ... If you could somehow use an ODBC driver to access the back-end, ... back-end with one that has linked tables to SQL Server tables, ... is there a way to log queries (SELECT, ...
    (comp.databases.ms-access)
  • Re: SQL Server 200 Developer vs Enterprise versions
    ... cannot overcome these we will revert to Access back-end. ... the licenses will be acquired for Enterprise ... to an SQL Server back-end. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Pros and Cons of SQL v/s MDB
    ... With 20 to 30 users at its peak, Access with a shared JET back-end is not ... a SQL Server back-end can be a good option. ... and run periodic queries to update the OLAP system. ...
    (microsoft.public.access.adp.sqlserver)