CODEWITHSUNDEEP
ms-accessvbams-access-2007
Darryl Lobo
Darryl Lobo

Reputation: 165

Splitting Access Databases

I have an access database that I have been using for a while. I have been meaning to split the database for a while but hesitant to. I have many forms that link to tables. VBA code that aid in the forms and creating reports from this access database. Sometimes the VBA code will have a dynamic query that changes on certain conditions and runs a DoCmd.RunSQL.

If I split the database will all my VBA code break down as it points to the tables within my database. Do they need to be pointed to the backend or pointing towards the linked table is enough. Will the split handle this by itself?

Let me know If I was clear enough. My main concern is my forms/VBA code will stop working.

Upvotes: 0

Views: 210

Answers (1)

Gustav
Gustav

Reputation: 56026

Make a backup, go to meny Database Tools, locate the Split database wizard.

Run this, and you are done.

Upvotes: 2

Related Questions