make a client server db application using access and vb.net?
114358
bigbubba is right. SQL is far more stable when multi-user access is needed.\n\nif you cannot afford a SQL server, you can use MSDE from Microsoft which is free.
383056
what kind of program are you doing?? all i know is visual basic stuff
703118
Ha ha, I can see you are really not confident with the answers you got here....\n\nhttp://answers.yahoo.com/question/index;_ylt=AlI9gwykBhVeKvyNGEdFIuLsy6IX?qid=20061117134707AA5pMtM\n\n...all the best.....\n\nalso try the microsoft access public groups and google groups.\n\nlol\n\n\nI can see that you got a solution there which is basically a similar approach to web services. Under VB.NET, a web service would work better for you because you can more easily transfer data between the server and you client app using Datasets. It provides a cleaner model for your application. But anyway, the idea is just the same... either way you have a script running between your app and the databse on the remote server. The sample on planetsourcecode is good and if that works better for you its excellent.
747603
Depending on where you are (the main form or the subform) and what you need to access, there are several different ways of doing this.  Check out the forum archives at:\n\nhttp://www.access-programmers.co.uk/forums/archive/index.php/t-77746.html\n\nto see how to do this.  I grabbed the text and saved it on my hard drive so I could get to it later; this cheat sheet really helps!\n\nPS: This is a MS-Access question, not a VB 6 question.  MS-Access uses "VBA" (vb for applications), VB6 has a compiler and it's own form editor.
945171
The problem is that Microsoft Access, as I am sure you are aware, is very limited in its use. It is great for hobby projects, and small applications, but for commercial applications, you hit the wall very quickly.\n\nIn MS-Access 2003, a 7-table join is the upper limit. If you want to join more tables in a query, then you have to rethink your design - or denormalise the database, which defeats the purpose of proper design in the first place.\n\nI have written a medium-sized commercial application in MS-Access, but I stretched the limits of what MS-Access could handle, in almost every way imaginable, and I would never want to build a career in programming MS-Access :-)\n\nMy suggestion is therefore... Since you know MS-Access, sell yourself as a VB developer - it should take little time to bring yourself up to speed on the differences in Basic dialects, and you end up with a more robust platform. You could also go for C# or another .Net language.\n\nGood luck :-)
633242
Here is a free version from Microsoft. It is not the full blown version, but does most everything.\n\nhttp://msdn.microsoft.com/vstudio/express/vb/\n\nThis will get the beginner started.
142487
Try the following link:\n\nhttp://custom.programming-in.net\n\nIt has info about the API along with how to access it from C#, VB.NET & VB6
271336
Use a SSI (server side include)\n\n<!-- #Include File="file2.aspx" -->\n\nShould work for any web application that supports them including ASP .NET
143941
1) Oracle has a program call SQL Loader that loads tables from external data.  You can write a module in Access to create a flat fiel from your data and put it in a form where SQL Loader understands.\n\n2) A solution that works with almost any RDBMS is to write a module in Access to create SQL Insert statement for each record in your Access table, and write them to a file.  Then, using the RDBMS's batch execution engine (SQL PLus for Oracle, OSQL for SQL Server, MySQL command prompt, etc, ISQL for Sybase, etc), simply create yout table and run those insert statements.\n\nAn example of 2) would be ...\n\nFunction doIt()\n\nDim rs As Recordset\n\nSet rs = CurrentDb.OpenRecordset("Select f1, f2 from t1;")\nOpen "c:&#92;statements.sql" For Output As #1\nWhile Not rs.EOF\n    Print #1, "Insert into T1 (F1, F2) values ('" & rs("f1") & "', '" & rs("f2") & ")';"\n    rs.MoveNext\nWend\nClose\nrs.Close\n\nEnd Function
208203
If you don't really need VB 6, but could work with VB.NET, Microsoft gives away Visual Basic .NET Express, which does pretty much everything a hobbyist / student needs. You can download it directly from them.
292214
Once a new UserConnection object has been inserted into the project, you can add new Query objects to it. These query objects can be either stored procedure calls or user-defined SQL statements. Each query object defined at design-time will automatically be available as a method of the new UserConnection class.\n\nTo add a Query object, click the leftmost button on the toolbar. The new Query object is added hierarchically below the UserConnection object, and its Properties Window appears.\n\nSelecting Stored Procedures\nSelect Insert Stored Procedure to view the available stored procedures on the database. The UserConnection designer attempts to establish a connection to the database, using the connection properties you entered. If successful, it enumerates the available stored procedures on the database, allowing you to select one to define the Query object:\n\nQuery Properties dialog box\n\n\n\nInserting User-Defined Queries\nChoose Based on User-Defined SQL to create a local query against the remote database. This enables the SQL property box, into which you enter SQL statements to define your query.\n\nAlternatively, you can click the Build button, which opens the MS-Query query design tool. MS-Query provides a visual interface that allows you to drag and drop database tables and fields, define conditions and set relationships to define the query. When you exit from MS-Query, your visually-designed query is automatically translated into SQL code and inserted into the User-Defined SQL property box.\n\nFor More Information   For more information about using the MS-Query query builder, see MSQry32.hlp which is installed in the &#92;Program Files&#92;Common Files&#92;Microsoft Shared&#92;vba directory.\n\nSetting Other Query Properties\nIn addition to the defining properties discussed above, the Query Property Page has two additional tabs for defining Parameters and advanced properties.\n\nThe Parameters tab on the query property page allows the developer to adjust properties for each parameter in the current query.\n\nParameters properties\n\n\n\nThe parameters shown in the Parameters list box are determined automatically from the query source, and cannot be changed here. Parameters are generated for each parameter marker in the SQL statement for the query (or call statement for stored procedures). Parameter markers are designated by a "?" in accordance with the ODBC specification. For example, the following query would contain two parameters:\n\nSELECT * FROM authors WHERE state = ? AND zip = ?\n\nThe parameter properties that can be changed here are the Name, Direction, ODBC Binding Data Type, and Visual Basic Data Type.\n\nThe Name property can be changed to allow your Visual Basic code to recognize the parameter by a familiar sounding name, if its actual name is complex or not intuitive.\n\nSetting the Direction of a parameter may be necessary for some ODBC databases for which the driver is not capable of determining the direction (input, input/output, or return values). The same is true for the data types, and you may wish to override the default type conversion into Visual Basic data types for use with your code.\n\nAdvanced Query Properties\nThe Advanced tab of the Query Properties page allows for fine-tuning the query by setting limits and thresholds.\n\nAdvanced properties\n\n\n\nThe Call Syntax text box lets you change the call syntax that RDO will use to call the stored procedure. This can be edited to adjust the number of parameters and presence of the return value. Editing the call syntax is an advanced operation and should only be done by developers who understand the ramifications.\n\nUsing the UserConnection Object in Your Code\nYou can insert the UserConnection object into your Visual Basic code just as you would with any class, by creating an object variable and instantiating it with a new instance of the UserConnection class you have defined. For example:\n\nOption Explicit\nPrivate MyConnect As M
377667
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
505572
Make sure you have added a reference to Microsoft ActiveX Data Objects 2.x Library to your project.  Then here’s code assuming you’ve created an ODBC Data Source – System DSN with the database named “Customers.”  Good luck!\n\nDim rsRecordset As ADODB.Recordset\nDim cnConn As ADODB.Connection\nDim strSQL As String\n   \nSet rsRecordset = New ADODB.Recordset\nSet cnConn = New ADODB.Connection\n\nWith cnConn\n    .ConnectionString = "DSN=Customers;UID=;PWD=Deleted=No"\n    .Open\nEnd With\n\nstrSQL = "SELECT * FROM CustNames”\n\nrsRecordset.Open strSQL, cnConn, adOpenStatic, adLockReadOnly
283150
Here's a code snippet that you should be able to paste into a form module and give it a try ... there are obviously many ways to tackle the issue ... this is just one of them.  To use this code you'll need a reference in your VB6 project to a Microsoft ActiveX Data Access Library (like 2.6).  Good luck!\n\nDim rs As Recordset\nDim cn As Connection\n\nDim DBPath As String\nDBPath = App.Path & "&#92;customer.mdb"\nSet cn = New Connection\ncn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath\n\nSet rs = New Recordset\nrs.CursorLocation = adUseClient\nrs.Open "SELECT * FROM tblCustomers WHERE CustomerID=" & 1, _\n    cn, adOpenStatic, adLockOptimistic
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.
740092
in VB 2005, there is ready to use and very simple terms to use database connectivity with your application. once u have build database , in VB 2005 go to the data menu and click on add new data sourse and rest of the things you will understand for sure.
643171
This forum will probably lack the comprehensive information you need.  The materials provided with the Access program can get you started, however I suggest visiting a book store for a "How TO" instructional book.\n\nDo a search for "Microsoft Access" on amazon.com as a starting point.\n\nOn the web, research these sites:\n\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr051202.htm (About Databases)\nAccess Database Too Big! \nAccess Database Too Big!\nhttp://databases.about.com/b/a/222380.htm (About Databases)\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr060902.htm (About Databases)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 2/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401b.htm (About Delphi Programming)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 1/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401a.htm (About Delphi Programming)\nBuilding an Access Database From the Ground Up \nIn this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/od/buildinganaccessdatabase/index.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals \nhttp://databases.about.com/b/a/139756.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals\nhttp://databases.about.com/b/a/243511.htm (About Databases)\nBuilding an Access Database From the Ground Up \nIn this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm (About Databases)