Distributed applications

[TomSin]

Hello,

I am developing an Access 97 application for users on our network.

Some users need read/write access while other need just read access but may want to develop their own queries and reports. I can assign the correct permission using the workgroup feature.

To do this I was going to have a main database with the data tables on the network and then install a copy of the database on each user's pc. The copy would have the main database tables linked in. This way they are all accessing the same data but any queries and reports they create reside within their own individual copies of the database. The main database base contains only the original tables, queries. reports etc... that were developed as part of the application.

My questions:

Linking the tables will slow performance. Is there a way to speed it up.

Also, from a best practices standpoint is this the best way to do this.

Also, for enhancements. What is the best way to update each user's version with the latest version of the application.

Thanks

Tom

 

[Cosmos75]

Splitting Database?

Is that the same as using the Split Database command?? I have a database already done. Will splitting the database create all the links? Also what happens it I need to change locations of now-seperate two files??

I apologize if these are stupid questions but I am self-taught and never quite sure if something I've never done before is simple or difficult to do.

 

[Alexandre]

Is that the same as using the Split Database command

Yes

Will splitting the database create all the links

Yes

what happens it I need to change locations of now-seperate two files

There is also a menu item called re-link tables (or is it linked tables manager...?)

 

[Cosmos75]

Great job!!

Alexandre,

You are just on fire today with helping me out!

Thanks, buddy!

 

[Rich]

I have read that some keep lookup tables on the front end to improve performance, if that's the case how would you be able to add to them?