Re: ODBC and Access

Yes. Create a new mdb and import the forms/reports. In the forms mdb,
link the tables. When it's working, go to the mdb that has everything
and delete the forms/reports. But first, make a backup :-)

--Mary

On Thu, 16 Mar 2006 09:03:05 -0800, AlexP
<AlexP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Yes, I have the UI. I guess I should separate it in Second DB. How do I
connect the UI from Second DB with the tables in the First DB? Should I use
linked tables?

-Alex

"Mary Chipman [MSFT]" wrote:

What does "open in Access on a PC" mean? If that means that you have
UI elements (forms, queries, reports, etc) open in the same mdb that
other connections are using, then don't do that. Separate your UI
elements into a separate mdb so that only tables are in the main mdb
file.

--Mary

On Thu, 9 Mar 2006 08:44:43 -0800, AlexP
<AlexP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am running ODBC connections from LAN to a MS Access database. The speed is
normal, but when the Database is open in MS Access on a PC (particularly with
Win XP) then the other ODBCs are very slow. Any experience, suggestions?

Thanks, Alex

.

Relevant Pages

  • Re: Modify Forms in Separate MDB
    ... expect to lose the compiled state of the MDB. ... Compile the application to an MDE ... >> What I would like to do have users open a separate MDB ...
    (microsoft.public.access.modulesdaovba)
  • Re: Linking Tables
    ... "Jim Pockmire" wrote in ... > separate mdb which would only be opened as necessary. ... clerks, one for sales admin, one for customer relations, one for stores and ...
    (microsoft.public.access.modulesdaovba)
  • Re: ODBC and Access
    ... UI elements (forms, queries, reports, etc) open in the same mdb that ... elements into a separate mdb so that only tables are in the main mdb ...
    (microsoft.public.data.odbc)