How do i update my database in VB...????
913205
Here are some links to get you started :\n\nADO : http://support.microsoft.com/kb/168336...\nDAO : http://www.devdos.com/vb/lesson4.shtml...\n\nHmmm... Those links are not working. Sorry.\n\nHere is another : http://www.functionx.com/vbaccess/\n\nI would suggest you start using ADO, as DAO is slowly being phased out.\n\nGood luck!
966661
check out http://www.pscode.com for examples.  You would need to use ADO.NET in addition to VB.NET in order to obtain the required data.
130017
An Access database is just an ordinary file.  Use the My .ComputerFileSystem .CopyFile function.  This requires VB 2005.\n\n(Spaces added to foil Yahoo! mangling.)
998469
I'm afraid that Dirty D is right.  Developing a database in MS Access isn't like firing up MS Word and cranking out a document.  You really need to begin with the basics of database design and go from there.  I located a pretty comprehensive tutorial website at:  http://www.functionx.com/access/.\n\nThe short answer to your question is that you click on "New" to create a new database.  I've never used Database Wizard, but I presume that it helps you structure a simple database.  That said, I'd still recommend that you at least check the above link to give you a better understanding of how Access works.
112568
refer these urls..\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5b1v.asp\n\njust surf through the bookmark on left hand side..\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_30s5.asp\n\n\nalso refer this one..simple n straight forward\nhttp://www.1keydata.com/sql/sql-create-index.html
850443
ok I give some hints\nIf you want to refer to a database from Excel you need to add the ADO 2.8 objects Library. \nHow to proceed?\nFrom the Visual basic editor, click on tools (menu bar) and then reference. look for Microsoft Activex Data objects 2.8 library and tick it.\nNow you should have access to ADO objects.\nTo learn how to use these objects try the msdn microsoft website, full of advice and templates\n\nIf you want an example from me, give me a valid email address where i can send you an excel workbook and small access data base for it takes too long to explain
908020
http://www.vb-helper.com/tips7.htm\n\nSorry I don't personally know about VB so I done a search for you\nI hope this helps, :)
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
62810
You can't normally do it as a database file can't be changed into an executable file. You could write macros or program some Visual Basic classes and forms to have the database file contain an independent interface and save that as an executable.
931713
I think for that u need the machine name or the IP address of the database machine.\n\nU can use this machine name or IP as the data source value in ur connection-string value provided for connection in ur code..
1058878
To create a new database, go to File-New, and then in the Task Pane, click on Blank Database.  You'll be prompted to save it off the bat, so name your file and choose your location.  Hit Save, and you're done!\n\nOpening a database is just like opening any other Office document.  Either double click the file or go to File-Open and it should present you with a file system.  Just find your file and then hit Open, and you're set.
282906
Try using an includes file. If you have the VB script, then you can either put it into a file called VB.inc and then reference it like this:\n<!--#include virtual="VB.inc"-->\n\nThis should all you to use the code you currently have in your site. If you want to write to the page, try using\n<script language="visualbasic">\n//your script here.\n</script>\n\nFinally you can save it as a vbscript and reference it as shown above. \n\nGood luck!
368518
This is one of many ways to do it. This is the most straight forward and assumes you know sql syntax & that you know your connection string:\n\nDim cn as New System.Data.SqlClient.SqlConnection()\nDim cmd as New System.Data.SqlCommand()\n\nTry\n     'set your sql connection string here\n     cn.ConnectionString = ""\n     cn.Open()\n     cmd.CommandText = "delete from [MyTable] where [MyRowID] = 123"\n     cmd.ExecuteNonQuery()     \nFinally\n     If cn <> Nothing AndAlso cn.ConnectionState = System.Data.ConnectionState.Opened Then\n        cn.Close()\n        cn.Dispose()\n     End If\nEnd
1101440
Hi,\nI am database programmer and use MS Access and SQl and others. Give a detailed example what you exactly want to do. Then I will tell you the design. I never designed a database wrong until now, hehe.\n\nA very important tip for you! If you want later export the database to SQL do NOT use the export wizzard of Access. This wizzard does not work and cost only time. Use the Import Wizzard in SQL. This wizzard works. \n\nNice greetings\nFranky
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
465093
Just search on yahoo for vb tutorials. If you are specific enough with your problem, it will display many forums, that people have had the same problems with, and others have answered.
1074603
Off course, several ways..\n- Export your database into Excel file (xls or csv or ... ) and open it in Excel\n- In Excel go to Data > Import Externat data > new database query\n- Copy and paste\n\nRead my profile, I am the XLMan