Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Guaranteed Millionaires http://guaranteedmillionaires.blogspot.com/... 1 12/31/2008 10:09:44 PM How best to trap for errors, things like required fields that are null? Is there any systematic way in which one can handle odbc data errors on Access 2003 forms? sql 2005 is the backend. Example is if a user does not enter a value into a required field in a subform. If they click the save button, which runs code to save the record, I can trap for error 3146. But if the user clicks outside the subform, and Access tries to save the record, I can't find any w... 3 12/21/2008 10:13:47 PM select unique field when linking to a sqlserver view by code When manually creating a linked table whose source table is a sqlserver view, Access prompts for the unique field, without which the linked table isn't updatable. I need to create such updatable linked tables by code (with CreateTableDef). Access doesn't allow adding indexes to linked tables, so my tables are read-only. Is there a solution? TIA Dan ... 3 12/21/2008 10:04:44 PM MS Access, ODBC, SQL 2005, delays before data appears Hi all, We are using MS Access as a front end, SQL Server 2005 as the backend. Tables are linked using ODBC (they are attached using code). the cursorlocation is adUseClient. We do not seem to have any problems but occaisionally we seem to 'miss' data for a few minutes: Let me illustrate with a simple design: Table 1: orders Table 2: orderdetails (with a combo that links to the parts) ... 6 12/18/2008 8:55:48 PM How do Access Queries Work with ODBC I have a question on how Access queries work. I have a .mdb and all tables are linked to a SQL backend. When I create a query and add criteria, does Access bring all the data from that table to the client and then applies the criteria or are the criteria applied on the server and only the data requested by the query sent to the client? ... 3 12/4/2008 7:52:04 PM my odbc connection drops after a while. I am using Access 2007 to connect via ODBC (SQL Native Client driver) to our MSSQL server 2005. Nothing wrong with the connection except that it drops after about 8 to 10 minutes. Is there a time out / keep-alive on SQL or ACCESS that needs to be set? Thanks. ... 10 11/4/2008 2:03:02 AM Question about 2 functions Hello all, Maybe I am not understanding how calling a function is supposed to work or just doing something silly. I am linking to SQL tables in Access. Here is my code and i will try and explain it step by step as I see it Function LinkTables() Dim db As Database, rs As Recordset, tblName As String Set db = CurrentDB ***Table that has the names of all the tables I need to link to**... 4 11/3/2008 6:14:02 PM Using a table-valued function of a linked SQL Server database Hello, is there a way, to use a table-valued function stored in an SQL Server database, to get the results into a MS Access database? It should also be possible to pass parameters to the function. As the function is not listed in the linkable table list, I'm not sure how to do that. Is there a way to set up a Module, that uses the existing connection to a specific linked table, exe... 3 10/30/2008 3:07:53 PM Using Active Directory Data in Access I need to document permissions on my network and would like to link Access to Active Directory data so that I can build Access reports using Active Directory data. Is there any simple way to do this?... 5 10/25/2008 4:59:59 AM ODBC, FoxPro, WinXP, WinVista, Off2003, Off2007: testing... x-post to microsoft.public.access.odbcclientsvr, microsoft.public.access, microsoft.public.it.office.access follow-up to microsoft.public.access § Hello The procedure is currently running on Windows XP, with Access 2003, ODBC driver to access some external databases VisualFoxPro, driver v. 6.01.8629.01: it's working fine ;) Now I'm testing Windows Vista... 1st try, with Acc... 1 10/14/2008 2:56:44 PM Use OpenDatabase to open ODBC System DSN Hello, I give up try to figure out why I can't have the Access 2003 module open an ODBC connection to a System DSN that is setup and works otherwise. Here's what the help says: "A String that is the name of an existing Microsoft Jet database file, or the data source name (DSN) of an ODBC data source. See the Name property for more information about setting this value." Specifical... 4 7/1/2007 1:40:05 AM Differences between SQL Server 2000 and MSDE 2005 Pass-Thru Querie I have a working stored procedure in SQL Server 2000 that needs to be converted to MSDE 2005 SQL Server Express. When creating the stored procedure in MSDE 2005 I noticed that they are stored as projects with a .sql ending. What changes must I make to call the stored procedures in MSDE vs SQL Server. The SQL Server stored procedure is called from Microsoft Access as such: Public Su... 2 6/30/2007 1:13:46 AM ODBC workspace object prevents MSAccess from closing Here the whole story: We have a programfile A.mdb (Version: MSAccess 2003), which instanciates a COM component B.dll, which in turn instanciates C.dll. In C.dll, we do some database manipulations in an SQL server database, therefore we create a workspace like follows: set mwspDAO = DBEngine.CreateWorkspace("wspData", "", "", dbUseODBC) Later when A.mdb should terminate (with the command: a... 5 6/28/2007 11:24:56 PM ACC2007 (on XP) linked to SQL 2000 ODBC - Slow Performance Hi all, I have an MDB being used successfully with ACC2003, connecting to SQL 2000 via ODBC. However when I open the exact same MDB (ie Access 2003 version MDB) with ACC2007 I have severe performance issues. I have a query returning approx 60000 records. In ACC2003 the form takes less than a second to load. In ACC2007 the form takes between 10 - 30 secs to load. After the form ... 1 6/27/2007 3:44:00 AM global users using remote desktop connection - databaseread only e I have three users logging onto a server using remote desktop connection. They open the access database on the server, which has a sql backend. This process works fine for one user, but the other two get a database is read-only error. Any ideas what would cause this? Also, everyone locally can log into the server and use the database without any problem.... 5 6/26/2007 12:41:50 PM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:25:51 AM Problem adding linked-table via ODBC (Access 2003/Vista Ultimate) I am running Access 2003 on a Vista Ultimate box. I am attempting to create linked tables to a FoxPro database using the Visual FoxPro Free Table driver. When I attempt to add a linked table and choose ODBC Database (from the Files of Type in the Link window) the dialog simply closes and takes me back to the active Access window w/o allowing me to select the ODBC DSN. So, the operation t... 3 6/20/2007 1:37:21 AM Changing Recordsource Property in subreport I'm just starting to use pass-through queries to sql server which I am setting in code. I set the recordsource of report to this query. Hopefully, this is right. strSql="SELECT * From Table Where Field=" & Parameter CurrentDb.QueryDefs("qryDCAReport").SQL = strSql Report.RecordSource = "qryDCAReport" Do I need to set the subreports in this report to pass-thrpugh queries,... 5 6/19/2007 6:25:48 PM Problem adding new record to ODBC linked table Hi, I have just recently moving my back end to SQL Server 2005 and reconnecting my table through ODBC. I have got an error trying to insert new record. First I got an error message told me to change from dnOpendynaset to dbSeeChanges when I ... I got error 3001 - Invalid agument I use Office 2003, Windows XP Private Sub Option1_Click() On Error GoTo Err_Option1_Click: Dim wsp As... 4 6/19/2007 6:16:42 AM Suppressing ODBC pop up error Hi there, I have a client-server application that periodically connects to an Access database on a network. My netowrk sometimes goes down and there is an ODBC failure to connect. This results in an ODBC error pop up window. I am interested in suppressing this pop up, catching the exception and simply saying "network is down" or something like that. Is this possible? How is this done? My... 3 6/17/2007 1:39:21 AM iif (immediate if) in pass through query? Can the IIF statement be used in a pass through query? I copied a query that works fine in Access, but when I changed it to a pass through query and tried to run it, I get an error ODBC--call failed [Microsoft][ODBC SQL Server Driver][SQL Server]Line1: Incorrect syntax near '='.(#170). Here' the code: Sum(IIf([ActualCostRevised]=0,[CostReduction],[CostReductionRevised])) AS CostReduct... 3 6/13/2007 2:02:01 PM Identity_Insert Problem I have Access 2003 and SQL-Server 2000 SP3a. I want to copy the data of several tables from an Access DB to an SQL DB. In an mdb-program I link all the tables, so that I have normal linked tables (the source) and odbc-linked tables (the target). The tables have an identity, so in a special ODBC-direct workspace I send the TSQL-statement "SET IDENTITY_INSERT mytable ON" (which seems to be... 11 6/12/2007 10:41:01 AM ODBC Update Error I have an Access 2003 database that is using ODBC tables linked to SQL Server 2005. I am a novice at this, so please forgive me for my ignorance. I am trying to update a record, in code, on a forms command button click event. Here's the code: strSql = "SELECT * FROM Request" _ & " WHERE RequestId=" & intRequestId _ & " and RequestVersion=" & intRe... 6 6/8/2007 7:19:25 PM Help with code Hi, Refer to http://support.microsoft.com/kb/184608, I create a form with neccessary fields to create DNS connection to my SQL Serevr. I have used code provided by the above article, but I am having problem to understand about the driver path (DriverPath = "<path to your SQL Server driver>") and I got error when not supplying this field. What input should I give to the 'Driver... 2 6/7/2007 12:36:00 PM Optimize Access after splitting out tables to SQL Server I split an Access 2003 mdb to access front end/sql server back end. I got everything to work, but some forms are slow when remote users are trying to access them. I want to optimize the Access database to make better use of Sql Server. I don't fully understand the Stored Procedure concept and pass through queries. I was able to create a pass through query, but don't understand how can yo... 5 6/6/2007 1:30:53 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12