Regarding splitting the DB

[Kundan]

If I split the DB.I get a back end and a front end. After some time when my back end gets full I save a copy of it in another location. Now if I want to access this copy of


back end I cannot acceess it with the existing front end as that will point to the original DB. How to access the copy of the DB???

[ranman256]

are you compacting the BE before it hits the limit?

if you move the BE to another folder, (you shouldnt) then you must open the FE and relink the tables to the new location. (linked table manager)

[orange]

Here's a link to more info on splitting an MS Access database.

You could Google --relinking/linking to different MS Access backend

More info https://stackoverflow.com/questions/...rogramatically