Re: How to programmatically refresh linked tables

On Apr 27, 2:47 am, Chuck <libb...@xxxxxxxxxxxxxx> wrote:
On 23 Apr 2007 17:29:30 -0700, bubbles <bubbles....@xxxxxxxxxxx> wrote:





On Apr 21, 9:28 am, "(PeteCresswell)" <x...@xxxxxxxxx> wrote:
Per bubbles:

Links will be added over time.

Then your original statement of the situation raises a flag with me.

How are the users executing the application in question?

Does each user execute their own copy of the app on their own PC? Or are they
hitting the same copy concurrently over the LAN?
--
PeteCresswell

1. There will be new tables to be linked over time.
2. Each user has their own copy of the app on their PC.

The app need to be able to add new links when the new tables appear
(due to the launching of new products).

I need to find a way to automatically link these new tables as they
come into existance.

Bubbles

Do I understand correctly? A customer wants you to design a database program
such that after the design of the program is completed, the customer can make
changes that neither of you know about at this time, and have the original
program find the changes, make necessary modifications or add new:
relationships, queries and reports as may be required - all automatically. I
hope the customer is paying you a kings ransom for this job.

If I understang correctly, in order to make the sort of change the costumer
wants, the 20 or so users must all be running mdb programs. I would be
concerned about the users *tweaking* their individual copies of the program and
possibly doing damage to the back end.

Chuck
--- Hide quoted text -

- Show quoted text -

No, users will not be expected to modify the design.

The tables will be added dynamically at the SQL Server end when new
products
comes into existance -- this product info is pulled from another
remote server
periodically. When new products come into existance in the remote
server,
a TSQL statement will create the new tables.

That is why I am trying to find a way to link these tables
programatically, without
user intervention.


.

Relevant Pages

  • User autentification and access to "sister" domain resources
    ... I am in process of designing brand new AD structure for our customer. ... 2003 Servers - pretty classic design ... All DCs are Global Catalogs. ... user_from_domainA gets IP address from siteB DHCP server ...
    (microsoft.public.win2000.active_directory)
  • User autentification and access to "sister" domain resources
    ... I am in process of designing brand new AD structure for our customer. ... I propose a design with root domain and three child domains all with Windows ... All DCs are Global Catalogs. ... user_from_domainA gets IP address from siteB DHCP server ...
    (microsoft.public.windows.server.active_directory)
  • Re: A Quality Penetration Test
    ... When I wrote about vulnerability scanners and vendors that rely on them for penetration testing someone asked me to comment on how a real penetration test was better. ... This entry is a sanitized description of a real Advanced External Penetration Test that our team delivered to a customer. ... We were able to use those unchecked variables to penetrate into our Customer's Web Server and take control of it. ...
    (Pen-Test)
  • Re: defining quality of OOA and OOD models
    ... must be done) while an OOA model describes the solution (How it should ... Using the term "analysis" to mean "design" should, if nothing else, not ... bridge the chasm between customer problem spaces and the computing ... the problem space abstraction that dominates OOA is ...
    (comp.object)
  • VUI Designer Position available with eLoyalty
    ... eLoyalty Corporation is a leading management consulting, ... eLoyalty's broad range of enterprise Customer ... This creative and detail-oriented individual will design and consult on ... conversational speech applications, working to achieve exceptional ...
    (comp.speech.research)