Re: Networking

Linking an ADP is no different than linking an MDB to SQL-Server or any
other RDBM for front-end changes. It isn't easier at all since if one moves
the server, because one needs to build a new DSN or rewrite the connection
strings, and one only needs to relink to the native JET DBMS.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<aaron.kempf@xxxxxxxxx> wrote in message
news:4cb4f3b0-5ad5-4f67-bbaa-a1860bbc2ca6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
yes, if you change a table, then you've got to relink it in 5
different places.

that is why it is considerably easier to move to SQL Server / ADP.

-Aaron



On May 8, 3:55 am, Roger Bell <RogerB...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I have designed a data base which I wish to install on 5 remote computers.

My idea is to link the Backend (Tables). My question is if i change any
reports/mailing labels etc on the server data Base, do I then have to
change
the design on each of the remotes.

Is there any difference between splitting and linking, or is there a way
to
change any report designs that will automatically update on the remotes.

Many thanks for any help


.

Relevant Pages

  • Re: A hyperlink keeps changing randomly
    ... Linking to an image on another server is called hot linking, ... It is better to copy the image and place it on your own server. ... Some will have the extra stuff before href= Some will have> the l removed from the .html? ... I'll post a> reply to myself here to let you know at least what's happened with the repair. ...
    (microsoft.public.frontpage.client)
  • Re: Table linked to ODBC
    ... linking or importing data from ODBC? ... If you want to see updates in real time then linking is better. ... Change the PK type on the server. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: Cant link Excel ranges to Powerpoint
    ... The links are being performed on a server. ... hotfix for Office 2007 to fix linking on a server. ... These are not linking. ... The hotfix that relates to bookmarks might also fix this problem. ...
    (microsoft.public.powerpoint)
  • Re: Access 97 linked to SQL 2000 large fields problems
    ... from further searching it appears that Access 97 linking to SQL ... Server 2000 has this problem when there are "spaces in the fieldnames" ...
    (microsoft.public.sqlserver.odbc)
  • Re: Problem with updating external links
    ... is somewhere on the server ... Each month we save the info into a new folder for that month. ... it is extremely slow. ... linking to a cell. ...
    (microsoft.public.excel.misc)
Loading