Title: RE: MS Access
ACCESS-L. For subscription/signoff info and archives, see
http://peach.ease.lsoft.com/archives/access-l.html .
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: viraj2 [SMTP:[EMAIL PROTECTED
] mailto:[EMAIL PROTECTED]
618-622-4145
-Original Message-
mailto:SMTP:[EMAIL PROTECTED] ]
Hi all,
I was wondering if any one out here knows if there is a good list (mailing
list) for discussing MS Access problems. I am specifically looking for
migrating/converting
Hi all,
I was wondering if any one out here knows if there
is a good list (mailing list) for discussing MS Access problems. I am
specifically looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to convert such a database
viraj2 wrote:
Hi all,
I was wondering if any one out here knows if there is a good list
(mailing list) for discussing MS Access problems. I am specifically
looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to convert
viraj2 wrote:
Hi all,
I was wondering if any one out here knows if there is a good list
(mailing list) for discussing MS Access problems. I am specifically
looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps
Hi all:
My developers are having problem when running a
path-through query with parameters via Access against
Oracle. Does anyone happen to know a way to do it
(or a reference to explain it)?
thanks
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
been hearing from many people that MS Access
is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus moving way too much data over the network.
Assuming that this is correct, what is the mechanism
of this? If I execute a simple query like
Hi all:
I have been hearing from many people that MS Access
is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus moving way too much data over the network.
Assuming that this is correct, what is the mechanism
of this? If I execute
recipients of list
ORACLE-L [EMAIL PROTECTED]
cc:
Sent by: Subject: RE: MS Access as a front-end
to Oracle DB
Hi all:
I have been hearing from many people that MS Access is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus moving way too much data over the network.
Assuming that this is correct, what is the mechanism
of this? If I execute
the docs on OO4OLE. It's a
very nice toolset when working with MSOffice apps.
On Fri, 2003-06-20 at 16:44, Gurelei wrote:
Hi all:
I have been hearing from many people that MS Access is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus
-Original Message-
Sent: Friday, June 20, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
Hi all:
I have been hearing from many people that MS Access is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus moving way too much data over
to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package.
Please share your experience in this regard and let me
know what could be the best method to automate loading
data from MS Access 97
Gurus,
We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package.
Please share your experience in this regard and let me
know what could be the best method to automate loading
-Original Message-
Sent: Thursday, June 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Gurus,
We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package
]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Eberhard, Jeff [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 3. September 2002 22:39
An: Multiple recipients of list ORACLE-L
Betreff: MS Access from Oracle
Can someone tell me where to start to find out how to access an MS Access
Can someone tell me where to start to find out how to access an MS Access
table from Oracle. Basically what I want to do is be connected to an Oracle
database in SQL*Plus and execute a query against an MS-Access table. Is
this possible?
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ
Search on Metalink for 'Heterogenous Services'. The documents there
describe how to setup a dblink to an MS Access database.
HTH,
Beth
-Original Message-
Sent: Tuesday, September 03, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Can someone tell me where to start to find
Doc ID: 109730.1
-Original Message-
Sent: Tuesday, September 03, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L
Search on Metalink for 'Heterogenous Services'. The documents there
describe how to setup a dblink to an MS Access database.
HTH,
Beth
-Original Message
Hallo,
any one whom knows how where to find a good MsAccess user forum where I can ask
questions?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
of list ORACLE-L
Betreff: Ms Access user forum
Hallo,
any one whom knows how where to find a good MsAccess user forum where I
can ask questions?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Title: RE: Ms Access user forum
Roland,
Access-L at:
http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L=PEACH.EASE.LSOFT.COM
Many of the most common questions are answered at the Access-L FAQ.
http://rogersaccesslibrary.com/Access-LFAQ.htm
You can also search the archives at:
http
ACCESS-L is a good one. Here are particulars:
--
The ACCESS-L list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software. For subscription/signoff info
and archives, see
www.M$access\for\those\that\DONT\RTFM.com
Dave
-Original Message-
Sent: Friday, April 26, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
Hallo,
any one whom knows how where to find a good MsAccess user forum where I can ask
questions?
Thanks in advance
Roland
--
Please
.!
-Original Message-
Sent: 26 April 2002 15:13
To: Multiple recipients of list ORACLE-L
Hallo,
any one whom knows how where to find a good MsAccess user forum where I
can ask questions?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
http://peach.ease.lsoft.com/archives/access-l.html
excellent list
bob
any one whom knows how where to find a good MsAccess user forum where I can ask
questions?
Thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL
Is this just an expression of bewilderment, or is it unix-ese for 'you can
ask right here in this forum' (and you feel strongly about that)?
8^)
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Friday, April 26, 2002 7:44 AM
To:
I've been told to migrate one MS-Access 97 database to oracle. Oracle
Migration Workbench did the
trick in an extremely clean, quick and complete way. Tables are created,
populated with data and it is
now when the problem starts. The people that were using this Access
database were doing so
of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 28, 2002 8:13 AM
I've been told to migrate one MS-Access 97 database to oracle. Oracle
Migration Workbench did the
trick in an extremely clean, quick and complete way. Tables are created,
populated with data and it is
now when
of
columns when you attach to the table. Other than that I would suggest you
update the ODBC drivers.
- Ethan
-Original Message-
Sent: Thursday, February 28, 2002 7:13 AM
To: Multiple recipients of list ORACLE-L
I've been told to migrate one MS-Access 97 database to oracle. Oracle
To: Multiple recipients of list ORACLE-L
Subject: RE: MS Access migration to oracle
Either it's the privileges on the tables or
the tables do not have primary keys or unique keys.
Access will put the table in read only mode if it does not
have PK or Unique
key.
Waleed
-Original
It's just not Access developers. I was handed an old Oracle db where less than half of
the 300+ tables have a primary key or unique constraint and no tables have a foreign
key.
Think about it.
Jerry Whittle
-Original Message-
From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
PROTECTED]
cc:
Fax to:
Subject:Options instead of ODBC + MS-Access [Slightly? Off-topic]
A developer here has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice
Hi DBAs,
I am researching for solution for a new project. We have a few tables in
Oracle8i db, similar tables with more columns and more data in MS Access.
The data is very static.
Our plan is to synchronize the two dbs, from then on we will always put
change(adding more columns, or insert new
Are you serious?
Replication between Oracle and MS Access, why?
-Original Message-
Sent: Friday, February 22, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I am researching for solution for a new project. We have a few tables in
Oracle8i db, similar tables with more
-
Sent: Friday, February 22, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I am researching for solution for a new project. We have a few tables in
Oracle8i db, similar tables with more columns and more data in MS Access.
The data is very static.
Our plan is to synchronize the two
James can you tell us more about the requirements of your
environment/software that would cause such a solution to arise. I can see
the possibility of writing a MS Access client that perhaps your sales staff
uses that replicates with the database. Hopefully, you don't have too many
tables. You
The Oracle server is on our internal network, the MS Access is on a server
from ISP, which is outside of our network. The cost to eliminate the MS
Access, merge all application to our Oracle is too high, so we decide to
stay the way it is.
It's not real replication, just copy(move) the data
Message-
Sent: Friday, February 22, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L
The Oracle server is on our internal network, the MS Access is on a server
from ISP, which is outside of our network. The cost to eliminate the MS
Access, merge all application to our Oracle is too high, so
for a new project. We have a few tables in
Oracle8i db, similar tables with more columns and more data in MS Access.
The data is very static.
Our plan is to synchronize the two dbs, from then on we will always put
change(adding more columns, or insert new data) in Oracle first, then
replicate
environment/software that would cause such a solution to arise. I can see
the possibility of writing a MS Access client that perhaps your sales staff
uses that replicates with the database. Hopefully, you don't have too many
tables. You really are not going to have a lot of success I think using
To: Multiple recipients of list ORACLE-L
Subject: RE: Compare, Merge and replicate between Oracle and MS
Access
James - Have you considered just maintaining the Oracle tables and then
attaching (or whatever the Access word is) the Oracle table in Access?
That
way you have a single
, February 22, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
The Oracle server is on our internal network, the MS Access is on a server
from ISP, which is outside of our network. The cost to eliminate the MS
Access, merge all application to our Oracle is too high, so we decide to
stay the way
A developer here has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice GUI final presentation of data. The data
extracted has various computations performed. The developer has asked what
has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice GUI final presentation of data. The data
extracted has various computations performed. The developer has asked what
other Oracle or 3rd
to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice GUI final presentation of data. The data
extracted has various computations performed. The developer has asked what
other Oracle or 3rd party options might be used to realise the same end
results perhaps
- impromptu
-Original Message-
Sent: Thursday, February 21, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
A developer here has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client
of list ORACLE-L
A developer here has put together a reporting package which uses ODBC to
interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to
extract data and generate nice GUI final presentation of data. The data
extracted has various computations performed. The developer
We plan to migrate some of our MS ACCESS database (97/2000) to ORACLE
8.1.7. Can anyone tell me where can I fond migration white paper or guide
line?
Thanks.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE
objects which need to be moved too.
Any help would be appreciated !
thanks
vikas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Kawatra
INET: [EMAIL PROTECTED]
Fat City Network
Oracle provides a tool for this. I have seen it
used successfully.
OLE Objects? Dunno
-Original Message-
Sent: Thursday, June 21, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L
Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE
objects which
Subject: MS access
Hi, List
Is there anyone happen to know what's the database size
limitation for MS
access97? I heard it's 1 gigabytes, how to overcome it if that's
true?
thanks
Li
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEADTITLEMS access/TITLE
:Re:RE: MS access
I've been working in Oracle for 4 years and Access for 6 years, and
can assure you that for Access 97 (size limit is 1 g), Access 2000
(size limit is 2 g), Access 2002 (size limit is 4g). I've had 500 mg
database that work fine in a multiuser environment, however
Title: MS access
Hi, List
Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true?
thanks
Li
Title: MS access
If
it's true use an Oracle Database...hehehhhehhh...Just
kidding...sorry:(
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Li, XiangliSent:
Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list
ORACLE-LSubject: MS
Title: MS access
Li,
1GB
for Access would be huge...and cause very poor performance. The only way
to overcome the size limitation is to upgrade to a real database...preferably
Oracle, but that SQL Server thing would work as well for a DB that
size.
Ed
Haskins
Oracle
DBA
Verizon Wireless
Li,
I haven't worked with MS Access, but I did work on a
few projects converting MS Access application to
Oracle application exactly because MS Access can't
handle large amounts of data. The anser to you
question may very well be - move to Oracle (or any
other more powerful tool)
HTH
G
--- Li
Migrate to ORACLE !
sorry could not resist t>
"Li, Xiangli" wrote:
Hi, List
Is there anyone happen to know what's
the database size limitation for MS access97? I heard it's 1 gigabytes,
how to overcome it if that's true?
thanks
Li
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
:(
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Li, Xiangli
Sent: Thursday, May 24, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
Subject: MS access
Hi, List
Is there anyone happen to know what's the database size limitation for MS
access97
Title: MS access
I
believe it is 2gb.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Li, Xiangli
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24,
Title: RE: MS access
Hi , DBAs
Thank you veyr much for all replies. I think I have to go for oracle.
rgds,
Li
-Original Message-
From: Haskins, Ed [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MS access
Li
Officially there is no max, but realistically, as you
get close to a gig you start having serious issues. MAJOR performance
problems, increased crashes, a nightmare. Time to consider something more
robust, and honestly BLASPHEMY SQLServer is probably the way to go
_BLASPHEMY.The syntax
-Original Message-
From: Li, Xiangli [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
Subject: MS access
Hi, List
Is there anyone happen to know what's the database
Title: RE: MS access
it seems only access 2000 supports 2gb files.
thanks.
Li
-Original Message-
From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MS access
I believe it is 2gb
Title: RE: MS access
Yup,
that's what I said :)
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Li, Xiangli
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May
As far as my knowledge is 2GB. And I dont think u can cross this limit.
Rups
Li, Xiangli wrote:
Hi, List
Is there anyone happen to know what's the database size limitation for
MS access97? I heard it's 1 gigabytes, how to overcome it if that's
true?
thanks
Li
--
Please see the
February 13, 2001 2:11 PM
We are developing web database standards in my workplace. I need to
identify advantages/disadvantages of using Oracle verses MS Access for web
databases.
Does anyone know of any good resources for gathering this info (web sites,
articles, etc)? Any help would be
We are developing web database standards in my workplace. I need to identify
advantages/disadvantages of using Oracle verses MS Access for web databases.
Does anyone know of any good resources for gathering this info (web sites, articles,
etc)? Any help would be greatly appreciated.
Thanks
b database standards in my workplace. I need to
identify advantages/disadvantages of using Oracle verses MS Access for web
databases.
Does anyone know of any good resources for gathering this info (web sites,
articles, etc)? Any help would be greatly appreciated.
Thanks Maria
--
Please see th
2001 2:11 PM
We are developing web database standards in my workplace. I need to
identify advantages/disadvantages of using Oracle verses MS Access for web
databases.
Does anyone know of any good resources for gathering this info (web sites,
articles, etc)? Any help would be greatly appreciate
70 matches
Mail list logo