Exporting Database file from my Friend's PC

[Levistus]

I made a program for my friend, a patient database program using VS 2010. I'm worried if my program messes up she loses all the records.

Here's what I remembered doing. Maybe you guys can identify how I can fix this or you can give ideas on how to avoid the same mistake.
1. I used Visual Studio
2. I made a VB Windows Forms Application
3. I made a Service-Based Database called Database1.mdf which is a Dataset Model
4. I chose save connection string to Database1ConnectionString
5. Dataset name is Database1Dataset
6. I added a table to the database and put stuff in the Columns and data types.
7. I then added it to the Data Source.
8. I then dragged from the Data Source, each column to the forms so they have a Label: Textbox
9. Then dragged again to get a datagrid view.
10. Edited the forms to have better looking add, new, save, previous, next buttons and added a simple search using filter.
11. Then I published it to my computer. After testing, I archived it then sent to my friend.
12. She installed it and is now using it.

She was glad with how simple it was cause I made it with Visual Studio. Now I dunno how to export the database file from her computer/copy of program to make a backup. I dunno what to do.
I know I didn't ask for anything in return but if the program messes up I'd feel bad. 1k+ records already jesus christ and the program has like 74 columns/textboxes. Someone help please.

BTW the DataBindingSource is the thing that connects the textbox to the database.

EDIT:

OMG she says she's just going to add all the records for this year and tells me it could reach 15k or more records total this July. Holy **** I'm just a newbie programmer what the hell did I get myself into. I just copied stuff from youtube so I can make her a program.

Someone please help me with making a new program(if needed). With that amount of records, what database should I use? The important thing is it's easy to use like how I made it with Visual Studio. Or am I panicking too much and 15k records is nothing?

I don't mind re-creating the program.

[Barrabutus]

I,ll try to help you, Bear in mind im quite new tho like yourself

I dont think 15k records is a great deal so i would probably suspect you will be ok with a Access Database , As for the dataset i cant really help there because i tend not to use them and use SQL a lot myself.

As for copying the File to your computer she could either just email the MDB File or you may have to look into using a webservice and file methods for sending the file to your IP address , Sorry i cant help too much with the actual code for this as i have never attempted this but this is just my thoughts on how i would try to achieve the sending of the database file

Regards Barra.

[Levistus]

I,ll try to help you, Bear in mind im quite new tho like yourself

I dont think 15k records is a great deal so i would probably suspect you will be ok with a Access Database , As for the dataset i cant really help there because i tend not to use them and use SQL a lot myself.

As for copying the File to your computer she could either just email the MDB File or you may have to look into using a webservice and file methods for sending the file to your IP address , Sorry i cant help too much with the actual code for this as i have never attempted this but this is just my thoughts on how i would try to achieve the sending of the database file

Regards Barra.

With the way I made the program, can you tell me how I can export the database on my friend's copy? I think the file database is embedded.

[Barrabutus]

As for the embedding of the Access DB im not sure if that just means that its "Packaged" with the application or actually placed inside the program (Out of sight) , Maybe one of the more experienced people could answer this.

If its packaged then it will reside inside a folder where your app is installed by the user, Then you could use this path to get the file


Consider the following steps :
1: Where am i sending this File ?
2: Where is this file located?

I also found this post which may be useful

Sending Files from one computer to another

Regards Barra