Comments on AccessBlog.net: How to relink Access tables faster

There are good reasons to link at runtime. We have...

2011-06-08T21:42:02.137+04:00

There are good reasons to link at runtime. We have offices on WAN all over the state that run from a central file server. The offices that have low bandwith have large tables replicated in SQL Server locally. When the application runs, it determines the office and links either locally or remotely. Also, our financial applications have to link to a different SQL Server database depending on fiscal year. Therefore, one application can support multiple locations and multiple databases, reconfiguring linked tables on the fly as needed.

there is overhead in space for each time a linked table is created and deleted, so we also compact on exit.

Thanks for the tip. This will be helpful for my ap...

2010-01-26T05:20:12.414+03:00

Thanks for the tip. This will be helpful for my app at work.

@Paula, only other reason other than security, wou...

2009-12-30T21:28:23.217+03:00

@Paula, only other reason other than security, would be development speed. Updating schema information in the backend, would require manually relinking of tables, and perhaps they did this to speed up the process and left it in place by mistake.

Hi, 1-2 minutes for 155 tables - perhaps not too s...

2009-10-31T10:36:09.224+03:00

Hi,
1-2 minutes for 155 tables - perhaps not too slow, but never saw applications with such number of tables. Perhpas you can ask authors why they unlink tables and then let us know?

Alex, last year our dept purchased two proprietary...

2009-10-30T19:11:43.776+03:00

Alex, last year our dept purchased two proprietary Access databases, and they both UNLINK and RELINK upon closing/reopening. Takes a minute or so TO RELINK ON OPENING, during which time all sorts of things could happen (to my way of thinking). Never seen a database designed this way and I've developed in Access since Access2 was out. Just wondered if someone smarter than I knew why . . .
Paula

Hi Paula, never saw that somebody unlink tables up...

2009-10-30T18:52:16.264+03:00

Hi Paula,
never saw that somebody unlink tables upon closing. Only idea - security reason, so if you open database - you will not find a path to backend

Alex, do you know why some Access databases UNLINK...

2009-10-30T17:35:08.948+03:00

Alex, do you know why some Access databases UNLINK all the 155 tables upon closing, and then RELINK upon opening? What is the advantage of this? The five users enter data and run reports, nothing else. There's only one back-end with tables and some queries. So no one is relinking to another back-end of data.

Thanks for your reply!
Paula, Wisconsin, USA

Great tip!

2009-10-30T00:30:17.067+03:00

Great tip!