Access loses my tables - how?

[furries]

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 so frustrated

Thanks in advance

 

[KenHigg]

Have you tried importing all the objects to a new .mdb?

kh

 

[The Stoat]

Hi,

I've had similar problems with forms and the reason was the database had become corrupted. Ken is right when he suggests you should try to import your database objects into a new db.

TS

 

[furries]

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

I've attached a screen dump showing that when I try to copy a tabledef to the name Jeffjob I get the error message 'The name you enterered ...' ( you might need to zoom in to read the screen image!)

Thanks for your help

 

[furries]

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

 

[KenHigg]

This is a little off topic, but is there a leading space in the name? ie " Jeffjob"


???
kh

 

[furries]

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?

 

[KenHigg]

Can you get enough into a seperate mdb to post?

(I don't think I can come up with a solution, I'm just curious to see it.)

kh

 

[furries]

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)

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 equivalent to

Set tdfTo = dbsTo.CreateTableDef(cmbJobName, 1)

and you get the symptoms described above.



Set tdfTo = dbsTo.CreateTableDef(cmbJobName, dbOpenDynaset)

is equivalent to

Set tdfTo = dbsTo.CreateTableDef(cmbJobName, 2)

and the table is visible but is a system table



Finally

Set tdfTo = dbsTo.CreateTableDef(cmbJobName)

Creates the table and can be manipulated perfectly in Access. Problem solved!

Would life be easier without M$ Access?

 

[furries]

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

 

[KenHigg]

Didn't get your file...

kh

 

[furries]

Sorry

Attachment attached (I hope)