Multi Uses Database

[LordHelpMe]

I have a database that has multiple make table queries that mutliple user can run at a given time. Is there a way to make this database multi user friendly? Or would it be best just to place a copy on each users desktop?


Thanks

[June7]

Should split the db. Backend has data and is stored on a common file server. Frontend has table links, queries, forms, reports, code and a copy is installed to each user desktop.

Why do users need to make tables? I handle 'temp' tables by creating and saving them in frontend. Then instead of constantly creating and deleting table, code deletes records.

[LordHelpMe]

I did this way because this database is just for reporting production numbers. There is no updating to this database what so ever. Basically the employee enters a date range in a form selects their name and clicks the button that corresponds to the task. once it done running it pop up with the date and their volume.

[June7]

Data never changes? Okay, give everybody their own copy so each can generate their own 'temp' tables without conflicting.

However, if there are design changes and db must be redistributed, tables created by users will be wiped out when the file is replaced.