They have Access installed. The number of office people is low. There is just a lot of turnover. I bookmarked the homepages. I hadn't come across those before.
I got them up and running. They had 30 corrupt records. I used AccessFix, because I couldn't open it any other way. AccessFix removes the PK, defaults, and input masks. At least I know now who to contact when this happens again. Bryan --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > If your people do not have Access installed on their PC's, you may want to look into doing a run-time install so they still can use the front-end on their own machines. I've done it with the Wise Installer and a Sagekey script, which are somewhere around $800+ in themselves, but a lot cheaper if you have a good number of people who would otherwise need to have Access installed. > > Tobi > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of stomper57 > Sent: Tuesday, August 09, 2005 3:30 PM > To: [email protected] > Subject: [AccessDevelopers] Re: Delete .ldb > > > Hi Glenn, > > Several people are using the same login and I agree that > it's a security nightmare. I believe that this is the > source of all(if not most) the corruption at this site. > For some reason Access has a problem with the same user > in the same database at two different PC's both up and > running :) > > I've tried to convince management that everyone should > have thier own login, but they don't want to. It costs > $78 per person and we have a lot of temp labor. The > database was down two days while I was trying to contact > the administrator. Which cost is greater? > > It is very possible the users are using the fe directly. > I am not on site, so I can't monitor what they are actually doing. I have the fe zipped on the server so they don't have ready access. On the desktop of the main computer > they use is the entire fe unzipped. > > I have noticed that when a user has a form open a .ldb > is created in both fe and be. > > Bryan > > --- In [email protected], "Jones, Glenn P MSG (Ret) FL- ARNG" <[EMAIL PROTECTED]> wrote: > > Hi Bryan, > > Something that sticks out to me is that you have several people > logging in > > with the same user account. This is a security nightmare. I do > not know > > exactly how Access handles the login with the .ldb file. If it > uses user id > > then that could cause a problem. If it uses IP or MAC addressing > then there > > should be no problem. > > You also said that there was one user that seem to lock it down. I > would be > > very suspect of that user and the version and table linkage. Do a > search > > and make sure that you only have one .ldb out there. > > If you are using fe/be then the .ldb file should be only on the > user's pc > > and not on the server. I keep a copy of the front end on the > server for > > users to download to their pc if they have problems or if there is > an > > upgrade. If you have an .ldb on your server then you have a > problem there > > and it sounds like a user is maybe using a front end on the > server. Is that > > possible in your situation? > > Maybe someone else can shed some more light on this. Bottom line, > you > > should not have to worry about deleting the .ldb file, but I guess > you > > already figured that one out. > > > > Be sure to let us know your final solution. > > > > Glenn P. Jones > > > > > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of stomper57 > > Sent: Monday, 08 August, 2005 8:51 AM > > To: [email protected] > > Subject: [AccessDevelopers] Re: Delete .ldb > > > > > > Thanks. Right now I'd try just about anything. I'm still waiting > on the > > system admin to kill the lock. > > > > Bryan > > > > > > --- In [email protected], "A.D.Tejpal" <[EMAIL PROTECTED]> > > wrote: > > > Bryan, > > > > > > If everything else fails and the ldb file proves too stubborn, > > following course of action could be tried so as to delete the file > > without resorting to re-booting of computer. > > > > > > Press Ctrl + Alt + Del so as to invoke the Task Manager. In > the > > Processes tab, select msaccess.exe and click End. It should now be > > possible to delete the ldb file. > > > > > > With best wishes, > > > A.D.Tejpal > > > -------------- > > > > > > ----- Original Message ----- > > > From: stomper57 > > > To: [email protected] > > > Sent: Friday, August 05, 2005 20:28 > > > Subject: [AccessDevelopers] Delete .ldb > > > > > > > > > Hi, > > > > > > I have a split fe/be database that is locked up. It can't open > > > because of an unrecognized database format error. Everybody > that > > uses it is logged off. I had each user try opening and closing > > > the database to release the lock with no luck. > > > > > > I've tried to delete it directly and the .ldb doesn't delete. > > > What is the best way to remove the lock? > > > > > > Bryan > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > Yahoo! Groups Links > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hsv3lqk/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123625955/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
