Search results for query: *

Admin, if you think this is inappropriate, my apologies; please remove. As I am an old Tek-tips member, I am hoping this post is ok. I have been running my own software development small business for some time. Due to health related problems, I need to wind back, and am looking for an...

Thanks guys; that's a very good point. I'm sure you are right about each workstation having its own copy of the client, in which case changing querydefs certainly isn't an issue. I have tended to use a "shared client" without problem, but of course there are downsides. I do it as it makes...

I have an access application connecting to a SQL database, mostly using ODBC connected linked tables. For performance reasons I also want to use Pass through queries which for complex queries will run much faster. Trouble is, that I seem to need to modify querydefs in order to provide...

I use code to modify the connection properties of an ADP project. Once set, these properties tend to "stick" to the ADP file, and a subsequent re-open of the project and look at the connection properties confirms this. This situation is fine, providing the connection exists, and can be made. I...

Thanks Rudy, Triggerhappy, It all helps, but not quite what I was looking for. I have got quite close using dynamically generated CrossTabbing (using case) and a simple SQL function, and for my requirement, this will probably suffice. I may have oversimplified the spec. The number of...

Thanks guys, Did a search through the forums, but didnt find anything that I could use: (a) I have a solution working which works using the CASE statement to crosstab in an SQL serverside function, but this only works where the crosstab values are finite and known in advance; which is not the...

I have a table with the following fields: Date City Category Value 01-Jan-07 London A 100 02-Jan-07 London A 150 03-Jan-07 London B 120 04-Jan-07 London A 100 05-Jan-07 London B...

thanks hennep; have tried that; i know that the key combination i am pressing is correct, because it does respond when i include doevent commands in the code. without them though; its very slow to respond; thats why i think its an os config issue. Steve Lewy Solutions Developer SimplyData...

Aceman, Unlikely; as stated, the DoEvents is honoured correctly. I just think that at some operating system level (perhaps), the keyboard interrupts need reconfiguring; just dont know how and where to do this. The DoEvents command would force this, but the default otherwise is what needs to be...

Yes; it is Control-Break, as I indicate several times in the body of the post. Anyone got any ideas on this one? TIA Steve Lewy Solutions Developer SimplyData simplydata.com.au (dont cut corners or you'll go round in circles)

This may be an operating system configuration problem, but I will pose it here as its manifesting when I attempt to run some VB code from Access. I am configuring a new computer (Sony VIAO) to replace an existing Dell I have. Both are running XP Professional. Both have been installed with...

I am looking at hosting a Microsoft Access application on a Citrix Server, so that I can provide remote access to it via a browser. There would be a limited user base (hopefully growing), but "reasonable" performance is important. I am looking for a hosting company that can provide me access to...

Thanks all for your input so far. I may be between a rock and a hard place here, mixing HTML and ASP Controls. Dilema is: If I do a standard submit of the form, I get access to the standard form fields via Request.Form etc, but I lose the postback capability. If I use an ASP button to initiate...

Thanks for the reply Phil. Perhaps I didnt make myself clear. The control I am attempting to access from the serverside postback script is defined as an HTML control: ie. <input type="text" id="HTMLText" value="123" /> This has no visibility to my serverside scripting; i.e. reference...

I am using some client side script to dynamically add rows to a table to simulate a datasheet where the number of rows can vary. This uses the Document Object Model. Inside the table cells, I am adding HTML Text INPUT controls. Here are my questions: (a) The existing form that I am using has...

Thanks guys for your help. Steve Lewy Solutions Developer SimplyData simplydata.com.au (dont cut corners or you'll go round in circles)

Thanks guys, Your information has been most valuable. Unfortunately, whoever put together the backup mechanism over here is long gone. Fortunately, we are reviewing it. One further question. It appears to me, that SQL Server has all of the capabilities to look after its backup scheduling (both...

Thanks Denny, Fortunately this is not a real situation; I am auditing an existing backup mechanism. This mechanism seems to imply that by taking midweek backups of LDF files somehow facilitates a capability to re-constitute a database to the last transaction in the LDF from a prior saved full...

I have been been asked to perform the recovery of a database as a disaster recovery exercise. I have recovered an MDF file taken at the end of last week called MyDataBase.MDF, which represents the full backup taken at this time. I have also recovered an LDF file taken on Tuesday evening...

Thanks Denny, I realise all of that. However, still might be nice to hold some sort of last access'ed stats, maybe at the connection level. But I take your point, if someone wants this badly enough, use the profiler, and build it into the app. Anyway its to the profiler for me (sigh), Steve...