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
You may want to look at the Oracle Migration workbench.
http://otn.oracle.com/tech/migration/workbench/index.html
http://otn.oracle.com/tech/migration/workbench/index.html
I don't know if the slides are still available but there was a presentation
at IOUG Live! 2002 titled Migrating a Microsoft
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 such a
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
Dick,
what if the second table is not local, but another
remote ORacle table. How would the things change in
this case?
Gene
--- Goulet, Dick [EMAIL PROTECTED] wrote:
Yes, you are misunderstanding it. A simple
statement like your will result in only the data
required being sent over the
Gene,
If all of the tables are remotely linked tables then it should not be too bad.
Things like order by and group by will happen locally though.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, June 23, 2003 10:10 AM
To: Multiple
recipients of list
ORACLE-L [EMAIL PROTECTED]
cc:
Sent by: Subject: RE: MS Access as a front-end
to Oracle DB
I haven't worked with MSAccess to Oracle stuff lately, but
it used to be that the ODBC stuff pulled A LOT of background crap in
addition to what was needed for the query. And, yes, Access did a lot
of the processing locally. The way I got around this was that I either
used passthrough queries
Yes, you are misunderstanding it. A simple statement like your will result in only
the data required being sent over the network. But if you add in a second table
things change, especially if that table is a local access table.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
You can specify the name of a macro for msaccess to run on startup w/the /x
parameter of the msaccess executable. That macro can do a RunCode action to
run a VBA procedure that you specify (which is where you can do your data
loading) followed by an Exit action to shut down msaccess. IIRC, you
Hi Bob,
I don't know if its possible to do it by those means, but it is
definitely possible, using heterogeneous services to have Oracle pull
the data from Access over a database link. You could schedule that
through the Oracle scheduler, or have MS scheduler execute a sql script.
HTH.
Beth
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-
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:
If VB code was connecting to Access db through ODBC datasource, just modify
this this datasource (or delete/create new one with the same name) to use
Oracle ODBC driver (instead of ACCESS ODBC driver) and point them to the
entry in tnsnames, which you create for them to use.
Still, probably they
Check the ODBC configuration in Control Panel and make sure the connection
is not set to read only. If you have primary keys on the tables access
should be capable of seeing these and thus will allow updates to the table.
If not you should be prompted to supply the key columns from a list of
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]]
Yes, Dan is right,
I just pulled up this info from Acess Help ( U can find more info when u
search for Specification in access help)
***
Database specifications
***
Attribute Maximum
Database (.mdb) file size 1 gigabyte. However, because your database
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
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, 2001 11:57
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
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
34 matches
Mail list logo