View Single Post
  #2  
Old January 16th, 2010, 03:55 PM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Linked table shows up as "~TMPCL###.." in Front end db

This is typically a table set for deletion. Try a compact/repair before the
split.

If it still exits after that, create a new (blank) database, and import all
your objects. Then split this new database.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"DaveD" wrote in message
...
I have a split database in Access 2007. When I use one of the tables in a
form, the table shows up with the name like "~TMPCL####.." when I view the
properties box. THis does not happen with any other tables. Does anyone
know
why?
Thanks,

Dave