Re: Is it possible to link to tables in multiple databases??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 08:25:38 -0600

tlyczko wrote:
> I have 2 or 3 different Access front ends that would like to link to
> one 'common' table of data used by these front ends and the tables
> specifically associated with these front ends.
>
> They would all be on a server.
>
> Is this possible, and are there any caveats or gotchas involved with
> this??
>
> These are presently Access front ends to Access databases, but one or
> more of the tables might go into SQL tables accessed by Access
> projects.
>
> I imagine that I have to keep it clear what kinds of front ends are
> accessing the 'common' table of data.
>
> Thank you,
> Tom

There is no problem with multiple front ends connected to a single back end.
That is in fact the preferred setup for multiple users. The only caveat
with one front end to multiple back ends is that you cannot enforce
referential integrity between two tables that don't reside in the same
database and (I think) queries between such tables cannot be optimized and
might run slower. Other than that there is no problem.

My main application has links to Text files, Excel files, Two different SQL
Servers, an IBM ISeries database, and I believe one Jet file. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: Newbie ? using multiple users in one database at same time
    ... Since you are worried about multiple people opening the same table at the ... gathers the info into a SQL statement and performs an insert into the table. ... Database should be pretty simple: ... When ever a bag of cash is brought into the secure room and given to one ...
    (microsoft.public.access.gettingstarted)
  • Toad for SQL Server 2.0
    ... The Toad Database Browser allows you to effortlessly switch between ... Performing multiple server administration from a single interface is ... Toad's SQL Optimization for SQL Server is the most comprehensive ...
    (comp.software.shareware.announce)
  • Re: dataadapter.Update() multiple table update strategies
    ... You can do it with one dataadapter. ... This returns a table to your database. ... the updates code for your SQL transact procedure. ... Or should I create multiple data adapters for each SQL table UPDATE I need ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dataadapter.Update() multiple table update strategies
    ... not much on HOW to submit a massive update to a transaction sproc. ... block with all the needed SQL. ... Am I supposed to not do SQL joins, but instead pull my whole database ... Or should I create multiple data adapters for each SQL table UPDATE I need ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: formatted SQL output
    ... There are many tools for SQL. ... What these tools generally have in common is they offer a painless way ... connect to an SQL database on Tandem, ...
    (comp.sys.tandem)