I’m in the process of creating a database at work… the first one I’ve made that others will use. There will be no more then 10 users and we do not have a programmer version. So far I have set up the database with a password on the server. I’ve set up a database on each of two users pcs, linked only the tables they need and imported the queries, forms and reports they need. Then set up each with their own switchboard. Is this the best way to set up with the version we have? Before I started creating this database the company had someone else, who knew less about Access then I, create one and the database became corrupt twice. He had tables set up without primary keys and had users inputting data directly into tables. Of course I want to do the best job I can, but I want to set it up with as much safety as possible. I won’t be there too much long, but I want to leave them with something that works.
So… I’m open to suggestions and thank you in advance for your time and attention.
debbie