Question on making an accde

[itm]

Hi,
I need to distribute my Access application (2007) so that about 5 users may use this at once. However, I always heard that you have to split the database and then make the accde. However, in this case, I would prefer not to split the database if I can avoid it.
Do you have to do this? Or can you just make accdes and distribute them of the one database?
Thank you

[pbaldy]

You can let them all use the same database, as long as you have a very aggressive backup strategy, because multiple users sharing a database will often (usually?) corrupt the database.

In other words, I would strongly recommend splitting it.

http://www.granite.ab.ca/access/splitapp/index.htm

[itm]

For my edification, what does spliting the database do. I not found anything that explains this.
Thank you

[pbaldy]

Did you see the link?

[itm]

Yes, they tell me the posible things that can happing, like curuptions, but it doesn't tell me how spilting the database works to prvent it. But it is a good link for other info, and si the best I see sofar.
The reason that i do not wnat to so that is because I have a few tables that are dynamicly created in SQL statements, and so I woudl have to leave them; and I do not know how this would work out.
Thank you