I have a database that uses several Union queries. I transformed it into a Design Master and now I'm getting errors when I try to open. The error states I'm using invalid field types in the SELECT statement. I assume the Replication fields are causing the trouble. Is there a way around this?
Replication and Union Queries
- Thread starter BradWare
- Start date
Union queries should work, the only thing I can think of is your are using "Select * ... " for your query and after converting to a replica database the replication ID fields are causing trouble.
Try to specify the fields you're needing for your queries instead of using select *.
Try to specify the fields you're needing for your queries instead of using select *.
dfenton
AWF VIP
- Local time
- Today, 14:04
- Joined
- May 22, 2007
- Messages
- 469
Your application should be split into front end and back end, with only tables in the back end. And only back ends should be replicated, because Jet Replication simply doesn't work well over the long term with front end objects.
True, queries are pure Jet objects, but queries belong in the front end, so your problem would not exist if you split your application and replicated only the back end.
That said, my guess is that this is aproblem with Name AutoCorrect, which should be turned off in all databases, because it's one of the buggiest features ever introduced in Access.
--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/
True, queries are pure Jet objects, but queries belong in the front end, so your problem would not exist if you split your application and replicated only the back end.
That said, my guess is that this is aproblem with Name AutoCorrect, which should be turned off in all databases, because it's one of the buggiest features ever introduced in Access.
--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/
Similar threads
