Question

Locked

Access Database reach limited capacity

By Assiram ·
I have a database in MS Access. I splitted the database into front-end and back-end. In the back-end, all my records have attachments (PDF) which made the database reached its limited capacity (2GB) and now, i can no longer add record. My database is still growing and who knows how much the database size would grow in the coming months. I have made research about increasing the capacity of Access but it is not possible.

My questions are:

1. Is there any database which can handle large amount of records without limitations?

2. What is the easiest and best engine to migrate my database? If the best option is MySQL, I tried but I dont know how to start.


Please help. Would appreciate it very much.

This conversation is currently closed to new comments.

12 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

If you check this out

by tintoman In reply to Access Database reach lim ...

http://office.microsoft.com/en-us/access/HA100307391033.aspx
You will see that you can point your front end database at multiple back end data files and each of them can be up to 2Gb, in that case there is no limit, alternatively you could leave your PDF files out of the database and insert hyperlinks to open them from another location

Collapse -

Re: Access Database reach limited capacity

by Assiram In reply to If you check this out

Thanks for the reply.

Actually, I did this already (using hyperlinks) but the problem is, I have 3 PDF files (which by the way will come from different folders at times) attached to one record and hyperlinks allows one link only per record.

Collapse -

migrate

by yovev In reply to Access Database reach lim ...

Hi,
i'd recommend migrating to MS SQL where even the free versions have better limitations. Also Microsoft is offering good enough migration tools that can do the dirty job for you when it comes to migrate from Access to MS SQL.
At the following link you can see a comparison chart for different MS SQL Editions:
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx


However maybe there are many converters out there between MS Access and MySQL but i haven't found the right one yet.

Collapse -

Re: Migrate

by Assiram In reply to migrate

Thanks for the reply.

I already downloaded MS SQL Server 2008. I will try to convert the back-end. I guess i'll just have to figure out how.

Collapse -

MS KB article

by yovev In reply to Re: Migrate

http://support.microsoft.com/kb/237980

This is what i find useful in MS's KB. Hope it helps you out.

Collapse -

Same question worded differently

by Tony Hopkinson In reply to Access Database reach lim ...

Do you want the same answer?
Easiest solution is to replace the access back end with sql server.

Any full RDBMS will do better than Access, as I said last time though
You real problem is storing the PDFs in the database.

It's not an ideal thing to do at the best of times, but Access is truly awful with it.

Look at storing the files in a suitable directory structure and then storing a URL for them in the db. It's more work than you are doing now, but a lot less than replacing the backend.

Collapse -

Da!

by LarryD4 In reply to Same question worded diff ...

Yes the best bet is pull the pdfs out and store them somewhere else! Preferabbly in a share that can be referenced via a link! Even in a MS-SQL or MySQL setup it will be worth it.

Collapse -

Re: Same question worded differently

by Assiram In reply to Same question worded diff ...

Thanks for the reply.

Actually, I used hyperlinks but the problem is, I have 3 PDF files (which by the way will come from different folders at times) attached to one record and hyperlinks allows one link only per record.

Is SQL capable of linking 3 PDFs or 3 URLs in one record?

Collapse -

Eh ?

by Tony Hopkinson In reply to Re: Same question worded ...

If you have three pdfs in as blobs now e.g
three records or three columns, then all you need is three links in the same way.

Collapse -

three PDFs

by Assiram In reply to Eh ?

It will be a huge work but I will consider that. Thanks!

Back to Software Forum
12 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums