Search : in
By :

Pls help......VB 2008 + Microsoft Access 2007

Last answer on Oct 20, 2009 5:03:32 am BST Thanya, on Mar 11, 2009 6:10:34 am GMT 
 Report this message to moderators

Hello,

can VB 2008 connect to Access 2007 or do i have to change the format of my dbase?

i tried to run my project w/o changing but it says couldnt find my dbase...

Pls help

thnks


Tanya

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Pls help......VB 2008 + Microsoft Access 2007 » in :
Print Relationships in Access ShowPrint Relationships in Access Issue Solution Issue How easily print graphs of relationships in Access? Solution To print the relationships in Access 2007, you must go in the Database Tools Tab/ Relationship / Relationship Report
ACCESS-Restoring default menu ShowACCESS-Restoring default menu Intro Solution Explanation Restoring the start up of an Access database Intro Here you should find out how to restorehe default menu and window management of the database from Access (assuming that...
[Vista] Take control over a file whose access is denied Show[Vista] Take control over a file whose access is denied Most Vista users have encounter the following type of message: "Access denied" when trying to edit some files or folder. To solve this problem: Right click the folder...
Download Outlook Connector ShowConnector Microsoft Outlook allows to use Outlook 2003 or Outlook 2007 to access and manage freely your Windows Live Hotmail or Live Mail accounts, especially the contacts. Depending on the services, the calendar task synchronization and the notes...
Download Visual Basic Express Edition Show
Download Classic Style Menus for Word 2007 ShowClassic Style Menus for Word 2007 is an add-in of Microsoft Word which has been designed to allow you to use several features of Microsoft Word 2003 on Microsoft Word 2007. With this program, you can have access to different menus of MS 2003...
ODBC ShowWhat is ODBC? ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
Sharing and permissions in Windows NT ShowIntroduction to folder sharing Sharing allows resources to be designated as being available to all users over a network. When a folder is shared, users can log into the folder from across the network and access the files within, as though the...
Ask your question Reply

1

Richard, on Mar 19, 2009 1:13:18 am GMT
  • +11

You are developing vb.net application and then you try to connect the ms acces 2007?

   
Reply to Richard

14

PJ, on Jul 14, 2009 4:49:44 pm BST
  • +1

Pleaase help....:(

   
Reply to PJ

17

charan, on Oct 16, 2009 6:06:39 pm BST
  • +2

Hi,
I want the vb.net code to connect the database that client can acces the database from server.

The database I am using is MS - Access 2007. is it possble ?, then please help to me.


thank you,
regards,
charan

   
Reply to charan

2

Tanya, on Mar 19, 2009 7:08:26 am GMT

Yeah...
but its ok richard! i can do it now! thanks for yr reply anyway!

tanya

   
Reply to Tanya

3

Alex, on Mar 19, 2009 7:37:59 pm GMT
  • +2

How did you do it? I'm having some trouble with this same issue... i'm trying to convert over data from vb6 to 2008.

Thx!

   
Reply to Alex

4

kalpesh, on Mar 29, 2009 8:30:52 am BST
  • +10

Hey tanya can you tell me how to connect vb2008 with msaccess2007.....

   
Reply to kalpesh

5

Tanya, on Apr 3, 2009 1:27:57 am BST
  • +5

This coding works for me:-

Dim Conn As New ADODB.Connection
Dim Rec As New ADODB.Recordset

Private Sub Form4_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & "dbase1.mdb"
Conn.Open()

End Sub

   
Reply to Tanya

7

KALPESH, on Apr 18, 2009 10:04:59 am BST
  • +1

Thanks tanya for helping me.....

   
Reply to KALPESH

9

KP, on Apr 24, 2009 1:19:01 am BST
  • +1

Tanya,
How exactly does that work if the Access2007 db extension is .accdb, not .mdb like you have in your code?

   
Reply to KP

10

Tanya, on Apr 24, 2009 7:30:55 am BST
  • +1

Just convert your database table to .mdb...

   
Reply to Tanya

12

fzas, on Jun 12, 2009 8:52:27 am BST
  • +1

How do you convert just a table to mdb in an Access 2007 database?

   
Reply to fzas

8

31121980, on Apr 21, 2009 1:37:19 pm BST

Bagaiamana membuat database access 2007 supaya menjadi file instalasi...n jg bagaimana membuat angka (uang) menjadi terbilang (huruf)....trims sblumnya......

   
Reply to 31121980

11

Tanya, on Apr 24, 2009 7:52:26 am BST
  • +1

Saya tak faham apa yang u maksudkan dengan file instalasi...

"bagaimana membuat angka (uang) menjadi terbilang (huruf)....trims sblumnya.........." ----> u maksudkan integer ke string ke?

saya rasa u boleh terus guna Dim.... sila ikut contoh koding dibawah:


Dim int as Integer
int = 14
lblpapar.text = Str(int);

   
Reply to Tanya

6

KALPESH, on Apr 18, 2009 10:02:25 am BST

Hey tanya ur code couldnt work properly for me but still i learned many things from the same code......thanks for helping tanya.......

   
Reply to KALPESH

13

akangcupez, on Jul 8, 2009 2:40:28 am BST
  • +2

MS Access 2007 database using VB NET : http://www.akangcupez.com/ . Both using wizard and codes

   
Reply to akangcupez

15

sreejith o p, on Sep 7, 2009 10:16:51 am BST

You convert your database into msoffice 2003 format and connect.

   
Reply to sreejith o p

16

Abhi, on Sep 30, 2009 4:36:03 am BST
  • +1

In Access 2008 Database, first save your database as Access 2002-2003 database.
Then,provider=microsoft.jet.oledb.4.0;data source=c:\sdds\dsd\ds\database.mdb
Extension of 2002-2003 Access database in .mdb

   
Reply to Abhi

18

 huda, on Oct 20, 2009 5:03:32 am BST
  • +1

Can someone help me....i cant insert my data from combobox into database....


Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
Dim objConn As OleDbConnection = New OleDbConnection(ConnectionString)
objConn.Open()


Dim MySQLCommand As OleDbCommand = New OleDbCommand()

'Building SQL INSERT statement
insertSQL = "INSERT INTO [register](courseCode,courseName,category)"
insertSQL = insertSQL & "Values"
insertSQL = insertSQL & "(" & ComboBox1.SelectedIndex & ",'" & ComboBox2.SelectedIndex & "','" & ComboBox3.SelectedIndex & "')"
' (" & CInt(TextBox1.Text) & ",'" & TextBox2.Text & "','" &_
'TextBox3.Text & "')"


MySQLCommand.CommandText = insertSQL

MySQLCommand.Connection = objConn

MySQLCommand.ExecuteNonQuery()
'objConn.Close()
MySQLCommand.Dispose()
objConn.Close()
End Sub
End Class

   
Reply to huda
Ask your question Reply
They need your help