Any one who can give me  a javascript sample code to connect MS- Access database?
438038
i would have a look at this site\n\nhttp://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=5120&lngWId=2
1739
There are a variety of ways to connect to an Access database from within a C++ app.\n\nThe oldest and most widely compatible is ODBC. It's not as fully featured as some other technologies, but it's the standard minimum compliance of pretty much everything.\n\nIf you're running on Windows, I'd suggest using ADO or ADO.NET. They're virtually the same interface, ADO.NET has some features that ADO doesn't have, but I'm not sure it's completely compatible with C++.
39144
It's been a number of years since I worked with Access, but the answer above will work if the database is on another machine and you ONLY want to access the data over the network.  If, on the other hand, you need to download the .mdb to a laptop and take it on a plane, for example, I seem to recall there was an Access 'run time' option.  In that case, you'll probably want to compile your .mdb into a .mde file.  See the source(s) link.
66876
Here's a pretty good one I wrote:\n\nhttp://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=58476&lngWId=1\n\nYou'll need Visual Basic to compile it or you can e-mail me and I'll send it to you...
419806
Take a look at this web site :\n\nhttp://www.fgcu.edu/support/office2000/a...\n\nThis should give you the start you need. Also the programming language of all office products is Visual Basic. If you want to write your own macros then you will have to learn this programming language first. \n\nMoreover, to get even better at MS Access read its help files. They give tons of information about forms, buttons etc. Also when using the help file use the contents tab which group all the topics very nicely and will allow you understand each aspect of MS Access\n\nHope this helps
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()
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
1183198
1. Simply open up the database.\n\n2. Make sure that you're looking at the database window (F-11)\n\n3. Hit file / Get External Data / Import\n\nA wizard will open up and you can select the other database that you want to import.\n\nThis works well, but does not import database properties, and you might have some trouble if you have different version of MS Access databases
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.
268850
Imports System\nImports System.Data\nImports System.Data.OleDb\nTry \n'construct the command object and open a connection to the Contacts table\n\nDim cmdString As String = "Select ContactID, FirstName, LastName from Contacts"\nDim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:&#92;&#92;contactmanagement.mdb"\nDim myConnection As OleDbConnection = New OleDbConnection(connString)\n\n' Open connection\nmyConnection.Open()\n\n'Create OleDbCommand object\nDim TheCommand As OleDbCommand = New OleDbCommand(cmdString, myConnection)\n\nTheCommand.CommandType = CommandType.Text\n' Create a DataReader and call Execute on the Command Object to construct it\n\nDim TheDataReader As OleDbDataReader = TheCommand.ExecuteReader()\n\nWhile TheDataReader.Read()\nSystem.Console.Write(TheDataReader("ContactID").ToString())\nSystem.Console.Write(" ")\nSystem.Console.Write(TheDataReader("FirstName").ToString())\nSystem.Console.Write(" ")\nSystem.Console.Write(TheDataReader("LastName").ToString())\nSystem.Console.WriteLine()\nEnd While\n\nCatch ae As OleDbException\nMsgBox(ae.Message())\nEnd Try
1169309
You have to program a SMTP server and a client.it will keep different accounts and stores the messages and when you login it will show you your list.thus you can use JAVA with MS-Access.
852680
Well don't know the version of access you are using...\n\nFor Access 2003\nhttp://office.microsoft.com/en-us/access/HP051874901033.aspx
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
171968
Microsoft Access has two built-in security features for protecting your database: \n• User/Group accounts and permissions \n• Database passwords \n\n---------------------------------------------\nBy using code, you can prompt for a password when a user opens a form or a report. If the correct password is entered, the form or the report is opened.\n\nThe following example shows you how you can password protect the Orders form in the sample database Northwind.mdb: \n1. Start Access and then open the sample database Northwind.mdb. \n\n2. Press ALT+F11 to start the Microsoft Visual Basic editor. \n\n3. On the Insert menu, click Module. \n\n4. In the module sheet, type the following procedure:\n\nPublic MyPassword\nPublic Function KeyCode(Password As String) As Long\n   ' This function will produce a unique key for the\n   ' string that is passed in as the Password.\n   Dim I As Integer\n   Dim Hold As Long\n\n   For I = 1 To Len(Password)\n      Select Case (Asc(Left(Password, 1)) * I) Mod 4\n      Case Is = 0\n         Hold = Hold + (Asc(Mid(Password, I, 1)) * I)\n      Case Is = 1\n         Hold = Hold - (Asc(Mid(Password, I, 1)) * I)\n      Case Is = 2\n         Hold = Hold + (Asc(Mid(Password, I, 1)) * _\n            (I - Asc(Mid(Password, I, 1))))\n      Case Is = 3\n         Hold = Hold - (Asc(Mid(Password, I, 1)) * _\n            (I + Len(Password)))\n   End Select\n   Next I\n   KeyCode = Hold\nEnd Function\n\n \n5. Press ALT+F11 to return to Access. \n\n6. In the Database window, under Objects, click Tables, and then click New. \n\n7. In the New Table dialog box, double-click Design View. \n\n8. Create a new table as follows:   \n   \n   Table: tblPassword\n   ---------------------------\n   Field Name: ObjectName\n      Data Type: Text\n      Field Size: 50\n   Field Name: KeyCode\n      Data Type: Text\n      Field Size: 25\n      Input Mask: Password\n\n   Table Properties: tblPassword\n   -----------------------------\n      PrimaryKey: ObjectName\n\n \n9. Open the tblPassword table and then enter the following data:     \n       ObjectName: Orders\n       KeyCode: 2818\n\n10. Create a new form in design view and save the form as frmPassword. \n\n11. Add a single textbox to frmPassword called Text0, and a command button called CheckPassword. \n\n12. Set the Input Mask property of Text0 to "PASSWORD" (minus the quotation marks). \n\n13. Add the following code to the OnClick Event of the CheckPassword button and then save the form:\n\nIf IsNull(Forms!frmPassword!Text0.Value) Then\n   MsgBox "You cannot enter a blank Password. Try again."\n   Me!Text0.SetFocus\nElse\n   MyPassword = Me!Text0.Value\n   DoCmd.Close acForm, "frmPassword"\nEnd If\n\n14. Open the Orders form in Design view. \n\n15. If the property sheet is not visible, click Properties on the View menu. \n\n16. Type the following event procedure in the module for the OnOpen property of the form:\n\nPrivate Sub Form_Open(Cancel as Integer)\n   Dim Hold As Variant\n   Dim tmpKey As Long\n   Dim I As Integer\n   Dim rs As DAO.Recordset\n   Dim db As DAO.Database\n\n   On Error GoTo Error_Handler\n   ' Prompt the user for the Password.\n   DoCmd.OpenForm "frmPassword", acNormal, , , , acDialog\n            Hold = MyPassword\n' Open the table that contains the password.\n   Set db = CurrentDb\n   Set rs = db.OpenRecordset("tblPassword", dbOpenTable)\n   rs.Index = "PrimaryKey"\n   rs.Seek "=", Me.Name\n   If rs.NoMatch Then\n      MsgBox "Sorry cannot find password information. Try Again"\n      Cancel = -1\n   Else\n      ' Test to see if the key generated matches the key in\n      ' the table; if there is not a match, stop the form\n      ' from opening.\n      If Not (rs![keycode] = KeyCode(Cstr(Hold))) Then\n         MsgBox "Sorry you entered the wrong password." & _\n            "Try again.", vbOKOnly, "Incorrect Password&qu
1124098
In VS.NET Xpress u can connect with databases using \n1.SqlClient, 2. OleDb, 3. Odbc\nThese classes hav inbuild methods that makes everything simpe and sweet.\n\nFor indepth coverage on these topic visit microsoft's MSDN, Also go thru sqljunkies.com, dotnetjunkies.com\n\nOleDb Code Sample\n************************************************\n\n\nusing System;\nusing System.Data;\nusing System.Data.OleDb;\n\nclass Sample\n{\npublic static void Main()\n{\nOleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");\n\nOleDbCommand catCMD = nwindConn.CreateCommand();\ncatCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";\n\nnwindConn.Open();\n\nOleDbDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}\n\nOdbc Code Sample\n************************************************\nusing System;\nusing System.Data;\nusing System.Data.Odbc;\n\nclass Sample\n{\npublic static void Main()\n{\nOdbcConnection nwindConn = new OdbcConnection("Driver={SQL Server};Server=localhost;" +\n"Trusted_Connection=yes;Database=northwind");\n\nOdbcCommand catCMD = new OdbcCommand("SELECT CategoryID, CategoryName FROM Categories", nwindConn);\n\nnwindConn.Open();\n\nOdbcDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}
1153856
You can't, you can only build a spreadsheet, or a single table database.  You can use Access to build DB's.\n\nIf you need tuturiols on how to create/manage a Access Database.  See the links below.
885958
This code is the minimal. Here it validates the user name and password are admin. In case both the values are admin it allows login. Else it returns an error message - error!\n\nThe only thing that may be confusing for you over here may be the session concept. \n\nThis code has no databse connectivity. Incase you are planning for a database based project use a MS Access connectivity. Its easy.\n\nLet me explain this code\n\n<% IF Request.form="" THEN %> \n<html> <body> In order to access this pages fill the form below:<BR> \n'THIS IS TO POST DATA FROM THE PAGE\n<form method="post" action="index.asp"> \nUsername: <input type="text" name="username" size="20"><BR> \nPassword: <input type="password" name="password" size="15"><BR> \n<input type="Submit" value="Submit"> \n</form> </body> </html> \n<% ELSE %> \n'IF USERNAME AND PASSWORD NOT admin RETURN an ERROR\n<% IF Request.form("username")="admi... AND Request.form("password")="admi... THEN %> \n<% Session("permission")="YES" \nSession("username")="admin" \n%> \n<html> <body> \n'THEN YOU CAN VIEW PAGE1 &  PAGE2\nHi <% =Session("username") %>, you can view: <BR> \n<A HREF="page1.asp">Page 1</A><BR> \n<A HREF="page2.asp">Page 2</A> \n</body> </html> \n<% ELSE %> Error! <% END IF %><% END IF %>\n\nYou can mail me to technoblitzs@yahoo.com incase you have any clarification or want to connect to  a database.