access 2 vs

[katabullet]

hi, can anyone please help me explain how i can import database files from ms access to visual studio?
i am really in need of it, will really appreciate help
thanks

 

[Galaxiom]

You cannot import database files to Visual Studio.

Access files are capable of building forms, running code and storing tables. The applications built in Visual Studio only build forms and run code. Databases such as Access or SQL Server are connected to from the applications using code.

If you are hoping to import your Access projects into Visual Studio and have them converted to VB.NET applications then I am sorry that I am going to disappoint you. It is pretty much a start again scenario to rebuild the app in Visual Studio and it is a much bigger more complex task.

 

[katabullet]

oh, ok thanks allot MR, i appreciate ur respond.

but how can i connect my database to visual studio with code? is by creating a form?

 

[Galaxiom]

A VB.NET application in Visual Studio is complex. All the forms are unbound. Data is put into them and read back out by using code.

There are a number of ways to connect to a database from a VB.NET application including an elaborate module dedicated to the purpose.

Anotherway it can be done using recordsets opened against the tables. The recordset variable holds the data and code is used to write back and forwards between the recordsets and the controls on the forms.

 

[katabullet]

ok, i am really a beginner here .please enlightened me on how its gonna turn out.

will it operate as a one software (standalone file) or separately,

talking about exe

 

[Galaxiom]

There will be two files. The exe file which displays the forms and runs the code. The Access file which holds the data.

The exe is the front end and the database file is the back end.

 

[katabullet]

wow, great!
i should really try this via walk through guides