USE MS ACCESS TO LINK TO MDF

olafurpetursson · 24 May 2017 at 20:49

I HAVE A MDF FILE THAT WAS EXTRACTED FROM A SQL SERVER DATABASE & IS COPIED TO MY LOCAL HARD DRIVE. I TRYING TO ACCESS/LINK TO THE DATA IN THE MDF FILE VIA MS ACCESS. THE MDF FILE CONTAINS 13.8 MILLION RECORDS & IS 3.5 GIG IN SIZE. WHAT DO I NEED? THERE ARE INSTRUCTIONS?

john_s · 24 May 2017 at 22:56

Doesn't Access have a 2GB file size limit?

You could try SQL Server Express instead... that has a 10GB limit I think.

PaulB · 28 May 2017 at 09:42

Instructions:

1. Turn Caps Lock off
2. Follow advice ^ from John S

Scotty123 · 28 May 2017 at 17:15

A bot?

peterwalkley · 29 May 2017 at 09:37

Scotty123 said:
A bot?

Someone from British Airways wanting help ?

izzop · 29 May 2017 at 17:49

peterwalkley said:
Someone from British Airways wanting help ?