|
Home > Archive > MS Access Multiuser > April 2005 > delete redundant data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
delete redundant data
|
|
|
| I would like to request your help is finding the best practice solution for
this situation:
Setup: Condominium complex consisting of three buildings, each having its
own access database (mdb file)
However the mdb file for one of the buildings has the information for all
the three buildings
Requirement: to remove the information of the other two buildings.
Solution as I see it: I thought the easiest way to do this is to create a
new mdb file and export the data of this one building only.
Is this possible and if yes how would it affect the six workgroup computers
once the new mdb file goes live? Presently they just click on the shortcut
to the file on the workgroup server.
Will creating the new mdb file require some special references or links to
be created? My choice of words may be misleading, so please excuse me.
If this is possible, is there a step by step solution you can link me to?
Thank you in advance.
JJoe
| |
| Klatuu 2005-04-22, 8:24 pm |
| Why not just do a delete query that will delete the data for the other two
buildings?
"JJoe" wrote:
> I would like to request your help is finding the best practice solution for
> this situation:
>
> Setup: Condominium complex consisting of three buildings, each having its
> own access database (mdb file)
>
> However the mdb file for one of the buildings has the information for all
> the three buildings
>
> Requirement: to remove the information of the other two buildings.
>
> Solution as I see it: I thought the easiest way to do this is to create a
> new mdb file and export the data of this one building only.
>
> Is this possible and if yes how would it affect the six workgroup computers
> once the new mdb file goes live? Presently they just click on the shortcut
> to the file on the workgroup server.
>
> Will creating the new mdb file require some special references or links to
> be created? My choice of words may be misleading, so please excuse me.
>
> If this is possible, is there a step by step solution you can link me to?
>
> Thank you in advance.
>
> JJoe
>
>
>
| |
|
| Hi Klatuu,
Thank you so very much for responding to my post...your suggestion worked!!
JJoe
"Klatuu" <Klatuu@discussions.microsoft.com> wrote in message
news:525055F8-E648-433C-8C1E- BCDE1480EECA@microso
ft.com...[color=darkred]
> Why not just do a delete query that will delete the data for the other two
> buildings?
>
> "JJoe" wrote:
>
|
|
|
|
|