Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mackers2

  1. mackers2

    three dimensional array

    are you making an array in vbscript: Dim myarray = someFunctionToGetValueFromDataBase and then trying to access the array in Javascript? can you do that? vbscript arrays are simply referenced by the notation myarray(x,y,z) Can you get out anything from the array at all? Can you find its ubound?
  2. mackers2

    80004005 unspecified error suddenly stops page working

    ok, fixed now: tracked down what was going wrong (all the Access databases being used on the whole intranet were down) by changing from OLEDB to ODBC driver which then errored with message about Volatile Jet DSN ... MS KB indicated this was permission problem with the Jet driver on the web...
  3. mackers2

    80004005 unspecified error suddenly stops page working

    Reset the permissions now and the funny thing now is that the pages run fine for the webmaster but when an ordinary user tries to use it they have the same error. Alasdair
  4. mackers2

    80004005 unspecified error suddenly stops page working

    thanks, DreXor, any joy and I'll post Alasdair
  5. mackers2

    80004005 unspecified error suddenly stops page working

    Thanks, do you know where I should start looking - there are at least three different databases, some stored on web server, one on other servers, but they've all stopped working. I know the account asp pages are using to access the databases is OK to read/write the database folders as I tested...
  6. mackers2

    80004005 unspecified error suddenly stops page working

    <% Set LocADO = Server.CreateObject ("ADODB.Connection") LocADO.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\pharm-svr\Train\dispdata.237\wait2.mdb" Crashes out on line beginning LocADO above (according to browser). This is just an example of one page; all the other pages on the...
  7. mackers2

    80004005 unspecified error suddenly stops page working

    I've got some asp pages connecting to MS Access databases (some are Access 2000, some are Access 2). Suddenly this afternoon I've got 80004005 errors on all pages that try to get data from an Access database. Anybody any ideas why this would happen suddenly - I've not lost RW access to the...
  8. mackers2

    How can I test to see if a web page exists?

    Sub Macro4() ' ' Macro4 Macro ' Macro recorded 05/02/2003 by AMacdonald ' Dim sTemp sTemp = GetStatus(&quot;http://www.tek-tips.com/submitpost.cfm&quot;) If InStr(sTemp, &quot;404&quot;) > 0 Then sTemp = sTemp & vbCr & &quot; - this means the file was not found&quot; End If MsgBox sTemp End...
  9. mackers2

    Sending Outlook Mail from Access

    I got round it with this: http://www.express-soft.com/mailmate/clickyes.html Regards Alasdair
  10. mackers2

    Automating WinFax Pro in VBA

    I added .AddAttachmentFile to your code and it worked fine for me, the only thing is that WinFax takes a while to load the attachment files application and then print it to Winfax so you wait a while to see the pages appear. Regards Alasdair
  11. mackers2

    Front Page Programming Help is broken

    When I access Front Page (2002) Programming help I get an error saying &quot;A runtime error has occurred&quot;. In script editor it reports that ADODB.Recordset: Operation is not allowed when object is closed. I've uninstalled, reinstalled etc etc. Any ideas how to fix?
  12. mackers2

    Securing a pdf file

    I don't know if this is helpful - but what I've done to stop people using a printed version when I don't want them to is to put a form field on the document that has some text on - I use &quot;Invalid Form - Do Not Use&quot; that goes right across the whole page. I set the field to invisible...
  13. mackers2

    Output directly to Excel..?

    this works for my test data with commas in, of course you'll have problems with multiple &quot; in your fields then... if you find out how to get Excel to open it instead of inside the browser I'd love to know. Response.Write &quot;&quot;&quot;&quot; & myRS.Fields(i) &...
  14. mackers2

    Output directly to Excel..?

    This is the code I use - key point is to take out of your page any html tags like <html> <body> as then Excel thinks it's an html file not a csv file. This isn't my code - I got it from www.devx.com - Got Data? Send It to Your Users as an Excel Spreadsheet from Your ASP Page By Rama Ramachandran...
  15. mackers2

    MailMerge DDE connection

    This has bugged me as well, and what I did was separate out the data for the merge into a different database and then used that database as the source for the mailmerge document, but using ODBC. This works fine - Access never opens and the Word document closes clean, and feels much faster. Not...

Part and Inventory Search

Back
Top