Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Data type mismatch error when running SQL query Hi All, I am fairly new to SQL and am running into a problem I can't figure out. Hopefully someone here can help. To be honest im not even sure if this is the right place for the query so if not then let me know where I should put this question: I have an Access database which I am trying to run the following query against: DELETE From Basket WHERE CreatedAt < '26/01/2007 14:20... 4 1/28/2007 10:37:45 AM ODBC performance In the past, I have noticed a significant performance hit when using ODBC linked tables in access databases rather than access projects that use native sqlserver as the backend. It appears that microsoft is recommending the use of .accdb databases in Access 2007 and I was wondering if there will be a significant performance penalty vs using Access 2007 projects? -- A. Godfried... 3 1/28/2007 1:47:01 AM ODBC - Update on linked table Failed I am using MS Access 2003 connected to a SQL database. When I try to update data on a form that is a subform I get a SQL error message ODBC -- Update on linked table 'Table name' failed The record source for the main table is a query that pulls data from the TABLE NAME mentioned in the error message. The sub form is linked to the main form using the Primary key of the Main table (for... 4 1/26/2007 5:16:00 PM Disappearing Records I am running an Access 2000 MDB against a SQL 7 back end, using ODBC linked tables over a LAN and a WAN. The system has been operational for years with relatively few problems. Recently, WAN users have been reporting several hundred records disappearing at a time. The records are all sequential, and they're in a table that contains about 60,000 records. This all started last week at abo... 9 1/21/2007 5:23:16 PM Prueba Cepade Ejercicio UD8 Grupos de noticias. A todos: Favor no tomar encuenta este mensaje. ... 1 1/14/2007 9:58:12 PM Running an insert query on a remote db Hi Is it possible to run an access query to insert records in an access table from a table in a remote sql server db? Thanks Regards ... 1 1/12/2007 4:37:17 PM Table Description I am using Access 2000 and would like to use the 'Description' property of my database tables to describe the table contents for the database end users. This works fine for local tables within Access but the description is over-written with ODBC connection details when the table is an ODBC link to an external table. Is there any way of over-riding this behaviour?... 1 1/9/2007 11:01:01 AM Access 2003 / SQl Server 2005 Hello, We use an in house access 2003 application with ODBC links to a SQL Server 2000 database. in addition to the ODBC links to the SQL server, we have a few pass through queries and direct calls to the strored procedures of the server in this access database. We are looking at going ot SQL Server2005. Is there anything I should worry about or consider in regards to the above and A... 2 1/5/2007 4:20:37 PM Lapptop local solution Hi everyone :) At our office I have Access 2003 as front end and SQL Server 2000 as back end via ODBC. The front end has a lot of functionality and one of them is to maintain/view adresses from customers. What I want is the create a very basic front end for Access that has the only task to view these adresses. This little front end is going to be used on the laptops of several salesm... 3 9/29/2006 12:20:15 PM Querry time on upsized SQL Server Database Hi All, Just wanted to share a problem I had to solve recently. Access 2000 database that had the backend upsized to SQL Server 2000. A query that was looking for a specified time in a date time field with the parameter [TranTime] = #06/06/2006# This query found the time correctly in access but would return nothing after conversion to SQL Server. The solution: change the par... 1 9/29/2006 4:25:50 AM Record locking SQL BE Access FE I have an Access database front end which is linked to a Sql Server back end which contains all the tables. In the Advanced Options, I set the Default Record Locking to Edited Record. On the Form I set the Record Locks property to Edited Record. However, multiple users can still open up the form with the same record on it and edit it simultaneously. How can I stop multiple users from... 2 9/27/2006 3:15:49 PM Perfomance problem Hi everyone ! I am using Access 2003 as front end and SQL Server 2000 as back end via ODBC. Currently I am using a main table with 3000 records and 2 linked tables (one with 2000 records and one with only 10). I created a query for the main table where I sort the data on two different fields and I use this query as the record source for a form. The fields from the linked tables I look ... 13 9/26/2006 7:47:32 AM Flushing the JET - OLEDB In one of my apps i use an access database via OLEDB and that goes well at many customers sites but not on one. There the problem is that sometmes added rows disapear after closing the programm and restarting. The jet file is on the network, the app too and there is only one user. And ofcourse the problem cannot be reproduced. I have told them to update the Jet and MDAC drivers and the N... 8 9/22/2006 11:44:30 AM Poor Performance with ODBC link to SQL Hi, I have an Access 2003 .mdb/.mde that queries linked tables from a SQL db in order to provide Access reports to the user. It also combines with the SQL queries, data from a few very small tables within the Access db. On most systems/servers/networks, this app works well. But there are two systems/networks (one running Server 2003 and another running Windows 2000) where the que... 8 9/19/2006 12:10:31 AM " problem I export an access table using Oracle ODBC driver to Oracle schema, it add character " to table name and all its column names like this "ff_to_oracle" ( ID VARCHAR2(20), "empid" VARCHAR2(20), "empname" VARCHAR2(50), "empdept" VARCHAR2(20), "create_date" DATE ) and when I want to query the imported table in Oracle I have to say: select * from... 3 9/17/2006 12:48:31 AM Trouble linking to ODCB through MS Access Hello I'm a newbie with what I hope is a simple problem: I trying to get data into Access through ODCB (ultimately to connect to MySQL) but when I select "ODCB Databases" as the file type (after choosing "Link Tables..." or "Import.." under "Get External Data") the dialogue box simply quits. The only clue I can find is that in all that I've read on the internet, the file type is quoted as... 4 9/14/2006 5:26:30 PM Pass-Thru Query or Stored Procs I'm working with someone trying to revamp their reporting system. They are currently using SQL Server 2000 as the backend and Access for doing their reporting. The problem is that they are building these huge complicated pass-thru queries, and often stringing several queries together to get the dataset they need for their report. The analysts know Access pretty well and are comfortabl... 6 9/12/2006 4:12:18 PM Access with ODBC from VB 2005 Hi everyne I`m trying to run aan acces query with parameters from VB 2005. If I do it with OleDB components I have no problems, but I need to do that with ODBC, but I get this error: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. The code is the following: Dim CnnODBC As Odbc.OdbcConn... 3 9/7/2006 11:49:01 AM Update system DSN via VBA I have a .mdb that uses a system DSN for a connection to an Informix database. Currently, the DSN on all client PC's were created with the same username/password and the tables were all linked using that username/password. The newest Informix ODBC driver no longer stores the username/password in the system tables, it references the DSN for that information. I would like to be able to ... 4 9/5/2006 9:23:06 PM Dynamic filter with Access/SQL Server I have a UDF in SQL Server 2000 that I access with a pass-through query in an Access 2002 mdb. The UDF includes grouping that I figured would be optimized if saved it on the server. I want to let the user apply filters on the original records, i.e. before the grouping. Is there any way to do this and still get the optimization? One thought I had was to generate a temp table or view with ... 3 9/5/2006 3:55:26 PM DSN-Less Past Thru Query I know how to make my ODBC linked tables (mdb to SQL 2000) DSNLess. How do I make my Pass Thru Query DSNLess?... 2 9/4/2006 9:44:14 AM Access 2003 and SQL Server 2005 using ADO and ODBC I have read about many issues with ADP and SQL Server 2005, has anyone experienced any issues with developing the front end of an application in Access 2003 and connecting to the SQL Server (2005) for tables and queries using ADO and ODBC? ... 2 9/18/2006 10:16:19 PM Occasional Locking problem on sql tables linked from access with o I use a form linked to an sql view of a master detail relationship. The form is snapshot and uses access form filter to locate records. When the records are retrieved we go to another form with a master detail design where we can update the record. That is where we get an ODBC error indicating that the record is locked. I used your advice on timestamp and non null boolean fields... 1 9/21/2006 9:31:02 PM MS Access : cannot join on Memo,OLE,od Hyperlink object I have a MS Access Db,which I migrated to Oracle.I created linking with oracle tables in my Access db.Both MS Access and Oracle db have unicode characters. I need to test whether the data is same in both databases. I'm using Access db and linked tables of Oracle.I perform join on the tables to get records. When I run the query on Access db to compare,I get the following error "cannot j... 1 9/22/2006 8:29:38 AM connect to SQL-server..? Hi all, I would like to connect to a SQL-server and promt the user with password and username. Can I use something like?: Dim oConn As Object Set oConn=?? oConn.Properties("Prompt") = adPromptAlways oConn.Open "Driver={SQL Server};" & _ "Server=MyServer;" & _ "DataBase=MyDb" End Sub .... what do I have to do? /Kent J. ... 8 9/25/2006 9:01:38 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12