Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Error Code Zero I have a Java program that uses the JDBC:ODBC bridge to the MS Access 2000 ODBC driver. The program has worked successfully for months. The only aspect that has changed is that the database now has about 100,000 records. Suddenly, the program is getting the following error continually: SQL: SELECT * FROM SetiLog2 WHERE Computer = 'Harry' AND Name = '16mr05aa.15136.17264.40912.1.167'; ... 1 1/10/2006 1:37:38 PM ODBC Connection fails on XPpro but works on WIN2K and WinXP home I have a front-end MSAccess database on my local PC, and a back-end mysql database on a remote linux server which holds the data. I have installed and configured the ODBC driver on computers running Windows 2000 and Windows XP home edition (using ODBC driver 3.51.11.2-win) and I can get the database to work, i.e. double click on the access database and it launches, connecting to the ba... 2 1/9/2006 2:51:12 PM Record Locks In SQL Hi I have an access application with backend in SQL Server. It works fine on the test environment however on the production server on one Table after adding a record the record is somehow locked and any attempt to edit it by anyone results in the "Record has been change by another user since you started editing...." This occurs even when the original user attempts to edit this field.... 2 1/6/2006 10:51:43 AM ODBC & SQL I am using Access 2003 with an ODBC connection to a MS SQL database. When I make a change to a record on a form, I always get a write confict dialog stating that the record was changed by another user. I am the only one using the db at this time so I know this is not correct. Is there a way to correct this? Thanks.... 3 1/4/2006 6:23:04 PM cross-post trying to get a faster reponse. From: "Ajay Bansal" <ajay.bansal02@gmail.com> Subject: Problem with like keyword when Access DB is in chinese Date: Tuesday, January 03, 2006 11:18 AM Using "like" in my sql statement "select * from table where data like '%sum%'" or "select * from table where data like '*sum*'" gives the following error : Error String:Out of memory retcode:-1 St... 1 1/3/2006 8:13:37 AM Replication of Access database w/ linked SQL Server tables OK, so here's the scenario. I've got an Access application (MYAPP.MDB) which uses ODBC to link to my SQL server database. MYAPP only contains VBA code, forms, reports, a couple of utility tables (e.g. lists of forms) and so forth. So far so good. I've been copying MYAPP and some associated documents to a remote computer and logging into my server remotely so I can work out of the office.... 4 12/28/2005 10:15:50 PM Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Then you should take yourself a couple minutes time. You happily will be that you ... 1 12/25/2005 1:36:18 AM THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5 participants!! Example, you get Euro o... 1 12/22/2005 5:14:18 PM How to change linked table automaticly Hello I have an Access (97) database with linked tables to SQL Server with user 'sa' and password 'bla' I'd like to write a macors to change the user and password for linked tables to 'user' and password 'nothing' Could you please provide some exampes , as I would not want to drop the tables and -re-create them with a new user and password Thanks ... 1 12/20/2005 1:50:37 PM TimeOut Access97, Sql Server, Win 2000 I am creating a connection FROM an Acces97 FrontEnd TO an SQL Server database as follows NewTableDef.SourceTableName = "xxx" 'ODBC Driver is called JayRemote ConnStr = "ODBC;DRIVER=SQL Server;SERVER=JayRemote_v2;_ APP=Microsoft® Access;DATABASE=cnettestsqldb;_ Network=DBMSSOCN;Address=***.***.***.225,1433" 'Uid and PWD are are va... 1 12/20/2005 9:12:07 AM ODBC Limitation I've got Access 2003 and I'm connecting to a SQL Server database using ODBC. The structure of the table I'm trying to link to is huge. It has over 600 fields, yet only has about 700 records. When I look at the linked table, it's missing the last 100 fields or so and the last 150 records. In other words, it's not bringing over the entire table, just part of it. There is no indication that... 7 12/19/2005 6:18:39 PM Linking of ORACLE-ODBC-Tables to Access-MDB by VBA-Code fails... Dear Developers, My Access-application with ORACLE-8-Database as backend worked since years without problems. At evry launch of the MDE it checked the selected ODBC-source and relinked all needed tables from that source by VBA-Code like: Dim td As TableDef set db = CurrentDB sTable = "OracleTableName" sConnect = "ODBC;DSN=MyDSN;UID=MyUser;DBQ=MyService;DBA=W;APA=T;E... 2 12/19/2005 9:38:13 AM Lost ODBC drivers I don't know how but I have lost all the ODBC drivers in the last couple of days. I have managed to restore MySQL but I cannot get the Microsoft ones back. Any help would be very welcome. Malcolm... 3 12/18/2005 10:04:46 PM #Deleted in every field I just created a new database in SQL Server with 3 tables. I then linked the tables to Access. There is data in the tables - when I do a SELECT on them in Query Analyzer I can see the data. When I open the tables in Access, #Deleted is in every field. Oddly, the record count is exactly the same as QA gives me. What could be going on here? ... 4 12/15/2005 8:52:30 PM SQL server - timezone difference Hi there, I'd like to ask if there's any easy way to correct time zone difference between the SQL server and the local client? We are in CET and the server is somewhere in US (-6 hours). I have to report on daily basis and things happened "today" is not the same for me and the server. Please tell me the most comfortable way to solve this issue. I use Access 2003, the server is an SQL serv... 1 12/13/2005 1:23:22 PM 2003Access, ODBC to SQL and "manipulate"... Hello, I confess a lack of SQL knowledge but I can read and learn. I have a "production" database (currently using MS' old Solomon interface to a SQL2000Srv) that I need to export data from (and could use DTS I suppose, but we need to access the data over the next few weeks "almost" daily and Solomon doesn't give us the flexibility we need) and then 'evaluate' the data for dates and amounts... 2 12/12/2005 7:13:42 AM Get data from Lotus Notes Does anyone know ways to import Lotus Notes files into Access? Thanks. David ... 2 12/10/2005 12:55:55 AM Save Not Available at this time I have a form with a subform in it. The main form is the customer header info and the subform is the line-items. After the user enters the information on the subform, they click a save button on the main form. Which triggers the command : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 There is some error checking done and then a message box opens to give th... 2 12/9/2005 10:08:03 PM Can't Paste Record With SQL Server Backend Anyone got any idea why i can't copy and paste a record either in a form or datasheet when the table is in SQL Server? The Paste commands are also greyed out on the Edit menu drop down. Thanks.... 1 12/7/2005 6:31:03 PM SQLTables doesn't return data for an Access database??? I hope this is the right newsgroup. I have some ODBC code that I'm testing against various underlying databases. The code was developed against MySQL but now I'm getting other common options to work. My setup: Windows 2000 running Access 2000. Using ODBC to read the local Access db. I'm using SQLTables to find out if a table exists, and how many tables are in the database. But w... 2 12/7/2005 4:35:15 PM Access Front End Form/Subform issues with SQL Tables I recently completed a project in Access that uses Froms and Subforms without any issues. My boss now wants the data to sit in a SQL dB and still use the Access forms to add and view the data. I moved the data to SQL and set links up through ODBC in the Access front end. I have an order entry form that contains the customers information (name, address, etc) for this order and a subfor... 2 12/6/2005 4:10:26 PM Create Table binary fields I can create a Jet database with a table that has a binary field using something like: CREATE TABLE myTable(myBinaryField BINARY(255)) The call fails if a number larger that 255 is specified. If I create a database with Access, I can specify an OLE field in the table designer and insert and select that field (more than 255 bytes) as if it were a binary field. Question: How can I pr... 2 12/6/2005 7:24:23 AM Linked Tables in Access 97 Hello - I am trying to link tables in Access 97 and I have just installed Oracle 9i. When I finish installing I attempt to link the tables and am successful. Then, when I turn the computer off and then back on again I try to re-link the tables and I get ODBC call failed error but it won't tell me anything more. I am very new to both of these products as I have just joined the database w... 6 12/5/2005 5:29:21 AM SQLEXPRESS data access from A2k3 I cannot find any specific information (articles, blogs, etc.) on connecting to SQL Express from A2k3. I have been using ADO & VBA to connect to SQL2k and MSDE2k from both mdb and adp. and of course adp can connect directly (via ADO I presume) using the create wizard. I tried using the wizard to connect adp to SQLX but had no luck. any suggestions?... 2 12/3/2005 12:09:39 AM Error 3146 ODBC Call Failed Hi, I would like to know if anybody can explain to me why the error 3146 is generated. I started to get this error lately with my connection to an outside SQL Server thru the internet. We are based on the US east coast and the hosting server is on the US west coast I have 12 tables linked on a permanent basis, out of these 12, I need to transfer data from 4 of the linked table so I ... 3 12/3/2005 12:09:38 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12