RE: MS Access
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] 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 into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja
RE: MS Access
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 Access Database to Oracle -- Pain Free by Debbie Pennell which gave a brief overview of the process. --Jeff -Original Message- Sent: Tuesday, January 20, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Thanks guys, for pointing to the right place for Access issues. Has some one got a document which you may have written for performing a conversion/migration from Access to Oracle, or for that matter any conversion. I want to look in the document, as to what issues are to be dealt with, what is the change that needs to take place in the new system, what is the actual thing in access and what is the desired effect going to be in Oracle. I know there will be different things customized for your company's case, but I want to just see how the whole document is structured, and therefore get a good idea as to what the conversion process will entail. You can write me direct at:- [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Please reply fast, as I need to see what are the different options I need to look at. Regards, Raja - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:19 AM ACCESS-L. For subscription/signoff info and archives, see http://peach.ease.lsoft.com/archives/access-l.html http://peach.ease.lsoft.com/archives/access-l.html . Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [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 large Access database into Oracle database. I need to know what will be the steps to convert such a database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MS Access
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 database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja Oracle has a product called Migration Workbench that converts various other db's to Oracle. Can't vouch for it performance, never having used it before though. http://otn.oracle.com/tech/migration/workbench/index.html http://www.oracle.com/oramag/oracle/02-may/index.html?o32tools.html -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access
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 database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja Oracle has a product called Migration Workbench that converts various other db's to Oracle. Can't vouch for it performance, never having used it before though. The workbench itself is quite useful - funnily enough, as much for the manual as for the product itself. It gives a fairly good run-down to approaching migration, which can be applied to just about any DB. The only gotchas I encountered with the workbench are its picky requirements for exact installer versions, etc. (nothing new there for Oracle). Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access as a front-end to Oracle DB
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 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 -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 the network. Assuming that this is correct, what is the mechanism of this? If I execute a simple query like: select f1, f2 from t1 where f3='X'; is MS access going to copy the whole table t1 to my machine and only show the rows with f3 equal to 'X'? Am I misinderstanding it? tia Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access as a front-end to Oracle DB
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 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 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 -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 the network. Assuming that this is correct, what is the mechanism of this? If I execute a simple query like: select f1, f2 from t1 where f3='X'; is MS access going to copy the whole table t1 to my machine and only show the rows with f3 equal to 'X'? Am I misinderstanding it? tia Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access as a front-end to Oracle DB
I have had some recent exposure to Access - people asking me to investigate why their query runs for so long. I can understand that if one table in the query is local then Access has to pretty much work locally, but I have been terribly surprised at how it approaches multi-table queries some time. I've seen it work on a single table at a time and then pass a bind variable to the next table to simulate a join. The example I was looking at most recently turned one query into 80,000 queries as a result - just what production needs when it's busy already. My best guess is that Access see's foreign tables as individual foreign tables. Perhaps it doesn't worry about where the foreign tables come from and therefore treats them all as individual entities? Anyway, that's just a guess as to why Access would break a simple join into two queries. Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: MS Access as a front-end to Oracle DB [EMAIL PROTECTED] .com 21/06/2003 08:04 Please respond to ORACLE-L 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 -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 the network. Assuming that this is correct, what is the mechanism of this? If I execute a simple query like: select f1, f2 from t1 where f3='X'; is MS access going to copy the whole table t1 to my machine and only show the rows with f3 equal to 'X'? Am I misinderstanding it? tia Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
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 (Access takes the query typed as is and sends it to the server for processing) or I used Oracle Objects for OLE. Using OO4OLE you can use VBA to specifiy more explicityly what you want the server to do for you. It opens up the full power of Oracle under the Microsoft Office/VB interface. Check 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 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: select f1, f2 from t1 where f3='X'; is MS access going to copy the whole table t1 to my machine and only show the rows with f3 equal to 'X'? Am I misinderstanding it? tia Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access as a front-end to Oracle DB
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 -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 the network. Assuming that this is correct, what is the mechanism of this? If I execute a simple query like: select f1, f2 from t1 where f3='X'; is MS access going to copy the whole table t1 to my machine and only show the rows with f3 equal to 'X'? Am I misinderstanding it? tia Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access 97 to Oracle 8.1.7 Scheduler
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 can schedule a command like: c:\program files\microsoft office\office\1033\msaccess.exe path to the msaccess db file /x macLoadDataIntoOracle Alternatively, you can write a windows scripting host script that will build that command line up for you (after e.g., verifying that the db file msaccess executable are present, maybe doing some logging, etc.) and then schedule that. HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, June 05, 2003 2: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. 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 to Oracle 8.1.7. Thank, Bob __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access 97 to Oracle 8.1.7 Scheduler
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 -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. 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 to Oracle 8.1.7. Thank, Bob __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access from Oracle
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 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: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access from Oracle
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- Sent: Tuesday, September 03, 2002 4:39 PM To: Multiple recipients of list ORACLE-L 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: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ms Access user forum
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://peach.ease.lsoft.com/archives/access-l.html Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Hallo, any one whom knows how where to find a good MsAccess user forum where I can ask questions? Thanks in advance Roland
RE: Ms Access user forum
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 http://peach.ease.lsoft.com/archives/access-l.html . COPYRIGHT INFO: http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHTL=ACCESS-L Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, April 26, 2002 7: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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ms Access user forum
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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ms Access user forum
.! -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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ms Access user forum
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 PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ms Access user forum
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: Multiple recipients of list ORACLE-L .! -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 -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MS Access migration to oracle
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 will have to make some modifications in their code, when connecting to the db, to provide logon/password information. I don't think it's possible to specify password, when configuring ODBC datasource. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients 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 the problem starts. The people that were using this Access database were doing so by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access migration to oracle
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 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 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 by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access migration to oracle
Waleed, you saved my life! I don't know why was I expecting Access97 application designers to define minor details like the primary keys. I most certainly owe you one. -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:48 AM 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 Message- Sent: Thursday, February 28, 2002 8:13 AM To: Multiple recipients of list ORACLE-L 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 by means of an ancient VB piece of ... code and they don't want or they don't know to adjust it. They expect the program to somehow find the new Oracle 8.1.7.3 instance and continue to work as it did before. I created a new access database containing ODBC links to the Oracle tables, but the program is complaining that the links are read only. Is there any way in this world or beyond to make these tables writable? I'm inclined to tell them that they should do some coding, which is very likely to make them go back to Access. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access migration to oracle
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]] Waleed, you saved my life! I don't know why was I expecting Access97 application designers to define minor details like the primary keys. I most certainly owe you one. -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: MS access
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 can include linked tables in other files, its total size is limited only by available storage capacity. Number of objects in a database 32,768 Modules (including forms and reports with the HasModule property set to True) 1024 Number of characters in an object name 64 Number of characters in a password 14 Number of characters in a user name or group name 20 Number of concurrent users 255 *** -Original Message- From: dan williams [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: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 if there is a need for a enterprise solution, then using a enterprise tool is better suited. --- [EMAIL PROTECTED] wrote: Kevin!!! Li, In reality Access does have a file size limit, but I believe it is much lower than 1GB. Regrettably there is no way around it, except as Kevin stated to use a pass through query to Oracle. One should understand that Access is designed as a single user system that gets bastardized into multi user applications with a lot of resulting trouble. Dick Goulet Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/24/2001 9:02 AM MS accessIf it's true use an Oracle Database...hehehhhehhh...Just kidding...sorry:( -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? 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 META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4207.2601 name=GENERATOR/HEAD BODY DIVSPAN class=218025615-24052001FONT face=Arial color=#ff size=2If it's true use an Oracle Database...hehehhhehhh...Just kidding...sorry:(/FONT/SPAN/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]BOn Behalf Of /BLi, XiangliBRBSent:/B Thursday, May 24, 2001 11:57 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B MS accessBRBR/FONT/DIV PFONT face=Arial size=2Hi, List/FONT BRFONT face=Arial size=2Is 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?/FONT/P PFONT face=Arial size=2thanks/FONT BRFONT face=Arial size=2Li/FONT /P/BLOCKQUOTE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dan williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L
RE: MS access
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 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
RE: MS access
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 -Original Message-From: Li, Xiangli [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list ORACLE-LSubject: 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
Re: MS access
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, Xiangli [EMAIL PROTECTED] 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 note my new old address !!! __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MS access
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 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
RE: MS access
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 AMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: MS access
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, 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 -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 size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
RE: MS access
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 matches up better so there are fewer (almost no) issues porting code that runs against Access to SQLServer, where there can be some issues moving to Oracle. Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message-From: Luis DeUrioste [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 1:32 PMTo: Multiple recipients of list ORACLE-LSubject: Re: MS accessMigrate 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
RE: MS access
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. 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 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? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
RE: MS access
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 24, 2001 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: 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. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. SpenceOracle DBAFuelspot -Original Message-From: Li, Xiangli [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list ORACLE-LSubject: MS access Hi, ListIs 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? thanksLi
Re: MS access
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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: rupali belsare INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).