Search results for query: *

It was a good idea, Linney, but unfortunately did not make any difference. I did a work around last night, using another PC (XP home) copied the truncated filesnames to CD and then installed them on my hard drive. Lo and behold long filenames retained and we can now access the data for the...

Thanks for the idea. I'll give it a try!

Thanks Linney, for the info. I did run fsutil after the first copy and also then recopied to a new folder. I could not remember if I had re-booted so I have repeated tonight and checked the value of NtfsDisable8dot3NameCreation and it was set to 1 un current control. I tried copying again with...

Help, if anybody can!..please. I was trying to install a DVD from an Open University course last night. However it failed to install. This was traced to XP (Pro SP2) 'seeing' long filenames on the DVD as 8dot3 DOS format. This occurred even when copied to the hard drive (NTFS formatted). I...

I have a vb6 (sp2) program that uses several ActiveX controls and components. It runs fine on XP and win 2K but after installing on Win 2003 server, 2 parts of the programme (responding to click events) cause the error "Run time erro 429 - ActiveX components can't creat error". I have installed...

Can anyone help me do this as I've not deployed to 2003 before. My application (VB6) will deploy fine to XP on several PC but I need it on the server to enable Citrix access accross our network. Uses Access 2000, Excel 97 and data environment references with Jet 4.0 OLE and DataControl and MSH...

Thanks xlhelp, You're probably correct. However, we do not wish to disable anti virus software due to the risks involved. The problem is now affecting several users so the decision has been taken to upgrade (and hope the problem has then been bypassed!) Thanks for your help

We are experiencing the problem as descibed in the Microsoft article. There appears to be a fix for the problem but it is no longer available from Microsoft, so I'm told. Does any body have it so that we can apply to systems still running Excel 97. -There are technical reasons why we do not...

Thanks all, Pity about the lack of debugging for functions but your advice has worked.

Thanks guys, sensible suggestions, thats fixed it. Lack of experience assunmed varchar is like a variable length string in VB/VBA but obviously not a a similar function returning just two characters had been OK, but thats now been explicitly declared. Are there any good debugging tools out...

Apologies for such a basic question but I'm right at the bottom of the learnuing curve... If I creat a user function to return a varchar representing thre financial year (eg. "2006/2007") from a passed in parameter (date column from a record) how can I debug to find where the function is...

Don't know the answer but does the cross-unctional lowchart wizard appear after dropping?

I have at least two databases (SQL and Access'97) and I'm trying to define a model to map the changes required to enable the new source tables to be used when the Access tables are replaced by (similar) SQL tables and Views. i.e. a diagram that will show similarities/differences and and have...

With Outlook 2003 is it possible to automatically print an attachment to the default printer (assuming the attachment's application is on the recipient pc), possibly via a rule or a bit of code?. The attachments most probably will be an excel or word document with no macros/code attached and...

Thanks Steve. Will try your suggestions.

In access 2000 running a query to make a table in another database (access 97) intermittantly fails to run to completion and hangs. Both dbs are in the same folder on a drive. Any clues as to why? Could it be a compatability issue? TIA Alex

Thanks PH, That worked a treat! Alex

A small program to monitor links between two databases ans stores status results in a table. Works fine as code from within Access 97. When I try to run the code after opening the database as an access application object an error message that the action was cancelled by the user appears "Run...

Thanks Leslie Useful wee site!

There are several threads with content on a simlar theme of how to increase performance, Does anyone have any ground rules or guidance? Such question as the following might arise: It is presumable quicker generally to work on a PC's hard drive than work accross a network with the same PC? Is...