Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   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 25.12.2005 01:36:18 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 04.01.2006 18:23:04 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 03.01.2006 08:13:37 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 28.12.2005 22:15:50 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 22.12.2005 17:14:18 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 20.12.2005 13:50:37 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 20.12.2005 09:12:07 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 19.12.2005 18:18:39 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 19.12.2005 09:38:13 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 18.12.2005 22:04:46 #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 15.12.2005 20:52:30 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 13.12.2005 13:23:22 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 07:13:42 Get data from Lotus Notes Does anyone know ways to import Lotus Notes files into Access? Thanks. David ... 2 10.12.2005 00:55:55 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 09.12.2005 22:08:03 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 07.12.2005 18:31:03 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 07.12.2005 16:35:15 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 06.12.2005 16:10:26 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 06.12.2005 07:24:23 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 05.12.2005 05:29:21 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 03.12.2005 00:09:39 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 03.12.2005 00:09:38 Linked Tables to SQL-Server I have a very strange special effect (I mean an error situation) on some PCs. We have an Access 2003 project (a normal mdb-File, which is to be understood as the main application), and as a backend we use SQL-Server 2000. The mdb created (with VBA) Links to Tables of SQL-Server, with the following code (fragment): Set tdfNew = dbsDao.CreateTableDef(strLocalName) tdfNew.SourceTableName = st... 2 01.12.2005 22:51:18 How to make attached SQL Server table read-only? At the SQL Server database, the users have full add/delete/edit permissions, but I need the tables, when attached to an Access database, to be read-only. How do I do this? I'm attaching the tables in code using DSN-less connect strings -- don't know if that matters or not. ... 3 30.11.2005 23:22:02 AS/400 connection problems For years we have been using Microsoft Access to transfer data to/from an AS400 using the Client Access ODBC connection. We are now having problems with the connections where the data looks garbled when you open a table, or it will say #DELETED in the fields. My theory is one of the Microsoft critical updates made a change to the system, but am not sure. I have tried to reinstall Cli... 5 29.11.2005 20:55:55 9 Pages: 1  2  3  4  5  6  7  8  9