Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed against it), in the same way as you would use SQL Profiler for the SQL Server?
I need logs of actual queries being called.
I have set up a pull subscription to a merge publication in SQL Server. I use parameterized row filters on some tables. This works fine with the initial synchronization - just the rows using the filter arrive in the replicated (client) database.
However, at some later point I'd like to be able to synchronize the replicated database again from the…
What is the preferred method of refreshing a combo box when the data changes?
If a form is open and the combo box data is already loaded, how do you refresh the contents of the combo box without the form having to be closed and reloaded?
Do you have to do something on the Click event on the combo box? This would seem to be a potential slow down…
Is it possible to register a .NET component during the installation of a VB6 app?
Is it also possible to grant security (eg. via CAPSOL) as part of an installation package?
If I have an existing IInterface descendant implemented by a third party, and I want to add helper routines, does Delphi provide any easy way to do so without redirecting every interface method manually? That is, given an interface like so:
IFoo = interface
procedure Foo1;
procedure Foo2;
...
procedure FooN;
end;
Is anything similar to…
I have a Recipe model which has_many Ingredients (which in turn belongs_to Recipe). I want Ingredient to be existent dependent on Recipe; an Ingredient should never exist without a Recipe.
I'm trying to enforce the presence of a valid Recipe ID in the Ingredient. I've been doing this with a validates :recipe, :presence => true (Rails 3)…
Because IE won't do document.getElementById(ID).setAttribute('type','password') I've re-engineered the way the password field woirks on this site:
http://devdae.dialanexchange.com/Default.aspx
so it works in accordance with this idea:
…
What is the easiest way to detect a character in a text field?
I want to be able to detect a certain character and replace that character with another specific character.
So If I write in a text field... "zyxw" I want it to be…
What does Error 3112 indicate when compacting an MDB file?
The Error description is "Records can't be read; no read permission on 'xyz123.mdb'"
There is a known issue with the Compact function on some versions of Access MDBs. …
In a basic HTML web page, how do you make the user have to enter a username and password before they are allowed to download a file.
What is the best way of achieving this on a website, preferably in plain HTML.
Can you create a linked server in SQL Server 2008 and then refer to it with an alias.
So, I create a linked server to "SalesServer", but I give it the alias "Sales", so I can use it like this:
SELECT * FROM…
VB.NET: Can the .EXE built by VS2005 be deployed as a standalone EXE?
When I change the mode in VS2005 to "Release" and build the solution, the bin\Release directory then contains the solution .EXE file, but…
Hi,
I am developing my first big application using codeigniter and need a little help as I am fairly new to it all. I know how to get records out of the DB and display them, but I now have to get results…
I am using the version 1.0 release of Linq for nHibernate. When I run
the following linq statements I receive the error
not a single-length projection: Surname
I can find very few references to this on…
Why would there be a "Conversion Errors" table in an MDB?
Does this mean there was an attempt to convert the MDB to a different (newer) version of Access?
Does the following article apply to all uses of JET (including from within client apps via DAO or OLEDB):
http://support.microsoft.com/kb/275058
Does this mean JET 4.0 or above is mandatory for…
In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException
Invalid object name 'tableXYZ'
but tableXYZ is a table in the database.
Should it be looking for…
Consider the code:
On Error Goto ErrorHandler
Using sr As StreamReader = New StreamReader(OpenFile)
str = sr.ReadToEnd
sr.Close()
End Using
Exit Sub
ErrorHandler:
If there is an…
I have noticed in a number of apps they let you see a zoomed in view of where you are dragging just like the way it is on a UITextField (screenshot attached) but it works over images etc.. …
This is my first attempt with Mootools, so I welcome a critique of the code.
I have a dynamic list of images that expand on the 'click" event and contract on the 'mouseout' event. The…
I have come across a class which is non-static, but all the methods and variables are static. Eg:
public class Class1 {
private static string String1 = "one";
private static…