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-
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
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
- 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
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:
-
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
[EMAIL PROTECTED] Subject: OT: Guidelines/Standards fo
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
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