use VB6 and ASP to access 1 MS Access database. can i update the data in the database using both?
209235
actually you can use an easier way, SQL2000.
375220
**********************************************\nIn short MS SQL is a language used to manipulate databases via codes SQL meaning Structured (or Simple) Query Language\n\nMs Access is a WYSIWYG (what you see is what you get) Program to create databases\n**********************************************\n\nNOT SO SIMPLE...\n\nThe fundamental difference is that MSSQL is client/server RDBMS and Access is file-based. MSSQL has a server side component (databse engine) that always need to be running before you can connect to any databses and you need to get a client component (GUI e.g. SQL Enterprise Manager, query analyser, etc) in order to connect to the server component. Access is actually a Jet engine database and you use MS Access as the GUI. MS Access offers you excellent GUI tools to manipulate the data in the .mdb Jet database file. However, you can connect to access from other GUIs e.g. VB6 IDE. You can research on file based vs server based databases.\n\nBoth are SQL databases, which is by the way a language itself. The SQL standard describes a common language for manipulating and defining data in compliant database management systems. Thats how you can write a VB6 app for example which uses an access backend, and not need to have MS Access installed in order to access the data in the .mdb file.\n\njust google something like mssql vs access and sift through the results.\n\nhttp://www.cypressinland.com/access_vs_sql.htm\n\nThis is a good comparison (MSDE is scaled down SQL Server):\nhttp://msdn2.microsoft.com/en-us/library/aa140017(office.10).aspx
437999
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
222974
You would have to either write an interface between COBOL program and MS Access, or dump the data base to a text file and have COBOL read the text file. Either way, you would have to write the COBOL program.\n\nIf you are loading to a relational data base, just use Access.
78695
Open access click on open new file then click on  project using exsisting data click on the data you are wanting to use make your new database then save it to your documents under the name you want to use for it.
280633
Tatzug is quite right that you should link directly to the tables in the database on the server, and then Access will be able to see and use the correct data type for each field.  You do this as follows:\n\n1.  Set up an ODBC link to the SQL Server\n\nYou do this using the "DataSources (ODBC)" control panel, which is found under Administrative Tools.  This is actually a "wizard" which will lead you through the process of creating the ODBC link.\n\n2.  Inside Access, go to the File menu and select Get External Data, then Link Tables.\n\nWhen the file dialog opens, switch the File Type at the bottom to "ODBC Databases ()" and select the ODBC link you created in step 1.\n\nThen you'll get a dialog box which will allow you to select the database tables on the server you want to link to.\n\nGood luck!
638724
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}
122520
A database will work very well for what you need. MS Access is the only one I have personal experience with. I'm sure there are better apps out there. Create a query based on the cert expiration date and run it as needed.
209193
You can use Tables from MS Access or MS SQL Server Already loaded with Data
666146
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.
24513
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.
562432
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.
416144
Use either Access or MySQL. 1000 records is very small, you do not need to pay the $thousands for MS SQL or Oracle. Access can definitely handle 1000 records.\n\nOne nice thing about Access is that it enables you to create forms. So people can input data using a visual form, and the data goes into the database. Also, Access offers a GUI for creating your database tables. MySQL does not offer these capabilities, but its main plus is that it is free. I would question what the other guy said about how powerful it is, though. It is definitely a lot weaker than Oracle or MS SQL, BUT for your needs it should be fine.\n\nEither Access or MySQL will work fine for Web programming too if you want to connect your db to an online Web site.
45883
You absolutely can through an ODBC connection.  Are you using DB2 on an AS/400?\n\nSee the following instructions:\nhttp://support.businessobjects.com/library/kbase/articles/c2016569.asp
608008
First, since you didn't mention a particular version of VB, I would recommend using Visual Basic 2005 Express Edition. Associated with SQL Server 2005 Express Edition and Visual Web Developer 2005 Express, you can do really neat things very simply and quickly. Much better than previous editions.\n\nThen I would recommend three books:\n\n\n1. Wrox's Visual Basic 2005 Express Edition Starter Kit \nhttp://www.amazon.co.uk/exec/obidos/ASIN/0764595733\nTo begin. Included is a DVD-Rom containing VB 2005 Express, SQL 2005 Express and all the electronic documentation you'll need in the form of MSDN. The book is clear and good enough for an introduction.\n\n2. Visual Basic 2005 Express Edition for Dummies\nhttp://www.amazon.co.uk/exec/obidos/ASIN/0764597051\nThe book itself contains more ranting and lame jokes typical of the "for dummies" style, so it is pretty much useless, but the included CD-Rom contains very good tutorials and sample files that more than make up for the paucity of the book. Very good for a hands-on approach as opposed to the more theoretical approach of the first book.\n\n3. Beginning SQL Server 2005 Express: Database Applications with Visual Basic Express and Visual Web Developer Express  \nhttp://www.amazon.co.uk/exec/obidos/ASIN/1590595238\nIf the website you need to create relies on database and you need more info than contained in the first two books.
28605
It's been a while since I've played with Access, but what you're asking sounds right.  As long as the query is looking for the data in the same table, it should produce the same results.  I've never tried this, but it makes sense from a theoretical point of view.  Hope it works for you!
46052
It looks like you can't.  I verified this for Access 2000 and it seems to be true for Access 2003.\n\nYou'll have to write some Visual Basic code to check the field value and pop-up a dialog box.  The code can be linked to the field's BeforeUpdate event.