Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old September 14th, 2009, 12:37 PM
Registered User
 
Join Date: Aug 2009
Location: Oklahoma, USA
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)
__________________
If all you have is a hammer, then everything looks like a nail.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04:28 AM
Access vs. SQL query Designer Mitch Access 7 October 14th, 2003 04:25 PM



All times are GMT -4. The time now is 10:31 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.