which one is more secure? ms-access or ms-sql?
918743
SQL server is very very more secure than access and faster and more relyable.\naccess is not good for the case that you need security or larg amount of data .\nfor example if you want test it .... I can send you a file wih finds a ms-access database's password in less than 30 seconds.\nthen you can see how secure acess is.
1055787
Can you access/write to files in general on that drive?\nWhat error occurs?\n\nhttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EJDAC\n\nis a good summary of ms sql backup options
161844
www.1keydata.com\nwww.comserving.com\nwww.sqlmag.com\nwww.mssqlcity.com
349386
The main difference between oracle and MS access is that oracle is a database server and MS Access is on a single user database not a server.   Oracle is a true production database and can handle many concurrent users.  \n\nI would also say that Oracle supports Procedural Language SQL (stored procedures and triggers) [PLSQL] whereas Access can only call them via macros.\n\nAccess tends to reside only on Windows systems wheras Oracle can reside on unix, windows, solaris.
1088795
Use SQLDMO and SQLDTS both are references for the SQL Server. But they should also work with Oracle. But it's a crazy thing. I just do it on an SQL Server and you get mad by solving all the errors you can get.\n\nHelmut\n\nP.S.: A good source to get a idea about it, download the SQL Samples and look for the Bulk Insert Task
267072
Really it depends on which database u'd like to administer,you have two basic choices,\nwhether oracle or mssql server...\nBut i recommend microsoft sql server Coz it's very powerful database,\nonce u choose mssql server, you should go and take the MCDBA course.check it out on microsoft.com\nby the way,\nI've just finished this certificate :\nMicrosoft Certified Database Administrator\nif you wanna know more,\nu can contact me \nfadydodo2004@yahoo.com
60974
I prefer PHP because it is very flexible and fairly easy to learn. I would avoid ASP because of all the security problems with IIS servers.
294787
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.
1033121
That being a microsoft program u can use a ligter version which i beleive is free too... it's called SQL 2005 Express Edition... if you want something fully robust and not deal with the high cost, I would personally recommend MySQL. I have used it in all my softwares and we currently use it in our main datacenter to handle all our data from our 35 remote offices world wide... it is extremely fast... we handle over a million transactions a day... give it a try.
580927
Well, usually depends on what type of hosting solution you have. If the host is ran on a unix/linux box, you will often find MySQL installed. If it is a windows solution, you usually find MS SQL Server.\n\nHere are some advantages of both...\n\n1) MySQL is usually very fast database because it is strongly based on an index lookup type of structure. \n\n2) Works great with languages like PHP which I highly recommend you use for a website.\n\n3) Very memory efficient and takes less space to run on a server (usually).\n\n\nMS SQL Server\n\n1) Integrates well with other Microsoft products. If you have an all microsoft hosting solution going, you will probably want SQL Server.\n\n2) It allows the use of Stored Procedures which allows you to execute groups of commands on the server independent of user activity.\n\n3) Some of the later versions also offer great reporting utilities and statistics.\n\n\nBut this is all usually dependent on what you are running for an Operating system on the host. PHP and MySQL are great for unix/linux systems and ASP/MS SQL Server is good for windows environments.\n\nEven though you will find people on here leaning one way or the other, it all really depends on what you are looking for out of your website. Generally unix/linux is more stable but a bit harder for newbies to use and windows uses a lot of resources and less stable, but easier for newbies to use and understand.\n\nI hope I have made things a bit more clear for you.
221048
For SQL Server, there are two: Windows integrated authentication and SQL server authentication\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp\n\nEach has its strengths and weaknesses. I prefer SQL authentication (user name / password stored in SQL Server), because it makes me able to deploy databases in an anonymous user environment (that is, an unauthenticated Web user can use my databases).
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.
536894
Make an ODBC and then use the JDBC-ODBC Bridge to connect to Access and issue SQL Statements to insert records in your DB!
657055
It is a database software.
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.
879067
Use mySQL and secure it. Plus, once it is set up you can manipulate it so much easier.
1032537
Learn to use Microsoft Access and build it yourself.  You're not likely to get someone to write you a database for free.\n\nAccess has pre-built databases and wizards that spoon feed you through development.  Try it, you may enjoy it.