Thankyou all for your posts. I will sleep further on your comments and will no doubt find myself in the local library more often, to read up on all you have mentioned. G'Night all.

John C, thankyou for your comment. I can appreciate where you are coming from. I wholly agree that the financial aspect is a big commitment but so far i am trying to apply my slight knowledge to a big idea. I have thought about paying for consultant time to get the prototype fully functional prior to launching the sale of the software as 'my company' but due to my inability to read/learn and code at a fast pace I am resorting to the 'group' investment approach. i.e idea,coding skills to launch the 'concept'

apologies, 5) I have a .net prototype, in my pigeon .net language. hence question.

1. 8 months in the devise of the solution 2) Upgrade to exisitning in house applications 3) saleable commodity in todays uk environment 4) Where to look for investors? so that i retain the identitiy of my idea and provide for my fmily etc etc I have slept, and i have woken, and i have trembled in sweat at the hairy spider!

Probablt not the right place, but. How does one go about setting up a business in software. I have an idea (oh no not another pipe dream i hear u say) and am looking for a best fit solution. I am trying to migrate from access to .net in this advancing world, for a robust solution that would sell uk wide but it doesn't seem quick enough to get the solution out there, with my reading and forums and and and. Pointers would help, investors also. Time wise to start. would be happy to pm to discuss. boot this to another forum if appropraite.

Before i tear my thinning hair out, is it possible to launch an app by having a splash screen and then login form show, and if the login is correct then close this down and launch the main app as MdiParent with Children forms as user input, I am presuming this will allow me to catch if a path to the database is ok before launching the main app. (At the moment i am opening the MdiParent and hiding it, then displaying the splash and then logon. It doesn't look pretty.)

The reason i care :P is that when you try to delete the newly created record it uses the id as its Id into the back end (Db), there is no match so i get an error every time. so 79 in the dataset is actually say 77 in the Access db (Autonumber). In an ideal world this wouldn't happen however.. BTW yes i am new (trying to self teach) but am aware that an id is just that, a record placer.

I amhaving problems with my db connection. In a form connected to the db through a table adaptor if i restore using CancelEdit, and then add new again the dataset retains the next sequential autonumber. i.e addnew id is 79, restore, addnew id is 80, when no 79 was actually created in the access db. I have tried restore etc to no avail. How can i reset the dataset to match the current autonumbers in the db. Thanks

Hi, hoping you can help. I am trying to add a restore button to the toolstrip on a form. How can i tell if the table adaptor or binding source row data has changed to enable the restore/do you want to save procedure i have set up. Thanks

Hi, I am using the bindingnavigator delete to delete a record from an access db table using visual studio defaults. The record will delete from the db but when the form and bindingnavigator refreshes it deletes the record then refreshes to the bound data set minus the last record. eg records 1 of 3, delete record 3, form now shows 1 of 1. I have set up another button to list data in dataset and it shows the two remaining records. How do i get the form to show the correct number of records? Thanks.