Andy Lacey
andy at minstersystems.co.uk
Sun Apr 13 10:42:15 CDT 2003
No, still get a syntax error. And I don't think pass-through queries are an option when you're updating a linked MDB, are they? Andy Lacey http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: 13 April 2003 16:18 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Alter Table Oh wait. It's an A97 problem. Works in A2K but not A97, which is pretty much all I use, so that's my excuse for my ignorance. Well, Tracy, hopefully Susan's solved it for you. As for BEU, mmmmm........... ============It should work in 97 too, you may just need a different VBA route -- try it via the SQL window. Susan H. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030413/58f870de/attachment-0001.html>