Re: OT: Guidelines/Standards for supporting non-oracle databases

2002-12-13 Thread Jared Still
By all means, try to use SQL Server rather than Access. SQL Server is much more capable than Access. If by 'small' you mean 'free database servers', consider PostGreSQL or MySQL. Jared On Tuesday 10 December 2002 13:15, [EMAIL PROTECTED] wrote: > Hi, > > We are virtually an Oracle shop with 2-

RE: OT: Guidelines/Standards for supporting non-oracle

2002-12-11 Thread Whittle Jerome Contr NCI
Title: RE: OT: Guidelines/Standards for supporting non-oracle Yechiel, Access 1 had a limit of 100MB. Access 97 had a limitation of 1GB per mdb file. Newer versions are up to 2GB per mdb file. There are ways around it like compacting or splitting the database into multiple MDB files. Of

Re: OT: Guidelines/Standards for supporting non-oracle

2002-12-11 Thread Justin Cave
At 02:15 PM 12/10/2002, [EMAIL PROTECTED] wrote: We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Access,etc within our company. My question is if you were asked to support "s

Re: OT: Guidelines/Standards for supporting non-oracle

2002-12-11 Thread Yechiel Adar
- Original Message - From: Michael Fontana To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 10, 2002 11:44 PM Subject: Re: OT: Guidelines/Standards for supporting non-oracle At 01:15 PM 12/10/2002 -0800, [EMAIL PROTECTED] wrote: Hi,We are virtually an

RE: OT: Guidelines/Standards for supporting non-oracle

2002-12-10 Thread Orr, Steve
Title: RE: OT: Guidelines/Standards for supporting non-oracle You need a corporate data administrator nazi-type technocrat... A "data administrator" god not a mere database administrator dweeb. :-)   Here's a long quote from a Tom Cox article: -

RE: OT: Guidelines/Standards for supporting non-oracle

2002-12-10 Thread Whittle Jerome Contr NCI
Title: RE: OT: Guidelines/Standards for supporting non-oracle Hi, I've made a lot of money over the years fixing Access databases as a consultant. They usually called me after being painted into a corner with a non-normalized, Excel spreadsheet looking thing. I have to diplomatically

Re: OT: Guidelines/Standards for supporting non-oracle databases

2002-12-10 Thread Charlie_Mengler
[EMAIL PROTECTED] Subject: OT: Guidelines/Standards fo

Re: OT: Guidelines/Standards for supporting non-oracle

2002-12-10 Thread Michael Fontana
At 01:15 PM 12/10/2002 -0800, [EMAIL PROTECTED] wrote: Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Access,etc within our company.  My question is if you were asked to

OT: Guidelines/Standards for supporting non-oracle databases

2002-12-10 Thread Rick_Cale
Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Access,etc within our company. My question is if you were asked to support "smaller" databases what restrictions/guidelines