Exporting to Excel for Multiple Users

[martin DH]

Hello,
I've hit a mental roadblock and could use some design ideas if anyone is willing.

Access 2003, Windows XP Pro
In my database is a form (HOME) that is filled with command buttons that run queries and macros. For example, a button will ask the parameters of a query to produce filtered data and the macro runs to Export the data to an Excel spreadsheet in a central location (Z:\liveReport\Export.xls). The point of this process is that a user can export filtered data to Excel for further analysis and manipulation instead of having to work with every bit of data in Excel.

My problem is this: I have four to six users of this database and I don't want one user to export data to Excel and overwrite data in Excel from another user.

One idea: Find some way that the user can identify him or herself, then export the filtered data (some sort of log-in screen?) - the problem here is I do not want several near identical HOME forms, each opening with a different user login and each with different Export paths.

Hopefully, I've conveyed this so it's understandable - if not, let me know. Thank you for any and all ideas!

[Stang02GT]

Here is an idea if you would like to try it


Create an excel file for each user. Then link these spread sheets into access so that show up as tables. Once you have done this you can make a main screen where the users can select their name ( you could put a password on it too i think) after they select their name it takes them to a form where they can add, edit do whatever it is you are having them do.

If you like that tables and do it like this then that user will only be able to make changes to the spread sheet that you have linked into access and built a form for.


I might be totally off base here and im sure there is probably a better way to do this but this is the first thing that came to mind when i read your post.