Locking forms but not data

[ankrumc]

Hi,

I'm trying to find an easy way to keep all form designs safe and un-editable and let someone just use a program to edit the data. I'd ideally like to have a password protection on the design and all of those pieces, but still keep the data editable to anyone who is using the program.

Thanks for any and all help!

 

[boblarson]

1. The database should be split with the backend (tables only) on the server and

2. A COPY of the frontend on each user's machine.

3. You can create an MDE or ACCDE file so that changes can't be made to the structure of any form, report, code, or macro.

 

[ankrumc]

I'll give it a shot thanks!

 

[ankrumc]

Thanks Bob. It says I can't beef up your stats and I have to spread the love around, so I'll just say thanks a bunch. You've helped me a ton.