Deploying Database in nodes

[puthenveetil]

Hi all,

I had a database which is going to be used by 20 users. Which is the best way to deploy that in user's pc's.

1. By splitting the db to FE/BE and copy the FE to all the user's pc's
or
2. or create a shortcut of the db and copy that to all user's pc


Thanks in advance


Thanks

 

[M8KWR]

you could have the main mdb file with the table in a central location.

Create another mdb file, where you forms queries report are kept, and then link this to the other mdb file. Then create an mde file of this mdb file, and post that out to the users.

This way you can make changes to the forms, queries, and report, and it does not affect the users, you would then just update the file and the end of the day, and use if the following.

The only time you would have to kick people out of the database is if you were going to alter the table designs in any way.

Hope this help, please let me know if you need any further assistance