Re: problem with unique file extensions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Unicorn (unicorn_at_somewhere.com)
Date: 06/20/04

  • Next message: Douglas J. Steele: "Re: problem with unique file extensions" 
    Date: Sun, 20 Jun 2004 23:34:55 +0930

    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23IVL0QaTEHA.320@TK2MSFTNGP10.phx.gbl...
    > See whether the information in the following KB articles help:
    >
    > http://support.microsoft.com/?id=245407
    > http://support.microsoft.com/?id=306144
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    Curiosity is a terrible thing, can anyone tell me why DAT files represent a
    security risk that would see then disabled? (As mentioned in the Microsoft
    article http://support.microsoft.com/?id=245407)

    >
    > "Rachael" <anonymous@discussions.microsoft.com> wrote in message
    > news:69B24FA0-5163-4992-9688-F5676B5F5A23@microsoft.com...
    > > I use a technique that attaches or links some text files to my database.
    > It creates a schema.ini file in the original location folder where those
    > original text files are stored.
    > >
    > > If the files are properly attached, (when the program works correctly)
    you
    > can open my database, (which is in its own file folder/location) and see
    the
    > several files which are attached to my database. The original location of
    > those text files are in another folder, updated by a separate program,
    > unrelated to my program. All my program does is place a schema.ini file in
    > their folder.
    > >
    > > Each time those text files are updated by that other program, (daily)
    the
    > files I've attached to my database are also updated in my database.
    > >
    > > My program each day then moves the data, (as I use the term *import*)
    from
    > those *attached tables*, (not from the original location) into my database
    > by using an insert statement:
    > >
    > > db.Execute "Insert Into ...."
    > >
    > > I cannot get past the part of my code where I *add* certain files to my
    > database however since the windows jet program changed to exclude certain
    > extensions. The program still works fine with .csv, txt., etc., but not
    with
    > unique extensions. When I broke, to see where the code was failing, it was
    > at the procedure below:
    > > ------------------------- code from program:----------------
    > >
    > > Function AddTextTable(TableName) As Boolean
    > > On Error GoTo BadAddTextTable
    > > '=======================================
    > > '
    > > AddTextTable = True
    > > Dim MyTD As TableDef
    > > 'attach the text table
    > >
    > > Screen.MousePointer = vbHourglass
    > > If TableName Like "*.*" Then
    > > Set MyTD = db.CreateTableDef(Left(TableName, Len(TableName) - 4))
    > > Else
    > > Set MyTD = db.CreateTableDef(Left(TableName, Len(TableName) - 0))
    > > End If
    > > MyTD.Connect = "TEXT;DATABASE=" & File1.Path & "/;"
    > > MyTD.SourceTableName = TableName
    > > db.TableDefs.Append MyTD
    > >
    > > '=======================================
    > > ExitAddTextTable:
    > > 'exit code here
    > >
    > > Screen.MousePointer = vbDefault
    > > Exit Function
    > > BadAddTextTable:
    > > MsgBox Err.Description, vbCritical, "AddTextTable"
    > >
    > > AddTextTable = False
    > > Resume ExitAddTextTable
    > > End Function
    > > '-----------------------end
    > >
    > >
    >
    >

  • Next message: Douglas J. Steele: "Re: problem with unique file extensions"

    Relevant Pages

    • RE: Troubleshooting Errors with Access 2003 Database
      ... All users have the same priviledges on the folder. ... Jerry Whittle, Microsoft Access MVP ... access the database tables. ...
      (microsoft.public.access.gettingstarted)
    • Re: folder security nightmare to allow .ldb file deletion
      ... I thought the file would inherit permissions from the folder? ... Depending on the user permissions, MichKa has a solution to that issue at ... Doug Steele, Microsoft Access MVP ... "If you plan to share a database, the .mdb file should be located in a ...
      (microsoft.public.access.security)
    • Re: Current folder
      ... Doug Steele, Microsoft Access MVP ... same folder where database is. ...
      (microsoft.public.access.modulesdaovba)
    • Re: folder security nightmare to allow .ldb file deletion
      ... We removed the "delete" privelege from the folder. ... We have another database linked to just one of the tables of the shared ... Doug Steele, Microsoft Access MVP ... Depending on the user permissions, MichKa has a solution to that issue at ...
      (microsoft.public.access.security)
    • Re: PLS HELP: Shared use of Access 2003 database
      ... Microsoft Access MVP ... I have shared the folder on those PC in which is this mdb and give ... read-only mode ONLY when a user on which PC is a database keeps this ... In Access on PC where mdb is stored, i have checked Tools-Options, ...
      (microsoft.public.access.security)