Last active: Never
Not logged in [
Login
-
Register
]
Search
Today's Posts
Stats
Back to: EJukebox Home at Audiosoft.Net
Audiosoft Forums
»
Requested Features
»
Larger DB 2GB to small
» Edit Post
Edit Post
Username
Need to register?
Password:
Forgot password?
Subject:
Icon:
Formatting Mode:
Normal
Advanced
Help
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Tahoma
Times New Roman
Trebuchet MS
Script MT Bold
Stencil
Verdana
Lucida Console
-2
-1
1
2
3
4
5
6
White
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
HTML is Off
Smilies are On
BB Code
is On
[img] Code is On
What is the maximize size of an Access database and what options do I have if I reach this limit? (eJukebox current DB format) The maximum size of an Access database is two (2) gigabytes. For Access databases that have reached this limit, you have a number of options. One option would be to split the frontend database (forms and reports) from the backend database (tables and queries). This is called a split database. You can then link more than one backend database to the front end database with each backend database having a size limit of 2 gigabytes. A second option when the size limit has been reached is upsize the backend database (tables and quieries) to SQL Server. This is called upsizing the database. There is a free version of SQL Server that you can use (the version depends on your version of Access) which has a size limitation of between 4 GB and 10 GB. SQL Server 2005 Express has a size limitation of 4 GB while SQL Server 2008 R2 Express and SQL Server 2012 Express have a size limitation of 10 GB. There are tools available for facilitating the transfer of tables and data to SQL Server. These tools greatly reduce the amount of time necessary for migrating from an Access database to a SQL Server database. Because SQL Server does not have any direct form building capabilities you will still need Microsoft Access or another form building platform (Microsoft .NET Windows forms, ASP.NET web forms, etc.) to display and edit the SQL Server data.
Disable Smilies?
Use signature?
Turn BBCode off?
! Delete this message !
Attachment:
Audiosoft Forums
»
Requested Features
»
Larger DB 2GB to small
» Edit Post
Audiosoft Home
|
Download EJukebox for Windows
|
Register EJukebox
©2019
Audiosoft Network
. All rights reserved.
[queries:
17
]
HTML5 Color Picker for CSS Opacity
Short Url Service with Stats