Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help Is there any way to increase size of access mdb 1
- Thread starter sasha101
- Start date
-
1
- #2
That's mighty big for Access. Have you compacted this lately?
You could split the db if you haven't already done this. Also you may consider moving some tables to a multiple dbs. The tables could be then linking to the front end.
HTH
RDH
Ricky Hicks
rdhicks@mindspring.com
You could split the db if you haven't already done this. Also you may consider moving some tables to a multiple dbs. The tables could be then linking to the front end.
HTH
RDH
Ricky Hicks
rdhicks@mindspring.com
Remember Access was not designed for high volume industrial size work. I recall seeing an article from Microsoft or MSDN that defined the three database products: Access, FoxPro and SQL Server. This article went on the describe the metrics that should be applied when deciding up a DBMS. I tried to search the site a few minutes ago to no avail. Perhaps u can look... Steve Medvid
Atlas Commerce ("ebusiness evolved"
Atlas Commerce ("ebusiness evolved"
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
i would recommend the link-table method....that should keep it happy for quite some time, involves no sql & you should be able to convert it fairly easily (assuming it is not a flat table db).
- Status
Similar threads
- Locked
- Question
- Locked
- Question