[manhattanprjkt83]

With tomarrow being my last day of my summer internship at bayer corporation i am finalizing my summer's work with the access database that i has been my baby for the past 4 months, i now need to secure the database so that it can be opened by all other users but not edited. I have only 1 form that needs to be viewed by the users. Admins must be able to access the full version, i am in a real bind here i cant figure out what to do, 48 hours and counting

knuck any suggestions i know you are a DB guy. Cmon someone...

 

[Morryjg]

Not sure exactly how to do it, but look up "read only" in the help. It talks about giving read only access to forms.

 

[SkaredShtles]

<snip>knuck any suggestions i know you are a DB guy. Cmon someone...

Dude. Access is not *actually* a DB..........



-S.S.-

 

[BikeGeek]

I bet it's something in the security section of the Tools drop-down. Just a guess.

 

[genpowell71]

Ask the IT department. I bet they have an answer for you

 

[Wumpus]

From the wife:

DISCLAIMER: This is using basic property settings of Access. There are ways to program it that are in code, but he doesn't sound like he's got time to get into that.

If he's really wanting to lock a form (& just the form), he needs to go into the design view and open up the properties for the form. Under the 'All' tab, the 8th item down says Allow Edits - select No, next is Allow Deletions and Allow Additions - if noone should be able to make any changes (even adding new records), I'd set them to No also. There's also a Record Lock further down, but if he's got everything else set to No, that one really doesn't come into play.

 

[311miles]

Create a new .mdb file and import the form. Then setup linked tables back to the original. Lock down the new .mdb file and have the users access that(see above post). Keep the original for admins. This way they can't jack with your tables either.

 

[manhattanprjkt83]

Ask the IT department. I bet they have an answer for you

I am the IT department, i have never applied security before though...

 

[genpowell71]

Hello Microsoft, I have an issue...

 

[JRB]

I have been having hell writing queries because of stupid links. It has not been fun. They work now, but I have to get all of my reports done. I need to do some forms too.

 

[binary visions]

I rarely click on threads that end in "NOW!!!!!!" or "RIGHT AWAY!!!!" or the like.. It just seems very demanding and unpleasant - it won't cause people to answer you faster. Just something to think about. Would you answer someone's question if they came up to you and yelled "HOW DO I FIX MY COMPUTER? I NEED HELP NOW!!!"

311miles has the right solution to this. It's a little bit more work, but it is the thorough way of doing it.

 

[JRB]

I need IS to put the friggin tables in Postgress instead of Progress so I can build my reports one friggin time.