Access Database Files

[supersniper]

So i'm currently trying to create an application that can save a dataset into a .mdb database file type, which can then be either read, edited, manipulated, searched and uploaded to a website.

I'm currently searching google for a nice tutorial but haven't found one yet. If anyone knows anything about this, or has a tut that I can be directed to I'd really appreciate it.

thanks in advance

supersniper.

[Skyline]

What language?

[Patrickssj6]

What database?

[supersniper]

Language is C#
Database is a MySQL

[Limited]

http://www.dscripts.net/2009/01/20/connect-to-microsoft-access-mdb-database-using-csharp/

Might be of some use.

[supersniper]

alright i have it all set up, to connect etc.
I have created the actual .mdb file

the only problem how do i get the app to take the data it gathers and write it into the .mdb file then save it.

[Limited]

alright i have it all set up, to connect etc.
I have created the actual .mdb file

the only problem how do i get the app to take the data it gathers and write it into the .mdb file then save it.
Well you will need to look at the structure of the mdb file and also the sql structure. Practice writing random data to a mdb file first, might require some API calls to write I dunno.

You do realise, you've basically asked us how to make the whole app.

[Skyline]

Well if your goal is to ultimately upload the data to a website, why don't you create a xml or json file of the data. It might be difficult uploading an Access database to a website than finding a way to transfer all the information, maybe use a local mysql database instead? After you got a connection to the access database you need to use sql statements to manipulate information.

http://msdn.microsoft.com/en-us/library/bb259186(v=office.12).aspx

[supersniper]

i just want a tutorial that I can follow or some basics because i've been googling this shit and nothing has been helpful at all.

but i'll take a look into those skyline

[Limited]

i just want a tutorial that I can follow or some basics because i've been googling this shit and nothing has been helpful at all.

but i'll take a look into those skyline
I doubt theres a tutorial that will tell you how to do exactly what you want to do. You will need research it, understand what concepts in coding you need to use to accomplish it and then you need to figure out how to attach those bits together to have a working app.

3 steps
1, read the data from the current file.
2, parse the data
3, export to mdb file.

[Skyline]

Here's an example I made using the tutorial limited linked to.

http://pastebin.com/k9xMJWyQ

(http://pastebin.com/k9xMJWyQ)There isn't much to it. You basically call a function with a string telling the database what to do.

[JohnDempsey]

AccessRecovery (http://www.recoverytoolbox.com/access.html) is able to work with corrupted and deleted ms access files after viruses, hdd failures, system errors. The software can work under any system configuration.