Insert in to access database

[Jpmill]

Hi , I have two acess database.In the first DB I have a form where I
can enter, as an example, client information. Those clients are
inserted in a table in that database but I want that information to be
inserted at the same time in another access database on the same
computer. Is it possible?

 

[Douglas J. Steele]

It's possible, but it's not a good idea.

Why do you feel it's necessary to store the data redundantly? Can't you just
share the same table between the two applications?

 

[Jpmill]

It's possible, but it's not a good idea.

Why do you feel it's necessary to store the data redundantly? Can't you just
share the same table between the two applications?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)






- Show quoted text -

The answer is that two people here have their own database for a long
while and they do not want to change the way they work...Ans also I
only want some f the filed in the table to be inserted in another
table that has not the same structur at all :

Example : Table client has : name, adress , tel
Table client_2 has : adress, customer email and
description.

I want the acesss form to display the information of table #1 but when
you enter a new client in table one I only want the address to be
inserted in the client_2 table.....

 

[Jpmill]

The answer is that two people here have their own database for a long
while and they do not want to change the way they work...Ans also I
only want some f the filed in the table to be inserted in another
table that has not the same structur at all :

Example : Table client has : name, adress , tel
                Table client_2 has : adress, customer email and
description.

I want the acesss form to display the information of table #1 but when
you enter a new client in table one I only want the address to be
inserted in the client_2 table.....- Hide quoted text -

- Show quoted text -

I suppose I will have to do it with VBS on the "after update
event"?????

 

[Douglas J. Steele]

Well, it would be VBA, not VBS, but yes, you'll have to do it in code in the
AfterUpdate event.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The answer is that two people here have their own database for a long
while and they do not want to change the way they work...Ans also I
only want some f the filed in the table to be inserted in another
table that has not the same structur at all :

Example : Table client has : name, adress , tel
Table client_2 has : adress, customer email and
description.

I want the acesss form to display the information of table #1 but when
you enter a new client in table one I only want the address to be
inserted in the client_2 table.....- Hide quoted text -

- Show quoted text -

I suppose I will have to do it with VBS on the "after update
event"?????