Access Database Help

  cortez© 17:32 28 Jan 07


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 07


  cortez© 20:02 28 Jan 07


  Woolwell 21:56 28 Jan 07

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

  cortez© 17:51 29 Jan 07

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 07

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now