Hi Garry Not sure, The data is the backend to an ASP website so I'm trying to copy the data so I can install the updates which consists of loads of new fields.
Have been playing around with remote views all day but can't get them to update the mdb even though I have a primary key set. Will have a play. Cheers -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Garry Bettle Sent: 29 December 2006 15:53 To: profox@leafe.com Subject: Re: CABuilder for Access databases (Graham Brown (CompSYS)) On 12/29/06, "Graham Brown \(CompSYS\)" wrote: > Hi all > > Hope everyone had a great xmas! > > Does anyone know of any tools which will build ca's for tables in an Access > MDB. > I need to do a one off data merge between two access databases. > > The CABuilder tool supports VFP, SQL and Oracle. but not access. > > Thanks all > > Graham Brown > CompSYS Software Solutions Hi Graham, Could you get away with something like the following and then use CABuilder?: Getting Data from Microsoft Access in VFP: http://www.utmag.com/wconnect/wc.dll?LevelExtreme~9,7,10,1295 or How to import table structures and data from Microsoft Access to Visual FoxPro: http://support.microsoft.com/kb/260405 or MDBtoDBC Conversion Utility: http://www.inspironix.com/mdbtodbc.htm Cheers, Garry Bettle MCP, Security+, MCTS SQL 2005 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.