Search results for query: *

I have recently been asked to amend the server IP address of an access .ade file as the Source Sql database was being moved. As the source code (.adp) file has been lost, I opened the .adp file and changed the connection. I know this worked as I then could see all the tables from the Sql DB. the...

Sql Server 2000 and Transactions - Must be male as it won't commit. I have been using Sql Server for God knows how long and have this problem with transactions which has got me miffed ! Nothing extradordinary in my Sql. I have a SP which contains various Insert & Update commands within a...

I am trying to return the results of a query in Sql Server (to an asp.net front end but this is irrelevant) in page sets depending on a requested Page No. & Page size to reduce the network traffic. I have tried two different solutions, one using a set of nested queries using the TOP clause...

I have registered two SQl Servers on a server running windows server 2003 and expected all the users members of "Power Users" to be able to see those registrations when logging in under their usernames which is not the case. All they can see is the native Sql Server. Are Sql Server...

I was replacing some Stored Procedure code which acesses the System tables to get the same data from the Information Schema tables instead so as to avoid having to change them if the system tables change from version to version. However I wasn't able to find a way of getting the index names...

I am trying to use my machine as a webserver and was expecting the default file path: c:\inetpub\wwwroot ,. to be mapped to the URL http://localhost/ . Somehow this is not happening and when I type http://localhost , I get an html page pertaining to Oracle. How do I re-map localhost to the...

As part of a conversion from Access 2 to Access 2000 I had to change references to DLL functions, mainly user.dll & kernel.dll by suffixing those function names with "32" and replacing both the dlls with the equivalent 32 bit ones, i.e. "user32.dll" & "kernel32.dll" . However I am still...

Is it possible to invoke Lotus Notes e-mail from HTML or does it always assume and will only work with Outlook? i.e href="mailto:e-mail address"

I have just converted an Access 97 system into Access 2002 and have this problem where the first time a report is printed , regardless of the way it was setup in design mode it always previews/prints in Portrait mode, even if the orientation is again specified in the Report open event. I had to...

I have an Access 97 application which invokes Excel programatically. The users are running a runtime version which works fine except for those users which have office 2000. I am using the "TransferSpreadsheet" method.

I am having trouble developing in Access 97, concurrently with another developer using 'Terminal Services', even though we are developing completely different areas of the system (different screens, different modules, etc). "Terminal Services" is a piece of Microsoft software that...