Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Human Connection + Programmatic Connection = Love Not really, but hey: if one or more people open an Access database and are modifying tables, can you also open that database via a programmatic connection using an ODBC Access driver and have that program modify data at the same time? I keep getting a "database is already open" error and can't modify the data from my program. Any ideas on why this might not work or even if it is possible? ... 2 03.04.2006 06:48:52 Dreaded Run-time error "3146" ODBC--call failed HELP I'm using Access 2002 with linked files to SQL Server 2000 (I think). I've got a nasty query that generally works fine. It uses a nested query and is some of the parameters are date ranged based on user input. I get the ODBC-call failled error message when the parameters are set so that it creates a query that takes a while to run. The query runs fine if I run it on my development system... 2 02.04.2006 12:56:16 Access 2000 FE/SQL Server 2000 Does anyone have experience and/or documentation vouching for the viability of using Access 2000 as a front end to SQL Server 2000. We have started process of converting over but are constantly getting pressured to use VB.net or anything but Access for the front end. We have around 25 concurrent users now and possibly 100 or more eventually running total company accounting/quoting/inve... 9 01.04.2006 19:40:33 sql server ODBC numeric fields showing up as text I have literally hundreds of queries going against a back-end sql server database. We are in the process of upgrading to the new version of this database (a third party tool) and I'm testing the queries to make sure they'll work with the new version of the database. There are several fields in one particular table that are supposed to represent quantities. Historically Access has recog... 8 30.03.2006 13:56:46 NON STOP SQL What is the equivalent of Date()-1 using PASS THROUGH queries and NON STOP SQL for TANDEM? Any link to a website that would provide "ODBC/JDBC escape sequences and/or functions to support the equivalent of CURRENT_DATE, INTERVAL and date arithmetic"? Thanks... 2 28.03.2006 20:42:02 Call Stored Procedure ORACLE via DAO Querydef How does one call a stored procedure from a DAO Querydef? Using Access XP with SQL ORACLE backend. I need to get recordset or ref cursor from oracle. thank you -- M. Uhlir ... 4 28.03.2006 15:21:03 How to make linked tables to SQL Server views read only? Hi, I have a MS Access as the front end, and create several linked table to SQL Server views through ODBC. I thought by using the views on SQL Server, the Access front end will have read only rights (that's what I want). However, the Access front end has all the rights (insert, update, delete, select) through the views. How can I make the linked tables read only? Thanks for your h... 8 24.03.2006 22:10:07 Scaling Up with Unbound Access Applications In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron write in chapter 11: "If your licensing allows you to keep a connection for each user open, however, that is usually the best choice in a two-tier system". What are the licensing issues they are referring to? How does this relate to MSDE? Are things different with the new SQL Server Express? Or does this licensin... 4 24.03.2006 19:21:40 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:21 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:13 Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:07:31 Stored Procedure I use stored procedure on an oracle server When i use ADO, i must specified the provider. I use ORAOLEDB.ORACLE look this the stored procedure that i need to call have no parameters. Must i absolutely need a parameter like adparaminputoutput or i can call directly the storeproc??? This procedure return me an error Error -2147467259 Error not specified Anybody can explain me what... 2 17.03.2006 12:19:00 ODBC linking wizard I am unable to get the wizard within Access 2003 to appear. I'm trying to make a link a Sql Server table. All other linking wizards appear on the other options. When I click on File, Get External Data, Link and choose ODBC under Files of Type - it simply does nothing. The correct ODBC connection is setup under the admin tools, data sources. I'm able to get to the data of previously ... 3 16.03.2006 21:40:28 Order / Detail solution I've created an algorithm for Order / Detail based on Chipman and Baron's examples, but surely there is a more elegant way to accomplish this. 1. From the subform bound to a local detail table I gather its rows like this: Public Function DataString(ByRef rintMaxSize As Integer) As String Dim rst As ADODB.Recordset Dim strSQL As String Dim strDS As String Set rst = N... 1 14.03.2006 05:30:07 ODBC No Longer Working I am using Access 2003. I have been using an ODBC Connection to Microsoft Visual Fox Pro tables using a connection I created in the Windows Control Panel, Administrative Tools, Data Sources (ODBC) for months. I have been able to view and link other tables within the RWBS.DBC set whenever I have wanted to. All of the sudden, when I go to link a table I want to temporarily link using Fi... 2 14.03.2006 00:58:26 Order / Detail again In chapter 11 of "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron outline an mdb method for writing order/detail records with a stored procedure where the detail records are passed as a delimited string. This permits both order and detail records to be entered or edited as part of the same transaction. Unfortunately, none of the data values are strings in their exam... 1 12.03.2006 23:37:44 What am I missing This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C6442E.A0176530 Content-Type: multipart/alternative; boundary="----=_NextPart_001_000A_01C6442E.A0176530" ------=_NextPart_001_000A_01C6442E.A0176530 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable =20 I know that this should be possible, just seem to be missing ... 3 11.03.2006 20:10:27 Connecting to MS Access for AIX via ODBC This is a multi-part message in MIME format. ------=_NextPart_000_001E_01C61DAC.56807F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We need to connect to MS Access (various versions: 97/2000/2003) from = AIX machine via ODBC. Any suggestions on the best driver to use? ------=_NextPart_000_001E_01C61DAC.56807F40 Content-Type: text/html; ... 3 11.03.2006 15:54:09 MSymDB Error when opening DB I have a client that cannot open thier mde file. The message received is that "the Microsoft database Jet Engine could not find the object "MSysDB" file. Make sure that it exists or that is not misspelled". Is this DB completely currupted. I cannot open this file in any way I know how & I have tried to repair the file also. Any solutions ???????????????? -- LD... 6 11.03.2006 01:28:59 MySQL ODBC and saved passwords Howdy, Does anybody know a way to create a linked Access table without saving the username or password in the linked table's connect property? I am using Access 2002, connecting to a MySQL 5 server with MySQL ODBC 3.51.09. I would like my users to be prompted for username/password every time they try to connect. Whether I create a DSN-less connection or if I use a DSN with username ... 1 10.03.2006 15:19:30 ODBC Settings I am using Access 2003 and wanted to know if there is a VBA code for setting the connection string to server that uses ODBC connection. This particular server is a Teradata type and I have the driver for it. I created a DSN connection and access tables on the server when needed. My only shortcoming is when I pass my DB to someone else the connection fails. Is there a way to force the... 3 10.03.2006 00:14:04 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:07 TIMESTAMP and optimistic locking http://groups.google.com/group/microsoft.public.access.odbcclientsvr/browse_thread/thread/cb4e5cb230877151 i refer to the above post, specifically to the reply by Joe Fallon > If you add it to the table, then Access will use it "silently" to check to > see if anyone has changed the record since it was downloaded. (In other > words, the timestamp field does not need to be part of... 5 06.03.2006 02:50:09 Order / Detail Strategies In chapter 11 of "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron outline an mdb method for writing order/detail records with a stored procedure where the detail records are passed as a delimited string. This permits both order and detail records to be entered or edited as part of the same transaction. I'm wondering if anyone has come up with an alternative approach... 3 06.03.2006 02:39:34 annoucing mysql - apache based business management software Gestix is an innovating light-weight business management application, now available for Mac OS-X, Windows and Unix as well. Please check the web site of the product for detailed information. Free 90-day trial downloads and online test-drive. Gestix has an easy to use, elegant web-like user interface. However, you won't need to be online for using the program as long as you download and i... 1 05.03.2006 11:06:10 9 Pages: 1  2  3  4  5  6  7  8  9