Hi

I'm creating some tables using the following code, but for some reason when I view the tables in Access they appear as System tables (the table names do not start MSys or USys). Any Ideas?

Thanks

Code foillows:


    'Batch Table ************************************************** *************
    Set rstFieldDefs = dbsJobs.OpenRecordset(frmInitialise.txtJobName, dbOpenDynaset)
    Set tdfBatchTable = dbsBatch.CreateTableDef(strBatchTableName, dbOpenDynaset)
    ' Create batch if doesn't exist.
    On Error Resume Next
    Set rstBatch = dbsBatch.OpenRecordset(strBatchTableName, dbOpenDynaset)
    If Err.Number = 3078 Then
        'Create Field Definitions
        rstFieldDefs.MoveFirst
        With tdfBatchTable
            Do Until rstFieldDefs.EOF
                Set fldTemp = .CreateField(rstFieldDefs.Fields("Field Name"), dbText)
                fldTemp.AllowZeroLength = True
                .Fields.Append fldTemp
                rstFieldDefs.MoveNext
            Loop
        End With
        dbsBatch.TableDefs.Append tdfBatchTable
        Set rstBatch = dbsBatch.OpenRecordset(strBatchTableName, dbOpenDynaset)
    End If

Thanks
Psionmane

__________________
Thanks
Psionman

hi there...

from MSDN


Set tabledef = database.CreateTableDef (name, attributes, source, connect)

The CreateTableDef method syntax has these parts.

Part Description
tabledef An object variable that represents the TableDef object you want to create.
database An object variable that represents the Database object you want to use to create the new TableDef object.
name Optional. A Variant (String subtype) that uniquely names the new TableDef object. See the Name property for details on valid TableDef names.
attributes Optional. A constant or combination of constants that indicates one or more characteristics of the new TableDef object. See the Attributes property for more information.
source Optional. A Variant (String subtype) containing the name of a table in an external database that is the original source of the data. The source string becomes the SourceTableName property setting of the new TableDef object.
connect Optional. A Variant (String subtype) containing information about the source of an open database, a database used in a pass-through query, or a linked table. See the Connect property for more information about valid connection strings.


also attributes has this constanst...


For a TableDef object, the value specifies characteristics of the table represented by the TableDef object and can be a combination of these Long constants.

Constant Description
dbAttachExclusive For databases that use the Microsoft Jet database engine, the table is a linked table opened for exclusive use. You can set this constant on an appended TableDef object for a local table, but not on a remote table.
dbAttachSavePWD For databases that use the Microsoft Jet database engine, the user ID and password for the remotely linked table are saved with the connection information. You can set this constant on an appended TableDef object for a remote table, but not on a local table.
dbSystemObject The table is a system table provided by the Microsoft Jet database engine. You can set this constant on an appended TableDef object.
dbHiddenObject The table is a hidden table provided by the Microsoft Jet database engine. You can set this constant on an appended TableDef object.
dbAttachedTable The table is a linked table from a non-ODBC data source such as a Microsoft Jet or Paradox database (read-only).
dbAttachedODBC The table is a linked table from an ODBC data source, such as Microsoft SQL Server (read-only).


i bet that dbopendynaset has the same value or includes the value of a system table... ;)




HTH

Gonzalo

Muchas gracias Gonzalo, pero todavia hay problemas:

I've not been able to find much about system objects on MSDN - just that you create them by naming them 'USys....'

As far as I can see there are no options you can set that creates system objects

The code used to work and to create normal tables: but something somewhere (maybe not in this fragment) changed and now they are system objects :( ... maybe the way the database is opened (?)






Thanks
Psionman

De nada :)

did you try change dbopendynaset for another constant??
try to create it with no swichts...

HTH

Gonzalo