RE: Scanning for new tables in a Back End (BE) database

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

Now that I read that, that is just utterly f*****up. I'd probably go with a
startup routine that deletes all linked tables and then relinks to all the
tables in the back end. I'd then modify the process by which a new table is
added to automatically send out an email notice via Outlook advising the
users so that they know to shutdown and restart (if they choose).

"Ben" wrote:

Hi David,

HOW do the users a table to the backend using the frontend? Are you referring
to users linking to existing tables that they weren't previously linked to or
to users actauly creating a new table.


I am referring both. The reason is that the application is actually a
vendor app and the database was badly designed. I was called in to create a
front end process to mitigate, but when I was shock when I learned that new
vendors this application stores has to be in the form of a new table. That
means every vendor the firm uses, past present and future has to be in a
table of it's own. Since this is being used by end user, they have to be
able to add new vendors to the database.

But if user one adds a new table to the BE and then creates a link, the link
is not in the other FE's table definition that are used by other users. Each
user have a a copy of the FE. So I would have to do a scan each time, so
that each FE is updated with a new link to any new BE table. It's crazy.

Thanks,

Ben

--



"David H" wrote:


Sometimes, a user through the FE could add a new table to the back end.

As Mr. Steele stated, there are concerns with this, however my questions is
HOW do the users a table to the backend using the frontend? Are you referring
to users linking to existing tables that they weren't previously linked to or
to users actauly creating a new table.
.

Relevant Pages

  • RE: Scanning for new tables in a Back End (BE) database
    ... to users linking to existing tables that they weren't previously linked to or ... I am referring both. ... vendor app and the database was badly designed. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Poly Couples
    ... If you want to claim that OO is the consolution prize for lame database ... there is a metamodel which describes the hierarchy. ... Metamodel is stored in SQL, however, the data is stored in non ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: Poly Couples
    ... business software" example mentioned in this thread. ... But the communication mechanism with the database remains the same. ... That doesn't mean that other languages (such as sql, ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: Need expert coding help with a debugging issue.
    ... If you are declaring by default a recordset or database as a variant you may not get the hoped-for result. ... even if it works to jump to End With (at LocationEnd), ... code that tells the user exactly which bin location he or she should put the ... The bins are sorted by vendor. ...
    (microsoft.public.access.formscoding)