Wrox Programmer Forums
|
BOOK: Professional Visual Studio 2008 ISBN: 978-0-470-22988-0
This is the forum to discuss the Wrox book Professional Visual Studio 2008 by Nick Randolph, David Gardner; ISBN: 9780470229880
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Visual Studio 2008 ISBN: 978-0-470-22988-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 14th, 2009, 12:37 PM
Registered User
 
Join Date: Aug 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Issues with Dataset Designer and Access

My database is still in flucts... It's still changing as we're still designing the entire process/product. I'm restricted to using MS Access.
THE PROBLEM:
Whenever I change the underlying database structure, say add a field, or change it's properties(from a string to a date/time)... Then I try to activate that change in my dataset-designer window... It doesn't work.

I changed three tables in Access: two, I selected a 'primary-key', a third one I changed field properties. Then I open VS8, removed the tables from the designer window and tried to drag/drop them back from the server-explorer.

It gives me an error code of -1 and nothing else... nada... no more info.

When I tried to view one of my forms, it had an error, since I hada a datagrid tied to one of the tables I changed. The only way I could view it was to comment to form-designer code to eliminate the datagrid. Now I have to re-do two hours of work because the datagrid isn't there anymore... because I deleted the table and "can't" copy in a version....

I desperately need some help! I don't want to have to 'rebuild' a form/and-of-the-underliying-code everytime I need to make a change to my database description. The 'refresh' button... doesn't do anything. I have to 'modify' the connection and then 'drag/drop' a table onto the designer window... then it does something, but then I have an extra table definition, as well as broken links between forms and database....

This keeps happening whenever I have to change the underlying database....

There's has got to be a better way... or at least some kind of definite 'process'... some series of steps to follow to do this and not have it break it's links....


Very Frustrated!(rcloud)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 24: Description of DataSet Designer ali.net BOOK: Professional C#, 2nd and 3rd Editions 0 October 18th, 2008 07:08 PM
DataColumn.Expression problem in Dataset designer shalan Pro Visual Basic 2005 2 October 5th, 2007 06:28 PM
Dataset Designer Question chrislepingwell ADO.NET 0 August 31st, 2006 06:27 AM
Re: SQL Server dataset to ACCESS dataset dazzer ADO.NET 0 March 22nd, 2004 05:28 AM
Access vs. SQL query Designer Mitch Access 7 October 14th, 2003 04:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.