How To: Re-link an Access DB front-end to a backend
NOTE: Depreciated. No more access DBs
To link a front-end database to a back-end database, follow these steps:
- Create a new, blank Access database. This will be your new front-end database.
- On the File menu, point to Get External Data, and then click Link Tables.
- Navigate to the folder containing the back-end database you want to link, and select the back-end database.
- On the Tables tab, click Select All and then click OK.
- On the File menu, point to Get External Data, and then click Import.
- Select your old front-end database, and then click Import.
- On the Forms tab, click Select All. Repeat this step on all tabs except the Tables tab. Because you have already linked to the tables, you now only need to import the rest of the objects.
- After you have selected all the objects except for tables, click OK.
- You can now delete your old front-end database and rename the database you just created to reflect that it is now your front-end database.
CategoryITDefunct
