Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ameetkeskar
Starting Member
8 Posts |
 Posted - 2006-12-05 : 05:11:54
|
| friends,i am using accessas a database for my application and found that the mdb file size bloats up everytime you do transaction on the same. But also found that when my mdb file size reached 638 MB the bloating up of size stopped automatically. Now even when i add records to it the file size doesnt bloat up. Is there any limit that you can set to the file size which is getting set at this size. if you know anything regarding this, please let me know. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-05 : 05:14:52
|
| Deleted records are not actually deleted in access. The records are merely marked as "deleted" and still occupies space.But the limit if 638 mb? I don't know.Peter LarssonHelsingborg, Sweden |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-05 : 17:30:46
|
| And if you have an mdb file that is 638MB in size you should move to SQL Server asap, use SQL Server 2005 Express - its free and you can still use Access for the front end. |
|
|
|
ameetkeskar
Starting Member
8 Posts |
Posted - 2006-12-08 : 09:15:07
|
| can i connect to SQL Express using Access and use the query tool to get results? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-08 : 10:51:38
|
| Yes you can, there are some issues, but nothing you can't work around. Here is some info from http://blogs.msdn.com/sqlexpress/"Access 2003 already supports using SQL Express, no patching required. There are a couple known issues when paring these two products: · The SQL designers in Access 2003 do not work against SQL 2005. This is true for Access, Visual Studio 2003 and any other product that uses the VS designers from the 2003 product line. You can still use the text based designers in Access 2003 or you can use Management Studio Express, which can be downloaded free of charge from the download link above.· Access 2003 does not understand the new User-Schema separation implemented in SQL Server 2005. Databases migrated from SQL Server 2000 to SQL Server 2005 will still work as expected. You should have no problems working with new database in SQL Server 2005 as long as you don't use User-Schema separation.· Access 2003 doesn't know about the new SQL Server 2005 data types. In my experience, the new types are shown as Memo when part of a Linked Table" |
|
|
|
|
|
|
mdb file size