In a government office I worked, where I was the Development Manager, i had a few "wars" with the administration because they wanted the databases to be in access and the aplications should follow the access structure and not the SQL structure
2011/6/10 Steven Peck <sep...@gmail.com> > You should try our answer.... > > Us - "Sounds like you need to budget for another developer for it" > Them - "But it's business critical" > Us - "Sounds like you should be able to find the funding for a position > then." > > Now, this doesn't actually always work, but it works most of the time > fortunatly. Partly because we actively scan for access databases on our > network shares and then give them our policy which is, we don't support it > please let us know who your business contact is that does so we know where > to direct issue requests too. > > The few occasions tey do make it 'our problem' we help them find the > funding so it can be converted to a more sustainable app on one of the SQL > databases. Then it goes in the end of year reports as a big giant reminder. > > Steven Peck > http://www.blkmtn.org > > On Fri, Jun 10, 2011 at 7:30 AM, Matthew B Ames > <matthew.a...@qinetiq.com>wrote: > >> We have had the “cottage-industry” of Access applications across the >> company I work for too. They are developed by normal staff who then >> leave/move on and then these things chug along for a bit and then start to >> fail and end up in my department for fixing. L >> >> >> >> *From:* James Rankin [mailto:kz2...@googlemail.com] >> *Sent:* 10 June 2011 14:56 >> >> *To:* NT System Admin Issues >> *Subject:* Re: Access form password >> >> >> >> Thanks everyone for all the pointers. However...I think the database is >> corrupted. It can't be repaired, you can't view the database properties, it >> throws an index error every time - and according to Google, that points to a >> database "corrupted beyond repair". Even though the users are still managing >> to utilize it. Somehow. >> >> >> I think I may try to use this as the starting point for a larger project >> to get the myriad small Access databases dotted around the place >> consolidated into a single SQL-based system with proper maintenance and >> authentication etc. >> >> I am so glad it's Friday afternoon :-) >> >> On 10 June 2011 14:52, Daniel Rodriguez <drod...@gmail.com> wrote: >> >> It may help if you could see the contents of the .df files. There are some >> free viewers. DBFPlus comes to mind. You may also need to convert those .dbf >> files. DBFConvert probably do the trick for you. That way you dont have to >> go hunting for an older version of Access. Then I use a hex editor to look >> at those forms. Also, I would look at any vba scripting files, if any. >> >> But, that's me. >> >> Typed not so frustratingly on my Dell Streak 7. >> >> On Jun 10, 2011 9:01 AM, <roberto.gri...@gmail.com> wrote: >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to listmana...@lyris.sunbeltsoftware.com >> with the body: unsubscribe ntsysadmin >> >> >> >> >> -- >> "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into >> the machine wrong figures, will the right answers come out?' I am not able >> rightly to apprehend the kind of confusion of ideas that could provoke such >> a question." >> >> *IMPORTANT: The information in this email is CONFIDENTIAL. If its >> contents are disclosed in any way my lawyers will swoop down from black >> helicopters like Seal Team Six and drag you away with a black bag over your >> head. They will then take you to a secret prison and make you fight to the >> death with other people who dared to share this email. You will be given a >> large bowie knife and a supply of methamphetamines while I watch the said >> deathmatch and wager vast sums of money on who will be the winner. If the >> fight becomes boring or there is a stalemate, I will release rabid dogs and >> my two-stone cat into the arena to liven things up a bit. If these animals >> become in any way docile, I will squirt them with water pistols until they >> become a bit more temperamental.* >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to listmana...@lyris.sunbeltsoftware.com >> with the body: unsubscribe ntsysadmin >> >> This email and any attachments to it may be confidential and are intended >> solely for the use of the individual to whom it is addressed. If you are not >> the intended recipient of this email, you must neither take any action based >> upon its contents, nor copy or show it to anyone. Please contact the sender >> if you believe you have received this email in error. QinetiQ may monitor >> email traffic data and also the content of email for the purposes of >> security. QinetiQ Limited (Registered in England & Wales: Company Number: >> 3796233) Registered office: Cody Technology Park, Ively Road, Farnborough, >> Hampshire, GU14 0LX http://www.qinetiq.com. >> http://www.qinetiq.com >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to listmana...@lyris.sunbeltsoftware.com >> with the body: unsubscribe ntsysadmin >> > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to listmana...@lyris.sunbeltsoftware.com > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin