Any book that explains splitting the Microsoft-access database in detail

[hrghauri]

Hi,



I am developing an access application which I plan to put on a network drive. This application will be used by 5-10 people. Some of my forms are bounded while some are not. I have sub forms as well which are obviously put on the bounded forms. From all the research I have done, unbounded forms are more efficient but demands more coding work. As a result, connecting them with sub forms which should get updated as soon as I move to the next record will be more complex.

I have a very vague idea of ADO or DAO , Recordset, CurrentDb and the connection objects.


I would like to read a book which properly explains the above terminologies. And it should ALSO PRIMALIRILY talk about the practices to follow when planning to split up the database on a network drive. Any suggestion?

[ssanfu]

For splitting a dB, see

http://www.kallal.ca/Articles/split/index.htm
http://www.techrepublic.com/blog/10-...cess-database/
http://www.fmsinc.com/MicrosoftAccess/DatabaseSplitter/ '****


DAO and ADO see
http://www.utteraccess.com/wiki/inde...en_DAO_and_ADO

[RuralGuy]

This thread would not be complete without my favorite MultiUser link: http://www.accessmvp.com/TWickerath/.../multiuser.htm

[hrghauri]

Thanks to both of you. I will go through these concepts now