loading data

[Guest]

helo,
I have an application wich the users linkse to
the tables of the database on the network.
every month i have to load the data from external source.
i want the command will be in the users application to load the database
i not succeed when i use 'refereces' .
can you help me ?

thank you

 

[Joseph Meehan]

helo,
I have an application wich the users linkse to
the tables of the database on the network.
every month i have to load the data from external source.
i want the command will be in the users application to load the
database i not succeed when i use 'refereces' .
can you help me ?

thank you

I would guess your references are not valid (or correct) on the user's
machines. They may be different for each machine. On occasion I have seen
dynamic systems that change from time to time.

Good Luck

 

[John Vinson]

helo,
I have an application wich the users linkse to
the tables of the database on the network.
every month i have to load the data from external source.
i want the command will be in the users application to load the database
i not succeed when i use 'refereces' .
can you help me ?

thank you

References refers to program libraries executed by VBA code - probably
not what you need.

To load data into Tables from external sources, you will need VBA code
using the "TransferDatabase" method. Open the VBA editor and look in
the Help field for TransferDatabase.

John W. Vinson[MVP]

 

[Guest]

thank you all
i found the solution !
append query can append other database,
so i dont have to commend the other aplication.

 

[Guest]

where can i find ' vba editor' ?

 

[John Vinson]

where can i find ' vba editor' ?

Open any Module in design mode; or just press Ctrl-G.

John W. Vinson[MVP]

 

[Guest]

thank you jhon