tags:

views:

66

answers:

1
+1  Q: 

Access 2003/2007 Query contents wiped

Has anyone else come across a situation where the contents (SQL statement) of an Access 2003 or 2007 was completely wiped (the Query object still exists, the inner SQL does not)?

Does anyone know what causes this?

I've just had this happen to me again. 2 queries run from a Macro's OutputTo actions to generate 2 Excel files. I ran the Macro a few times then suddenly no more SQL statement in both Queries.

A: 

No, I've never seen this happen. And I've read pretty much all the postings in the Usenet and Microsoft newsgroups mentioning corruption for the last ten years or more.

But I'm wondering. Do multiple users share this MDB? We've had a few bizarre postings with respect to Access 2007 losing VBA code.

Tony Toews  2009-06-03 06:20:53
In both cases it was a single user database running on a local hard-drive (network not an issue).I haven't had any issues losing VBA code though.
Jason Snelders  2009-06-09 04:29:00

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?