Query Import Problem

  • Thread starter Thread starter Scott Duncan
  • Start date Start date
S

Scott Duncan

When we import a Access XP Query into 2003 the Join Properties are missing
and the Field Names
go to Expr1: [Field Name].

Any thoughts ?

TIA,

SD
 
How are you importing it, using the File|Get External Data option? If so, do
the tables and field listed in the query exist (with the same spelling) in
the database that it is being imported into?
 
Wayne,

Yes, I am using the File|Get External Data.

And yes again. The Tables are linked and everything is the same.

The reason that I am doing this is the File Size bloats up so much that I
can not Compact & Repair back down to it's original size.
We are seeing bloat up to 50%. I don't know why it bloats so much, but this
is how we have solved this for years (going back to Office 97).

Thanks,

SD

Wayne Morgan said:
How are you importing it, using the File|Get External Data option? If so, do
the tables and field listed in the query exist (with the same spelling) in
the database that it is being imported into?

--
Wayne Morgan
Microsoft Access MVP


Scott Duncan said:
When we import a Access XP Query into 2003 the Join Properties are missing
and the Field Names
go to Expr1: [Field Name].

Any thoughts ?

TIA,

SD
Click to expand...
Click to expand...
 
Since you are simply importing a stored query then what you mention
shouldn't happen unless there is a typo (including and spaces) in a table or
field name between the two databases. What is imported is the SQL text of
the query and if it finds the table and field names in the new database, it
doesn't know the difference.

Bloat of that much would usually be a lot of writing to temporary tables.
Have you split your database into a front-end and back-end? Also, there may
be something corrupted. Here are some articles that may be of interest to
you.

http://members.iinet.net.au/~allenbrowne/ser-01.html
http://www.granite.ab.ca/access/splitapp/index.htm
http://members.iinet.net.au/~allenbrowne/ser-25.html
http://members.iinet.net.au/~allenbrowne/ser-47.html
http://www.granite.ab.ca/access/bloatfe.htm
 
Back
Top