Opening multiple mdbs

From: Tcs (tsmith_at_eastpointcityNoSpamorg)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 13:09:00 -0400

As I understand it, when designing a multi-user app with MS Access, one should
use an Access front-end (FE) for the code, and an Access back-end (BE) for the
data.

Question: How does one open the BE? With a connection string using ODBC?

I also understand, that under certain circumstances, it may be desirable to use
another mdb for a large quantity of temporary data.

Question: Same as above. Plus, can I have BOTH open at the same time? If so,
how?

Why do I ask? Because I can't seem to do either. I HAD been able to create my
"temp" mdb, but could never create the necessary table(s). NOW I can't even
create it. I would HOPE it's something simple that I'm missing, but at this
point...

Any help is greatly appreciated. Thanks in advance,

Tom

Relevant Pages

  • Re: Multiple MDB files???
    ... Your advice is absolutely wrong, if you care about the data. ... BTW we have 27 back end mdb files. ... >> I have a databse with an Access front-end on everyone's individual PC ... >> more sense to create multiple back-end data files or if just one would be ...
    (microsoft.public.access.tablesdbdesign)
  • User-defined functions
    ... I'm a very new learner in SQL Server 2000 now - Can I link to user-defined ... functions for an Access front-end .mdb just as with SQL Server Views? ... that functions are used with Access projects, ...
    (microsoft.public.sqlserver.programming)
  • Re: Speed of SQL Authenication vs. Trusted Connection
    ... Just wanted to post our findings here to maybe help others. ... issue with the Access front-end. ... Created a new mdb, file, import, ... sql authenication is as fast as trusted connection. ...
    (microsoft.public.sqlserver.security)