[AccessD] RE: Access 2002 - Another Annoyance

Why don't you put a blank temp table with the appropriate fields in a blank
database and then import it all?

Debbie

-----Original Message-----
From: dmcafee at pacbell.net [mailto:dmcafee at pacbell.net] 
Sent: Friday, May 27, 2005 11:23 AM
To: Access Developers discussion and problem solving;
ACCESS-L at PEACH.EASE.LSOFT.COM
Subject: [AccessD] RE: Access 2002 - Another Annoyance


I hate it when Access tries to be "too smart" for its own good. I'm sure the
MS programmers were trying to validate something (with good intentions). I
hate it when they do that, just like when trying to import an Excel file
with numbers in a column, but you really want to import that column as text.
Access wont let you :|

David

-----Original Message-----
From: Heenan, Lambert

X-posted to Access-L and Access-D

Here's another little gotcha about Access 2002 that you might want to know
about.

I'm sure many  people are aware that when you suspect that the mdb has
become corrupted that a way out of the problem is to create a new blank
database and then import all of the objects in the problem database into the
new one. That often fixes the issue, and leaves you with a nice 'clean' mdb
to play with.

Well I just tried to do that and hit a problem. I have some saved queries in
the mdb which reference a temporary table that only exists after some code
is executed. During the import process Access complained that it could not
find the table and the only buttons I had were 'Ok' and 'Help', so I just
wound up in an infinite loop of complaints about the missing table. The end
result being that it was impossible for me to import all my objects, unless
I excluded those specific queries.  Fun and games! :-(

Lambert

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.