Link to a Query?

  • Thread starter Thread starter Ricoy
  • Start date Start date
R

Ricoy

I have several users (front end?)entering data to a master
file (back end?)
Each user, however, should be able to see only his/her own
records.
What I have done is to put a file containing froms,
queries, reports, etc. in their computers with tables
linked to the master fiel, everything works fine.
The problem is when I have to update a form or a query, I
have to do the same change several times (on each
computer).
My questions is, Is ther a way to link to a query? any
ideas will be greatly appreciated.
 
Hi Ricoy,

The only objects you are able to link to are Tables.

My recommendation would be to make a master copy (not replication) of your
FrontEnd database. Once you make a design change to the FrontEnd database
have the users copy the new FrontEnd overwriting the OLD FrontEnd.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights



--------------------
| Content-Class: urn:content-classes:message
| From: "Ricoy" <[email protected]>
| Sender: "Ricoy" <[email protected]>
| Subject: Link to a Query?
| Date: Wed, 9 Jun 2004 12:31:32 -0700
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcROWF7q3wykDPuyR5uD61oRHmKLsA==
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.queries:203371
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.queries
|
| I have several users (front end?)entering data to a master
| file (back end?)
| Each user, however, should be able to see only his/her own
| records.
| What I have done is to put a file containing froms,
| queries, reports, etc. in their computers with tables
| linked to the master fiel, everything works fine.
| The problem is when I have to update a form or a query, I
| have to do the same change several times (on each
| computer).
| My questions is, Is ther a way to link to a query? any
| ideas will be greatly appreciated.
|
|
 
Back
Top