View Single Post
  #13  
Old April 9th, 2007, 01:06 AM posted to microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default Persistanct connections

Hi John,

Yes, the Switchboard Manager wizard does create a local table. However, this
table is moved to the back-end file as soon as you use the database splitter
wizard. You would have to specifically import the table back into the FE
database, and there would be very little benefit of doing so--this table is
typically so small that a table scan (ie. transferring all records over the
network wire from this table) is really no big deal.

On the other hand, if you use the Switchboard Manager wizard *after*
splitting your database, then, yes, it would create a local table. I would
think that most of the development work would be done before splitting. In
that case, you'd want to import the new Switchboard Items table from your FE
database into your BE database, delete the copy in the FE database, and then
establish a linked table as usual.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"John W. Vinson" wrote:

Bound to a *local*, not a backend table, though; isn't it? Or is this
different in 2007?

John W. Vinson [MVP]