Access 2000 on a wireless NAS

[mikewelsh]

I want to set up a simple wireless 'network' but without a convential server. Up to 10 windows 7 PCs wirelessly connected to a router with a Raid 0 NAS drive connected to a LAN port for shared files.

An Access 2000 database (8Mb) is the only intensive application that will be accessed. Is there any particular way I can set it up so that it is accessed in the most efficient way?

[HansV]

Welcome to Eileen's Lounge!

I'd split the database into a backend containing only the tables and a frontend containing links to the tables in the backend, plus all queries, forms, reports, macros and modules.
Place the backend on the NAS drive, and give each user/PC an individual copy of the frontend.

See Wendell's tutorial Why split a database for more info.

[mikewelsh]

That looks very helpful. Many thanks.