Threads Replies Last Post 44 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  30  >>   °¡ ... 1 3/26/2007 7:46:01 AM ÕâʱԭÈËÕæÊDz»¶àѽ ... 1 3/24/2007 12:35:59 PM Locating Oracle servers on network I need to find all of the oracle servers running on our network, running on various machines. Is there a tool available that can seek out these servers Name , i have default port for it 1521 Or if there is code someone wrote to do this, that would be equally helpful. -- Regard Parixit Pandey ... 3 3/24/2007 2:34:48 AM ʵÑé Ê÷È˵çÄÔѧУ ... 1 3/24/2007 2:29:31 AM hello good ... 1 3/23/2007 3:11:46 AM Editing Views from ADP How can I programmatically retrieve and save the SQL for a View/SP/Function from Access ADP. I assume I'll have to use ADOX and the various Allxxx collections, but have no idea of what to do beyond that. Thanks, Rob ... 8 3/22/2007 5:42:11 PM Trigger I made a table to register update,delete and insert from some tables, in this table i have a field named user that take the 'system_user' as default value and is working well, but in a field named eqp that i set 'host_name()' as default value, it's catching the my station's host name, where i made the system (detail: it's off) ... 22 3/22/2007 12:23:10 PM so boring I am so boring! Is there anyone want to chat with me?... 1 3/21/2007 4:35:28 PM xxvxxvx ... 1 3/20/2007 10:35:44 AM Testing news for rules Testing news for rules ... 2 3/20/2007 4:53:20 AM Appending thru Access Hi, I am new to using an Access (2k) adp to work with SQL Server (2k). I'm not sure what all I can do. Can I append new records to the SQL Server db thru Access? Thanks! ... 2 3/20/2007 1:42:03 AM IMPORT DATA FROM SQL ON REMOTE SERVER TO ACCESS Hi all, I have a local Access DB which I need to import data from a remote SQL server once a day, is there any way of doing this automatically? regards Simon -- Simon Gare The Gare Group Limited website: www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk ... 2 3/18/2007 3:54:04 AM ADP2007/SQLServerExpress RIP I am giving up. I figured maybe there was a bug in the Data Link dialog in finding a named instance of Express, and so I tried uninstalling and reinstalling in order to create a default instance, but it keeps creating the named instance. I even went so far as reinstalling VISTA before I reinstallled SQL Server Express, and it still creates the named instance without my prompting. An... 3 3/17/2007 4:24:11 PM Problem with data refresh In the application there is a Parent form that contains a sub-form showing a summary of Child records. When the user double-click the child record list it brings up an edit form allowing the user to makes changes to the child record. When the user clicks Save and then Exit, there is code behind that forces the sub-form to refresh itself so that the edits made are reflected. When I r... 5 3/17/2007 3:33:56 AM pass value to html variable Hi, I am attempting to select a value in a combo box in a form in access 2000 and pass it to a variable in an html document. How can i do this? Thank you very much. ... 1 3/15/2007 8:27:09 PM ÉúÈÕ¿ìÀÖ£¡ ¡¡¡¡ÀîÕ䣬ÄãºÃ£¡ ½ñÌìÊÇÄãµÄÉúÈÕ×£ÄãÉúÈÕ¿ìÀÖ.ÎÒËÍÄãÒ»·ÝÀñÎï.Ï£ÍûÄãÄÜϲ»¶. ... 1 3/15/2007 3:10:15 AM ÉúÈÕ¿ìÀÖ This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C7661F.E2C32E50 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable = =BD=F1=CC=EC=CA=C7=C4=E3=B5=C4=C9=FA=C8=D5=D7=A3=C4=E3=C9=FA=C8=D5=BF=EC=C0= =D6.=CE=D2=CB=CD=C4=E3=D2=BB=B7=DD=C0=F1=CE=EF.=CF=A3=CD=FB=C4=E3=C4=DC=CF= =B2=BB=B6. ------=_NextPart_000_001A_01C7661F.E2C32E... 5 3/15/2007 1:26:25 AM CONNECT MDB FILE FROM ADP FILE Hello. From a adp project connnected to a MSDE database, i have local setting in a local mdb file. The connection with ADO to the mdb is only read access. The connexion with DAO works fine but always give me a log windows and a error message at the first connection to the mdb database. The second connection is successfull without any log window or error. I whant to connect to the mdb ... 8 3/14/2007 7:15:12 PM error # 2147217887 Hi everybody I have a stored procedure like a record source: ALTER PROCEDURE [dbo].[SPVistaClientes] AS SELECT [Código de Cliente], [Código del Proveedor], [ID de Cliente], [Código ALKO], [CIF/DNI], [Razón Social], Nombre, Dirección, Fax, Movil, [Telefono 2], [Telefono 1], [E-Mail], Web, [Código Postal], [Fecha de Alta], [Código de Banco], Banco, [Código de Sucursal], [C... 11 3/13/2007 6:45:37 PM Stored Procedure Error Question Using SQL2000 and Access 2000. I'm still a bit confused about Error trapping. Below is the script for creating a test table and stored procedure. The parmReturn value is zero, whether the stored procedure has errors or not. However, the TestPhone field is unchanged, so the transaction rollback has worked. If I try from Query Analyser DECLARE @err INT EXEC @err = aaaTest_SP ... 4 3/12/2007 3:29:59 PM ADP SQL Database Backup From the Access ADE menu system you have an option under the TOOLS, DATABASE UTILITIES menu to Backup, Copy and Restore SQL Server Databases. I've run the Backup and Restore options and find these will serve my needs. With research I found the Docmd.TransferSQLDatabase and Docmd.CopyDataFile commands, but these two do not perform a simple backup as I'm looking for. Basically, these comma... 5 3/12/2007 11:34:45 AM Watch Satellite TV On Your PC <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY><FONT size=2> <P><!DOCTYPE HTML PUBLIC </FONT><FONT color=#0000f0 size=2>"-//W3C//DTD HTML 4.0 Transitional//EN"</FONT><FONT size=2>><BR><html><BR><head><BR><title... 1 3/11/2007 6:20:42 PM Problem with Serverfilter for Subform Hi, in my Access application I have a form with a subform both linked by the master/child properties. In the subforms header I have a combobox that allows the user to display a subset of records that matches with the value in the combobox plus the values of the current master/child properties. I use the subforms ServerFilter property to apply the filter to the form. My vba code in the... 3 3/9/2007 8:29:39 PM How to trap error message from sql server 2000 The customer has sql server 2000 with access 2000 client (adp). From the client the operator start a delete followed by an insert into a sql server table, about 150000 old records need to be deleted and then new records are inserted. The delete and insert is done in a stored procedure within a transaction block. When an error occurs I do a rollback of the delete/insert operation. I ha... 8 3/9/2007 9:46:29 AM Upsizing wizard access Sql Server express hello all im noobest ssme user here. I am trying to export my access backend database into sql server express 2005 by using the upsizing wizardi go to create new database option and click on trusted connection and when i hit next it gives me a microsoft sql server login error: connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server Driver][Shared Memory]Connect... 8 3/8/2007 5:22:42 PM 44 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  30  >>