Search results

So I have the secure FE working fine with the ULS. I just wanted to add some security to the BE so i created the shortcut for the BE and used the same .mdw file that the FE does. My problem is: I can still open the BE directly without being prompted for a password. What am I doing wrong? I'm...

That's what i thought. The objects involved for the permissions says all 4 (read,update,insert,delete) affect tables and queries.

If the update data permission allows deletions then why is there a delete data permission as well? Should I try to make another group? Thanks

I'll check again but i'm certain that the Users group has no permissions. Because when i change the other user group to read only it works just fine. Maybe I am mis-understanding what the delete permissions means. I thought it mean't you can't delete any information in a record. So how does it...

User Level Update Permission still allows delete. Hi, So I have my ULS set-up and I have my group permissions set. I have the user group denied all permissions. All permissions work fine for the read-only user that i have set-up but when I apply the Update permission they are able to delete...

Ok, Thanks HiTechCoach! So I should just import the appropriate tables/forms back into original the FE/BE? I thought I would get everything working and then add it to the split database. Thanks so much!

Hi everyone, Background: I had a split database with ULS and everything was working great. I wanted to add some forms to the database so I thought it would be easier to make a second database that wasn't split. So I brought the FE and BE back together in a separate DB. As you all know having a...

Here's a better shortcut tool.

I'll start you off, here is a great guide to security/splitting.

Search ^ is your best friend! It also helps you learn more about the subject. Plenty of threads with articles, etc. on this topic.

Make sure you link all of your inserted objects instead of embedding them if you want to keep the size down. One embedded image bumped my DB by 60MB. :)

Thanks Bob! That's what i thought but I was hoping.

I am talking about a form, actually a table in sub-form. New>Design View>Using the table with the values I want. The values for the column headings come from the textboxes. Sorry i didn't state that in my first post.

Hi, Does anyone know how to change the column heading height for a table? Thanks so much!

Ok, Thanks guys! I just wanted to get it working if we started having problems on some forms. Mostly just testing the deployed database and getting a feel for it.

I have tried applying record locks to a couple forms and for some reason both users still gain access to the same form no matter what. Does the record locking need to be applied to the BE instead? What am I doing wrong? Thanks so much!

Ok, so I got everything working great! SOS, how did you get the tbl to actually execute? Which part of the code? Thanks so much!

Sorry SOS! After I deleted the autoexec the form didn't pop-up but the tblLog doesn't store log-in information anymore. So how can I keep the autoexec but make the form hidden. And the form that opens is not the form with the log-in information, it's the gray one that states, "This is my form...

Thanks SOS! I didn't want to delete an important part of the form. Sorry for bothering you so much! Thanks

So just delete it?