Access Database Help

  cortez© 17:32 28 Jan 2007


I have a simple MS Access database that has a nice an simple Import routine, whereby an excel file is imported when the user clicks import. Would it be possible for me to somehow log the path of the excel file that has been imported and record the windows user name that performed the import, in a simple report or table - E.g.


Thanks for any help.

  cortez© 19:00 28 Jan 2007


  cortez© 20:02 28 Jan 2007


  Woolwell 21:56 28 Jan 2007

Since nobody else has relied yet - my guess is that you will have to use VB Basic.

  cortez© 17:51 29 Jan 2007

Yup im thinking so too. Can anyone offer some advice to record these required values via VB and store them in a table.

  Chris the Ancient 18:04 29 Jan 2007

Not an answer - but a way to go...

click here

Is probably the best. You will need to register - but it's free. And threads there are usually fairly quick.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?