Microsoft Access Database to Microsoft SQL database 2005?
913657
Microsoft had the brilliant idea of not including DTS (the import/export wizard) with the express edition of SQL server. It is available under a new name called SSIS (SQL Server Integration Services) under the enterprise edition.\n\nHowever, I did a bit of digging around and came across an article that will allow you to setup the DTS of SQL Server 2000 with the Express edition of 2005 and use it to import and export like before.\n\nIf you do not want to do this, you might be out of luck. Now if you have the enterprise edition or any other edition other than express, you should have the SSIS tools needed to import straight from the MS Access file.\n\nThe link below shows you how to setup the old SQL 2000 DTS wizard to work with express 2005.\n\nEnjoy!
1073711
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.
401213
You'll need to create a database using MySQL, Microsoft SQL or something similar, and pick one of the computers to be the main repository or master. You fill the database up with the current information then copy it to a second database in the other computer, using a second copy of the same software. You then set the two databases to "talk" to each other; during the "conversation" they have, they will update each other with the changes made, no matter where they have been changed. \n\nI'm not sure if you can do this with Microsoft Access but to get it to work right, you'll need a database administrator to make the initial setup and show you how to make the two Quickbooks talk to each other. It is a pretty common task so any decent database admin should be able to get it up and running in less than a day unless your Quickbooks has something quirky about it, or unless you have a lot of data to translate over.\n\nIt's hard to find a reasonably priced freelancer for such a short job because freelancers and consultants usually want a couple weeks' worth of work before taking a project. I'd recommend talking to some friends to see if any of them know a good IT guy in their office (sounds like your office is pretty small). If you can find the tech to do it, I can tell you exactly what to ask for in Microsoft talk. \n\nAlternately, you can consider converting the QuickBooks into an online database program which would be accessible from anywhere that you have an Internet connection, and it would be real-time; if your secretary updated something, you'd see it in an instant. I'm not sure what features you need so I can't recommend one but go to your choice of search engine, and search for "online database" then go browsing!
135369
http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx
369440
It's for compatibility with Access 97.
612650
Try:\nI'm assuming MS Access 2000 and not MS SQL Server 2000?\n\nSELECT *\nFROM [ProdServers]\nORDER BY [Server Name/OS/DNS Alias]
606482
Normally private software have their own way to store data through proprietary format files.\n\nAn Microsoft Access or Microsoft SQL Server can do the same thing (and often better) than those proprietary format but you need to buy them (and they are expensive).\n\nIn fact, Access and SQL Server is normally used by business to keep their information about their customer. I won't tell you the difference between all those databases but if you really need something to work with, I suggest you SQL Server 2005 Express which is totally free. ( http://go.microsoft.com/fwlink/?LinkId=64064 )
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.
488741
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.
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.
1182532
Ok, if I am understanding this properly, access is referring to Microsoft Access?\n\nYou cannot open a dbf file from within Access.
1158830
In a word: yes\n\nif you have an familiarity with ms-sql 2000 using the built in reporting services, and as you're familiar with crystal reports, you'll discover that the reporting services within ms-sql 2005 with the included reporting services has quite a few more features.\n\nRealize though that the reporting server/services defaults to C# pages; so there isn't really much of a difference; as you'll be dealing with a programming language of some sort, rather than having the actual database perform the functions which will create the reports...\n\nif i may suggest.\n\nAs you're already using stored procedures, why not expand the power of sql (as long as the flavour is at least 2k SP2), and have it create the reports directly with a few triggers defined by the dynamic pages in whatever flavour language you prefer?\n\nThe reporting server/services when installed, generates a slew of directories, pages, and control (behind code pages) defaulting to C# asp.NET 2.0 pages.\n\nif you are curious, i recommend downloading MS-SQL 2005 Express and install it. You'll be able to apply it to any website located currently within your development/staging environment and test it directly without interfering with your currently deployed applications.\n\nPersonally if it were me. I'd likely avoid the management of a database conversion of parameter values via a scripting language, and just have the database do what it's meant to do. After all, most dbase enterprise systems have intergrated capabilities to produce reports in a variety of methods (w/ my preference being xml/xsl display, leaving me the option to display within any environment in any codebase).
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
842942
Here's a discussion that might interest you\nhttp://forums.techguy.org/business-applications/491904-convert-wdb-xls.html\n\n///
315742
Actually, there is a way, sort of.\n\nIn the Office Resource kit, there is a tool that will allow you to share an Access database (mdb) with other users, basically making your access db into an executable.\n\nCourse, you need the office Developer edition (or was it really in a resource kit?).  I'd suggest you do a search on microsoft.com's knowledge base.
103793
I presume your talking about project done in access db itself. Go to the tools menu and select the "Startup" option. It is here you can setup how your access application starts up. For more information see the help files\n\nHope this helps
566403
Microsoft Access software can do that.