Updating User Interfaces

[SuddathAL]

I have built a DB for myself and 4 coworkers to use. I am getting ready to implement the "User" front ends (the DB is split, and I have the main Front End with all of the goodies on my machine) next week. I was wondering if i create a new report or form, can I send just the form or will I need to send a whole new Front End file?

Also, is there a way to protect the tables with a password that does not effect the data entry functions. I put a password in place and then was unable to open anything in the FE Application.

I am completely self taught (as i am sure most of you are) but I don't speak "Computer," so please treat me like an idiot with your explanations.

thanks a lot.

 

[revver]

You don't say what version you are using. That sometimes helps.

The Front end is an entirely separate file. You could apply updates to every copy of it but it is much easier to replace each file with an updated copy. That way you can also know that all are exactly the same as the master. Also, if you compact it each time before you deploy then you maintain the most efficiency for everyone.

I don't know a lot about security in split databases. If I found myself in your situation I would apply any security settings before splitting the database. Let Access take care of it.

 

[SydneyGeek]

Also, is there a way to protect the tables with a password that does not effect the data entry functions. I put a password in place and then was unable to open anything in the FE Application.

Do the following:
1. Delete ALL table links (you have to do this one at a time, and confirm each one)
2. Create new links to the backend. When you browse to it you will be prompted for the database password. Provide the password and the links will be created. You will now be able to use the tables for data entry.

Denis

 

[HiTechCoach]

See:

Splitting your Access database into application and data