Search results

Ok just had a moment of enlightenment I think. Am I supposed to do this? Send FE to all Users Have them put in folder on their C: Drive Create the shortcut like this: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Databases\Pipeline Report\Pipeline Reports.mde" /wrkgrp...

Ok thanks Keith. That is what I thought should happen from all that I have read here on these forums. However when I do send or have them copy the FE to their desktop...it uses their default workgroup file on their C: Drive. The only way I have been able to get it work so far is with that...

Thanks. Think i missing something to make me understand. See I made a shortcut to the database that binds it to the workgroup file. This allows them to be prompted by a logon. So people have the shortcut on their desktop, is this right? The shortcut: "C:\Program Files\Microsoft...

Hello, I have added this to my database but dont see how it would be used. I have a shortcut people use to access the database which ties in my workgroup file infomation so that they can open it. Now when I send the MDE file to people they get the "dont have permission" typical response. Now...

Found my problem. I needed to create a shortcut that tied my Workgroup Information file with the database. It was using the default on the other workstation. Now it works great... http://www.headwaysystems.com/ShortcutBuilder.htm

For anyone who has used this to make their workgroup shortcuts or anyone who has some insight, what is the difference between: "Open Shortcut Name" - System_Open_Shr and "Compact Shortcut Name" - System_Compact_Shr Does it matter which one I use? Thanks...

Found a great tutorial that helped me make sure everything was set and thought I would share it: Access Security Setup Now I think my problem has come down to one section this part which happens to be at the very end: "Network Notes: If you are creating a database for several users to user...

Ok. I have the database split. It is located on a shared network drive which the test user can access. I am sending them a copy of the FE. The BE and workgroup file are located on the shared drive. I have them set to Full Permission on both the FE and BE. Which is all the checked boxes but...

Ok think I may be onto something. Now I noticed my Workgroup Information file settings as per group permissions is different from the Frontend and Backend. Are these supposed to be the same?

Hello, I cant seem to get a certain setting right. I am trying to setup a user for the database that I have been working on. It keeps saying the following: "It says I do not have necessary permissions to open. Have the system admin. Or person who created the object establish appropriate...

Any luck with turning this on? Without looking around...these spam bots seem to look for a "General" forum...unless there has been others in other forums here. Just noticed there were 2 more in General. Wonder if you changed the name from General to another name...if that would do...

Ok I think I resolved my earlier issues. Now this is what I have: Another person that has the FE can open the database without using a password, but when I try to open on my workstation...it wants the logon information. Anyone know why it is not prompting the other user to login but yet it...

Thank you. From what I read here this is the standard for doing this correct: -Put FE & BE in same folder on shared network drive. -Put workgroup file in the same folder as well. -User copies FE to their desktop. I have split it to see what happens and need to read more about it. So far on...

Hello, Should splitting only be done when all tables,queries,forms,reports, etc. are done. Or can it be done anytime. I am almost to that stage but didnt want to jump the gun and run into problems later on. Thanks. I will have about 20 users sharing this.

Hello, Found this pretty neat tool from a 2003 post: http://www.access-programmers.co.uk/forums/showthread.php?t=53447&highlight=show+logged However while testing it out, I get Error:9 Subscript out of range Does anyone have something similiar they use or any guru know what is wrong with...

Thank you- that did it. I am rather new to access and appreciate the help. Thanks.

Hello, I am figuring this must be an easy question. I have combo boxes setup and working great. I just noticed that I can put my own text into the box and not be limited by just the choices in the combo box. If that makes sense. When I try to lock the boxes then it doesnt allow me to...

Ok think I found it. The column needs to be converted from the old "Preliminary, etc" to the "numbers", like so: It seems to stop after I reselect what is there. That should do, now time to finish this section. Hopefully I should be able to understand it better. Thanks for all the help here.

THANK YOU so much. I am still looking at what you did so I can understand it, but have another question. In the frmMemberDetails, that works great with the drop down boxes....however when I go to move to the next record...it keeps giving me: "The value you entered isnt valid for this field"...

I am having difficulties with combo boxes for some reason and cant get it to work. I have spent this week trying to use examples found here and other places but still not successful. Have looked at the examples on font stuff and have downloaded various examples here on these forums. If anyone...