Erm, database help

• Big Bot

  30 Aug 05, 23:54

  Okay if I use VB.Net.
  
  ( the access file and the .VB files are in the same folder)
  
  Then I set up a database connection using this computer.
  
  ( the access file and the .VB files are in STILL the same folder)
  
  Then if I transfer my files to another computer, do I need to reconnect to the Database all over again using that computer's provider and stuff?
  
  Or will it work as normal?
• R3SsH|n

  31 Aug 05, 00:05

  wat u mean by reconnect?
  if u create the database files in your forms...should be able to work on another comp...just copy the folder wholesale
• R3SsH|n

  31 Aug 05, 00:09

  oh...you use access huh...
  think gotta move the access files oso ba...
  think should work
• Big Bot

  31 Aug 05, 00:37

  Sure not? Becos I do at home cannot, then I do at school de Desktop cannot....but I put My Documents of my school comp can...
  
  
• R3SsH|n

  31 Aug 05, 00:46

  dun trust me?
  ah bo u create,initialise and use your sql statements from the form codes itself...confirm can...even if u do own your own comp or school comp...
• Big Bot

  31 Aug 05, 00:51

  Originally posted by R3SsH|n:

  dun trust me?
  ah bo u create,initialise and use your sql statements from the form codes itself...confirm can...even if u do own your own comp or school comp...

  ... If wanted to type out the codes... mine as well dun use Visual Studio...
  
  But how come I put in Desktop got error? Put in MyDocuments no error?
  
  I confirm that my Access is in the same folder as my program.
  
  And I only used the OleDbConnection to connect the the OleDb Jet Provider 4.0 and my Access file...
  
  Why cannot?
• R3SsH|n

  31 Aug 05, 00:59

  the codes u use in the form...looks someting like
  C:\My Documents\sql?
• Big Bot

  31 Aug 05, 01:04

  Originally posted by R3SsH|n:

  the codes u use in the form...looks someting like
  C:\My Documents\sql?

  I never type the codes one...
  
  First I drag the OleDbConnection. Then I click on Connection. Then got a popup come out ask me configure then I click Provider then select MS OleDb Jet 4.0 or something...then click next then it ask me select my database file..then I select okay already, I click test connection... then it says test succeeded...
  
  Then I drag OleDbAdapter. Then got a Wizard, I clicked next, then it ask me want to use wat... then I select SQL... then it prompt me type in SQL statement... then I type in....
  
  Then I right click OleDbAdapter...generate DataSet...then it generate a DataSet...
  
  Then I drag a DataGrid... then configure the DataGrid to my Table and the colum..
  
  Then can use le...