MS Access Database Design?
485900
The MS Access database size limit is 2GB.  You can't change that, but putting your forms, reports, queries, etc. in a separate database and then using linked table will help.  That will let you have a 2GB database for just data.\n\nYou CAN have multiple databases of 2GB all linked in a single application, but you'll run into a brick wall if you need referential integrity, cascading updates and deletes, etc.\n\nIf you haven't already designed your database, it would be eaiser to use MS SQL or MySQL for a database.  The MySQL route is nice because it's FREE, but I'm sure some of my competitors would disagree with the use of MySQL.  \n\nI've developed a large Access/VBA application that has linked ODBC tables to a MySQL database.  The database is around 8GB right now and it runs flawlessly.  And when there IS a problem it's always been an MS Access problem, NOT the database.\n\nMySQL running on Linux is rock solid.  MS-SQL is good, too, but there's a price to pay (licenses).\n\nGood luck!
692198
when writting querires try using the design wizard, you could add the colums of each table and then add your criteria.\n\ne-mail me a bit more in depth of what you want to do and ill try and help you in more detail
462677
You can use Tables from MS Access or MS SQL Server Already loaded with Data
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
744551
**********************************************\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
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
167195
The previous answer is correct - however, unless we're talking about a high volume of data, I prefer to use an MS Access backend database instead - I think it's easier to maintain.\n\nHowever, as the previous respondent said, the key is finding an ISP whose platform supports your platform.
386908
What file type does Superworks save the database as?\n\nEg. Access in .mdb\n\nTry just opening the database file in Access.
950967
Basically MS-Access is for small scale industries/businesses - thats what microsoft itself is claiming. MS Access cannot handle records more than say a few thousands. I myself have experienced it - after 80000 records - MS Access really struggles. However MS SQL Server is quite capable of handling large number of records/data - so does ORACLE.\n\nFor your requirement, MS Access will be just fine.
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
1127319
we used microsoft ACCESS here at work; this program is very powerful and will help you organize, see and print information on customers or other records in a variety of forms, this is useful if you have data that you'll be inputting yourself electronically\n\nif you have a lot of paper that you want to store electronically the way to go would be to get a high-speed, high quality scanner (these can be leased) and either buy a big file server or burn the stuff to CDs
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
232872
try out this site. Has good level of information about using access databases\n\nhttp://www.fgcu.edu/support/office2000/access/\n\nhttp://www.nvcc.edu/home/dmickey/tutorial/\n\nyou can also learn a lot about access simply by reading its help files \n\nhope this helps
1036200
Yes, go for DBDesigner 4 from fabforce\n\nhttp://www.fabforce.net\n\nIt's free and very powerful
626513
You can always use MS ACCESS to generate your SQL statement and use it somewhere else.