Threads Replies Last Post 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29   KSDSAKJDASDKJHJ ÎÒÏëÕÒÅ®ÅóÓÑ°¡ ... 1 01.06.2006 08:09:09 ÖìÁ¼ÓÑ ´ó¼ÒºÃ°¡£¡ ... 2 01.06.2006 08:07:02 function not working correctly i have a function that returns a boolean value. the value is getting changed properly within the function, but always retunrs false to the calling subroutine. any clues what might cuase this? tia, mcnewsxp ... 12 31.05.2006 17:10:01 Speed of internet I connected SQL Server from my FE created in access 2003 (ADP) from one office to open a report spend 5 seconds, from another office and from another coutry it spend about 20 seconds. The time to open the report depend only from internet speed? Off course for the same report, same BE and FE. How can I know internet speed? Thanks, José Perdigão ... 9 31.05.2006 15:09:17 CommandTimeOut in .adp Please help me out with this! I am connecting to SQL Server 2005 through .adp project connection. For some reason I cannot increase CommandTimeOut property, it is always set to 30 seconds. See http://groups.google.ru/group/microsoft.public.access.adp.sqlserver/browse_thread/thread/e55c3b2d98c36ab7/06065379730c5dbe?lnk=st&q=CommandTimeOut+Currentproject&rnum=1&hl=ru#06065379730c5dbe for ... 2 31.05.2006 14:32:38 Update trigger works in SQL Server but NOT in Access adp datasheet Dear friends, I have a SQL Server database and an Access adp frontend. I use DRI (declarative referential integrity) throughout, with one exception. I have a table Projects in which I save the names of several people working on the project, like analist, projectleader etc, a total of four names. These names are taken from one table Employees. Since I want to have referential integrity... 6 30.05.2006 15:45:14 Quotation marks Hi Everyone, I seem to have come across a problem when transfering data from my VB Questionairre application to an Access database. The application is set up so that users go through answering multiple choice questions and a comments box. When the submit button is clicked, the data is copied into Access using 'Insert, Value' SQL commands. Now the problem I have is that if a user types i... 3 30.05.2006 14:08:02 Run timer Error I'm developing a database in ADP, access 2003. I run the following function Public Function test1() Dim cnn As ADODB.Connection, rs As New ADODB.Recordset, strSQL As String SetWarnings = False Set cnn = CurrentProject.Connection 'Add Recs INSERT INTO dbo.B1_Allocation (dDatez, Wellz, IDWT) SELECT dbo.iDate() AS idate, Wellz, IDWT FROM ... 11 29.05.2006 21:19:18 pb connection between sql2005 and Access Hello, I use an access database and sql2005 All is good when the two databases are on the local computer but I cannot use two differents computers because I cannot connect from Access in that case. Can you help me Thank you.... 4 29.05.2006 08:04:33 sos ³µ´óʦ¸µËæ·çµ¹»ú -- 0000000 ... 1 29.05.2006 05:45:55 Syntax Error or Access Violation on Form/Subform When I open form with subform I got next error: "Syntax Error or Access Violation" and subform area remains white. Any ideas how to solve this? I found same problem here: http://groups.google.com/group/microsoft.public.access/browse_thread/thread/f9a8dd7dee3cecbc... 2 28.05.2006 19:02:11 Problems copying and pasting decimal fields I have a problem copying or exporting from the adp to excel for any field/attribute formatted as decimal. When I paste or export into Excel, excel thinks that it is a text field, and I have to convert to number every time. However, if I load the same query in SQL Query Manager, and copy and paste from it, Excel recognizes it as a number. I know that for Office XP there was a patch for a sim... 3 28.05.2006 19:01:23 NEW PORTAL =========================================================================== FULL LEGAL SOFTWARE !!! Games, video, program, image, chat, questbook, catalog site, arts, news, and... This site it is full register and legal software !!! Please download and you must register software !!! PLEASE REGISTER SOFTWARE: http://www.webteam.gsi.pl/rejestracja.htm DOWNLOAD LEGAL SOFTWARE: http://www.w... 1 28.05.2006 19:00:58 NEW PORTAL =========================================================================== FULL LEGAL SOFTWARE !!! Games, video, program, image, chat, questbook, catalog site, arts, news, and... This site it is full register and legal software !!! Please download and you must register software !!! PLEASE REGISTER SOFTWARE: http://www.webteam.gsi.pl/rejestracja.htm DOWNLOAD LEGAL SOFTWARE: http://www.w... 1 28.05.2006 19:00:50 SNAPSHOT REPORT Might not be the best place for this question. But here goes: I have a web application which stuffs parameters into Access ADP reports. (The user can select to output the reports in rtf, html, PDF, excel PDF, and snp formats.) The rendering works great except for users who have XP installed and who have also requested a snapshot report...these users get the following warning: "The fi... 3 28.05.2006 19:00:40 Oracle BE I have an access database with tables, and links to tables in an Oracle Back End. I want to move all my access tables to the backend, but feel I will be unable to add new records to the newly linked tables because there will be no autonumber field in the oracle tables. Is there a solution using triggers/sequencers ? Any help or comments on this matter would be helpful. Rohan. -... 7 28.05.2006 19:00:34 Ö캣¾ü ... 1 26.05.2006 07:20:52 Ö캣¾ü hi ... 1 26.05.2006 07:12:15 ÖìÁ¼ÓÑ ´ó¼ÒºÃ°¡! ... 1 26.05.2006 07:05:35 Co existence of SQL 2000 and SQL Express 2005 Hi, My access always hangs after having Visual Basic Express 2005 install. It appear to have conflict between the two SQL version. The SQL 2000 service won't start. Anyone have solved this problem before? SF ... 3 25.05.2006 05:50:52 Windows Authentication (SQL2000) I have a database that a select few people will access via an access ADP project (using Windows Authentication). Potentially anyone could open the ADP file (though they shouldnt), but I would expect that they wouldnt be able to edit the data unless I give them permissions in SQL. However, it appears that anyone who opens the ADP file can edit the data via this method. I'm sure I must... 2 24.05.2006 14:06:31 Forms to input parameters in ADP I am having difficulty getting it set up to use a form to pass date parameters back to a stored procedure in my adp. This is my first adp so I am trying to get used to differences between mdb and adp. Anyway, I searched and found code like this: Private Sub Report_Open(Cancel As Integer) Dim strRecordSource As String strRecordSource = "Exec [lmprodmerge] '5/16/06','5/16/06'" ... 5 24.05.2006 10:41:01 Best Practices: Ad Hoc Analysis Front end for Sql Server 2005 I've read quite a few posts about the lack of Access design support for Sql Server 2005, but have a few questions. My understanding is that no current version of Access supports designing objects in SqlSever 2005 (as an aside, if this is true it is a cock-up of truly monumental proportions by Microsoft, both in terms of the basic problem -- incompatibility -- and the stunning lack of coordina... 15 23.05.2006 16:23:01 guid parameter with SQL stored procedures Hello, Need some expertise for this one... I have a SQL stored procedure that returns a value 1 if a match is found in the table based on 2 parameters. Here is the SP: -------------------------------- CREATE PROCEDURE dbo.spCheckDuplicatePOItem_ID -- example usage: spCheckDuplicatePOItem_ID '{75C3A07D-67CD-4DBB-95B3-37F73C77C94F}', '20.D' -- checks if an entry with th... 5 23.05.2006 14:36:43 Edit SQL Server data via an ADP We have a some data in SQL Server that we want a small number of users to be able to edit, so and Access Data Project seemed like the correct route to take. However, having created the ADP file, and linked to the SQL Server, it shows the right tables but wont let us change any values in the tables.The connection uses Windows Authentication and all the relevant users have permissions t... 6 23.05.2006 11:10:18 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29