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   Access SQL server from remote computer I hava an access ADP, now I woul like to access the back end in SQL server 2000 in my computer from a remote computer by internet to make testings. How can I do? I would like to access by IP, is it possible? Thanks Jose... 13 06.02.2006 06:58:52 !AddNew doesn't. ...cannot insert NULL 'rowguid' In a Project connected to (local) Anonymous Merge Subscription, cannot Add a New Record programmatically. Works fine from Table View and Standalone Form created with Wizard. CommandButton Event Procedure is a Cut-and-Paste Code that works several other places in the ADP. In this Form it Errors out at "rst2.Update" Run-time error '-2147217873...': Cannot insert the value NULL into colu... 6 06.02.2006 01:35:35 Hide views, sp and functions I have an ADP (acc2003 vs SQL server 2000). When I open the ADP, nobody can see the tables, views, sp and functions. F11 is not enabling. But from enterprise manager, we can see all tables, views, sp and functions. Question: Is it possible to hide definitely these objects? There is a way to transform in script and hide them? Thanks Jose ... 4 05.02.2006 19:32:51 Animals in China mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sales@lpi-hk.com ... 1 04.02.2006 10:03:51 Animals in China mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sales@lpi-hk.com ... 1 04.02.2006 10:03:45 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:06:24 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:06:24 Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments I would like to run a stored proc from my ADP project in my SQL server. I want to use the DoCmd.OpenStoredProcedure in order to get the result displayed automatically in Access. The fact is I have to 2 arguments to pass to the sp. Is there a way to create a on the fly a sp like "CREATE PROCEDURE spOnTheFly AS Exec mySPWithArguments arg1 arg2" and to call DoCmd.OpenStoredProcedure spOnTheFly. ... 2 03.02.2006 13:25:03 Function IIF in ADP In MDBi use IIF function. How can I use this function in ADP ( view or sp)? There is a similiar function? Thnks José ... 4 02.02.2006 22:58:22 Goji Juice From: birdlady444 Check out my sites and my Goji Juice Try one cap full for a Healthy You and feel and act younger. It taste good too. We have Vitamins also and a lot of other things. Check it out. Do you want to loose weight, take 4capfuls of Goji Juice. Yes, come and try some. I have, it is Great! Made from real Goji Berries From the Himalayan Mts.It has helped people li... 1 02.02.2006 20:52:46 reporting problem with sp2 I'm using an adp project connecting to sql server. When I click on the Office Links button of the report section in order to publish my access report with microsoft word, getting below the error message. "Microsoft Office Access could not find the database on the server. Verify that the database name is correct." I already connected with administrator privilege and getting this error ... 2 01.02.2006 22:01:07 Seek method on Recordsetclone Hi I'm trying to implement something I've done many times in Access - but this time in a .ADP connected to SQL Server. What I'm trying to do is requery a form and then put the form "on" the record it was previously on. This should be easy 1. Get the form's current PK value(s) 2. Requery the form 2. Open a RecordsetClone 3. Do a Find or Seek on the recordset 4. If successful (i.e. n... 5 01.02.2006 10:05:58 Referencing GUID in VBA code to SQL db Hi, I am trying to delete some SQL db data using the following VBA code: <connection string....> strSQL = "DELETE * tblEmployeeVProject WHERE fldEmployeeVProject_ID=" & Me.fldEmployeeVProject_ID_old cmd.CommandText = strSQL cmd.CommandType = adCmdText Set rs = cmd.Execute -- Notes: fldEmployeeVProject_ID_old is a GUID - all I get for strSQL is DELETE * tblEmployeeVProject ... 4 01.02.2006 06:32:29 How to display a Checkbox for a field I have a view I'm creating that is somewhat of a summary view. The Bit field it has no problem displaying as a checkbox, that's the way I have it defined in the Table. However, what about displaying Checkboxes for other fields? For example, I have a field called LastAction. If the LastAction field is Not Null I want the checkbox to be checked, if it IS Null, I want the checkbox unche... 5 30.01.2006 16:47:29 Access 2003 & SQL Server 2005 We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some incompatibilities between Access 2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying with Access 2000 be better? Thanks! Neil ... 5 30.01.2006 04:46:38 Retrievin SQL Group Info on logged in user I would like to retrieve the current users SQL group membership. What I want is to be able to write code like: If USERNAME is member of POWERUSERS Then Do something Else Do Something different End If Thanks for any help... 3 29.01.2006 15:02:56 How to order rows on a form Access 2003 .adp application using an SQL Server backend database: On the Data tab for a form, I have specified the following in the "Order By" property: tblJusticeClientProgram.StartDate DESC Problem is, this specification is not honored. The Record Source is specified as a table name: tblJusticeClientProgram The form is used as a subform. Is there something else that needs t... 3 29.01.2006 15:00:02 Error 3021 EOF or BOF or deleted...Solving it in a stylish way Digging around I've read that the problem can arise on large recordsets at server's cursorlocation. Nevertheless even if treating a client cursor the problem still arised. So I had to manually code a loop statement until the recordset's clone is fully loaded....UGLY! Any better hint??? Heres' the code Dim rs As New ADODB.Recordset rs.CursorLocation = adUseClient ... 4 28.01.2006 20:50:02 CommitTrans in Forms I have an MSAccess form in "continuous forms" mode that is bound to a table. Records can be added, deleted and modified within the form but there is a command box that allows the user to CANCEL. Is there a way to use BeginTrans, ComitTrans and Rollback to accomplish this? From what I've read about this feature it has to be based on a connection object and the form does not really open ... 4 28.01.2006 00:56:36 Access Project - need to trim fields This is my first Access Project to develop, so I'm learning the ropes of dealing with SQL Server. One thing that cropped up is that the "char" fields seem to be filled with training blanks. On forms that's only "strange" and an inconvenience, but on reports it can force extra rows for "can grow" fields. I solved the problem by doing an rtrim() on all the fields in a query before using them in... 5 27.01.2006 17:53:20 Page Hits Calculations Hello Everyone, I have set up a table that contains the following fields 1. DateAdded 2. PageName And I am trying to write a query that will pull back records for me where I can count up the number of times a page or pages were hit on the website for each day. So if my records were like this DateAdded PageName 1/1/2006 /ind... 2 27.01.2006 17:04:20 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:23:34 calling sql server udf in adp from vba I am using Sql Server 2000 backend with an Access 2002 ADP frontend. My Sql Server UDFs appear in the Queries container in Access, but I can't find how to call them. I am trying to call a scalar function to which I pass a date. I want to assign the result to a control on the form. Can anyone help? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/ac... 12 26.01.2006 23:55:47 saving datasheet view I'm using an access project to view data from a Sql Server database. Is there a way to save the changes I make to the datasheet view (like column width, order, sorting) in the adp file? It used to ask me if I wanted to save changes when I closed a table but it doesn't anymore. Thanks, Michelle ... 3 26.01.2006 14:37:27 Existira problema en Bases .... Hola Grupo Existira problema con una Base de datos realizada en sql server 2000, al pasarla a Sql Server 2005 Standard? Si cambio datos o agrego tablas, vistas, etc luego vuelvo a utilizar esas bases a Sql 2000? Gracias. Pablo B. ... 1 26.01.2006 14:33:47 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