Link Two Database - Is it possible?

[aamer]

Hello,

I want to know is it possible to link 2 database
I am having a problem because my database size has exceeded the limit of 2 GB
let me explain my exact problem

I store documents as attachments with transactions in a table (I do not want to store those documents separately in a folder and give a link)
I want to create a separate database which is linked with main database where only the attachments will be stored which are linked to the transactions made in main database.

Is this possible to do?


If so, can I be guided how can I do that.

[June7]

Yes, you can do that.

Make a copy of your current db. Delete what you don't need in each.
Use External Data utility to set link in the primary db to table with attachments in other db.

How long did it take you to fill up the 2GB? Have you run Compact and Repair?

[orange]

I do not want to store those documents separately in a folder and give a link

Why exactly?

[Homegrownandy]

second time I've come across attachments in one day haha.

Just as a note: you don't have to provide that link to the attachment. The link can be generated via VBA and assigned to a button for that record. As far as the user knows it could be stored on the DB or anywhere.

[aamer]

so that all record is in one file

[aamer]

Can I be pointed from where I can download a sample db for better understanding how it could be done

[June7]

Common topic, search forum or keywords "image control".

Here is one https://www.accessforums.net/showthread.php?t=65686