Search results

Sorry Attachment attached (I hope)

Hi Ken I've attached the mdb with the hidden table (jeffjob) Just try to add a new table and try to call it jeffjob and you'll see what I mean From my point of view I've solved the problem now - this is just a curiosity :)

Thanks for your help guys but I've solved the problem (and another that had bothered me for weeks but I put up with it) :D The problem was the way that I opened the tabledef in VB (I used the OpenRecordset syntax so ...) Set tdfTo = dbsTo.CreateTableDef(cmbJobName, dbOpenTable) is...

No Ken No leading spaces - the creation of the (invisible) tabledef is done in VB and I've checked - no spaces get into it Wierd huh?

Thanks Stoat I missed your response while I was replying to Ken I understand now what was meant: I have created a new .mdb copied the existing 'good' tables to it Tried my copy routine (in VB) But it still has the same problem

Hi Ken Thanks for the response I'm not able to see the objects in the existing table, so when I try to import into a new .mdb it does not appear in the list of tables :confused: I've attached a screen dump showing that when I try to copy a tabledef to the name Jeffjob I get the error...

How can it be that I have a table that cannot see in the database container? It's there because Access will not let me copy a table to that name. On the other hand I can't use thst table in queries etc. It's not hidden and not a system table Please, one of you gurus help me with this - I'm...

Hi I'm using VB6 & Access 97 I want to create tables by copying from an existing table using VB My code works, but I cannot see the table in Access (it is not hidden or a system table) I know that the table exists because I can use it in VB and, in Access, if I try to copy a table to the...