Insert in to access database

  • Thread starter Thread starter Jpmill
  • Start date Start date
J

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?
 
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?
 
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 -
Click to expand...

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.....
 
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 -
Click to expand...

I suppose I will have to do it with VBS on the "after update
event"?????
 
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 -
Click to expand...

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