Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   ODBC Max Length of Pass Through Query with Access 2k2? Hello All, What is the maximum length of an ODBC pass through query? Things work fine with the code except when I try to create a view which is pretty complex in Oracle. I'm using a DSN provided with the Oracle Express Edition and using Access 2k2 as the front-end. When I debug print the SQL and paste it into SQLplus it works fine. The length of the debug print that works is 1988 char... 10 30.07.2006 10:51:00 UI and NOT NULL server side fields ? Hi, I have "not null" fields server side (SQL Server 2000). Client side they are seen as "required". The problem is that if I hit the "Del" key, a null value is given to this field and Access displays what seems an internal error message ("You have affected a value to a variable that is not a variant" or something similar translated from French). The user have to use "" to explicitely... 1 23.08.2006 14:26:37 Question on Access ODBC I work with SQL a lot, but have very limited expertise with Access. There is an application (dashboard?) out in a file folder that points to an old database server. It's a SQL server with about 400,000 records on it. I need to change to a new server. The old one is Windows 2000, SQL 2000. New one is Windows 2003 and SQL 2000. All the other applications on the new server work exce... 10 23.08.2006 02:50:19 Connect to SQL SERVER 2005(90) how can I connect To SQL SERVER Express 2005 database with ACCESS 2003?... 1 22.08.2006 13:03:01 Limiting user access and DSNs Hello, Here's something for you to ponder over: We use SQL Server 2000 as our RDBMS, but not everyone has the knowledge or tools to access the data in the way that they would like. So we create groups of users and allow the groups to access some of the data (mostly views) with read-only permissions. To allow the users to manipulate the data in a way that they are more comfortable with we... 2 21.08.2006 16:40:40 ODBC-Driver for informix Hi, Who knows good ODBC-driver for Infomix Server 10 DB's. (Not the IBM CSDK'-driver) Thanks ... 2 18.08.2006 13:27:02 ODBC FAILURE when trying to reference form control I have hit a block and I would like to see if someone can help me out. I have a form (frmStockEditor) bound to a local table (tblNewStock). This form has a field called retail. I use the code shown below with this table to 1. record an audit trail of changes 2. update another database (odbc) with the change This works but I am having trouble with the next step I have a need to also ch... 2 17.08.2006 07:47:40 Problem after upsizing I've done the upsizing of my Access database with the SSMA wizard of Access. This has worked well, but I've got the following problem: On a lot of places I have this code: Set DB = DBEngine.Workspaces(0).Databases(0) Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE) When I run the code, it gives me an error: 'Illegal operation' (something like that, I have a Dut... 7 16.08.2006 15:02:17 #Deleted appears in column in MDB, but data is good I'm running WinXP Pro, SQL Server 2000 back end, MS Office Access 2003 front end - Access is ver. 11.6566.6568 SP2 - Component checker shows MDAC 2.8 SP1 on Windows XP SP2 - Control Panel, installed programs shows MDAC KB870669 is installed - ODBC Data Source Administrator shows Microsoft Access Driver (.mdb) is ver. 4.00.6304.00; however, in the dialog box MS Access > About > System... 14 15.08.2006 22:28:16 Linking to Fox Pro 8 tables from Access Hi, I'm trying to link to tables in a Visual Fox Pro 8.0 application from an Access 2002 database running in WinXP. I've tried using both the link and ODBC option in the Get External Data to do this but can't seem to get anywhere. I'm fairly new to this so can somebody please tell me what if anything I'm doing wrong. Thanks. Kevin ... 1 14.08.2006 20:35:34 DB2 on AS/400 table linking issue For the past 2-3 years I've been using Access (2k3) to connect to our DB2 db on our AS/400, using DB2 Connect (Personal Edition). (IBM iSeries Access ODBC drivers working, but not the way I needed, like the DB2 Connect drivers do.) I can still rtrieve data from existing linked tables. Everything *appears* to be fine...until now, when I try to link several additional tables... In the last ... 1 09.08.2006 12:47:35 Confirming ODBC Connection to SQL I have an application with Access as frontend and SQL as backend, using ODBC. When the User logs on thru his/her frontend, I need the Access frontend to verify that they are online and the connection to SQL is available, otherwise I need to restrict their activities to limited offline functions. How can I have Access verify that the ODBC connection is available?? I suppose using a tim... 2 07.08.2006 09:08:46 odbc and db2 I am trying to connect from access to db2 table on local machine I do : get external data - logon - table list is displayed selecting any table returns : you are not connected to an sql server database Is connection to other odbc resource not allowed ? or any other setting to activate db2 is locally installed and odbc source defined with correct driver : ibm db2 Thanks for all info Bes... 1 06.08.2006 09:18:26 Trying to delete in a passthru query Dear Group, I'm trying to create a passthrough query to delete a set of records in a SQL server table. I've tried using MDB/ODBC/DAO and using ADP/ADO without success. Here's the query: DELETE dbo.tblInventoryValue.Part FROM dbo.tblInventoryValue; Executing this results in an ODBC - Call failed. ..."Invalid object name 'dbo.tblInventoryValue.Part' When I turn it into a select q... 3 03.08.2006 17:55:03 get @@identity Using msAccess 97 and a Pass-through query I can Insert in a ms-sql server table, but I don't know how to get the identity Everaldo Ricardo ... 2 02.08.2006 08:12:46 Update Access record from SQL linked table using AfterUpdate event? Hi All, Hopefully someone can help with this problem. I have an Access 2000 application which contains a Patients table with an ODBC linked table to a similar (but not identical) Patients table in an SQL Server 2000 database. There is an associated form in the Access application which is bound to the Access Patients table. What I would like to do is enter a Patient ID into the Patients f... 2 01.08.2006 18:46:34 ODBC Linking Problem I am trying to link to tables in a SQL server. Seems simple enough, but I am running into a problem that I hope is simple setting I can't seem to find. When right-click and select the "Link Tables" option, it brings up the dialog box. I select the "ODBC-Databases" from the drop-down list, and presto, the dialog box disappears and nothing happens. I never get the dialog to pick my so... 3 29.07.2006 14:10:02 See ODBC connection info from MS Access via VBA Hi I am trying to find a way to view the connection information in a system DSN ODBC Connection to a SQL Server DB. In fact, the only thing I really need to view is the name of the server. I am wanting to pull the server name from the ODBC connection so that I can display it in my applciation to avoid confusion over where the frontend application is pointing (since I occasionally reconfi... 9 29.07.2006 13:04:51 Transaction on SQL server I would be very grateful if someone can help me with the following problem. I have the front end application written in Access (MDB). Tables in the aplication are the tables from SQL 2000 server and they are linked over ODBC connection. In some process I have to run more action queries and this must be processed as transaction. If error occur in any of this queries then I want that a... 3 25.07.2006 07:05:05 odbc time out I am trying to access a very large SQL database with Access and get a "time-out" message. Any ideas??... 2 25.07.2006 04:58:14 Passthru Parameterized Queries, the right way? Dear Group, I'm using SQL server 2000 with an Access 2003 application utiliting a DAO/VBA based design. I want to change my embedded, text based queries to queries in the query list. Usually, my query code looks something like this: (in form MyForm:) ... Dim RS As Recordset Dim strSQL As String strSQL = _ "SELECT * " & _ " FROM TblQuoteDetail" & _ ... 1 18.07.2006 15:56:05 Is there a method for updating ODBC string for pass through queries Hi, I want to use a pass-through query to push execution of a query to my SQL server. The one issue i can see is that we sometimes move the SQL server database location. Is there a way to programatically update the ODBC string used by a pass-though query? Thanks, Jerry ... 2 17.07.2006 23:34:22 Unable to connect to database I have a series of data access pages that connect and allow users to work with the database. This appears to all be working fine. When I launch Access though to edit the data access pages the connection fails. But when I test the connection in Access it says the connection succeeds. I'm confused as to why across the network the data access pages successfully connect but from with... 5 16.07.2006 23:30:12 Login to SQL Server ODBC On one of my computers when I open ODBC to attach tables from SQL Server to Access 2002 db it doesn't prompt me for login and password , and taking directoly to the tables list. Looks like somebody clicked remember password. I was looking for how to disable it but seems can't find it. Somebody knows how to enable login/password again? Regards, Michael ... 1 16.07.2006 20:14:01 Form Not Loading or Not Visible Request Assistance: Has anyone had a problem where most forms in a database will load but one won't? I have some users, including myself, who can open all forms without a problem but I also have a few who can open the databse, open/manipulate data in every form except for one. The one form does not appear, it gives the impression that the form is trying to load but won't. Have pop-up... 3 14.07.2006 17:59:01 9 Pages: 1  2  3  4  5  6  7  8  9