RE: Multiple Access and ODBC connections

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Look up "Startup command line options" in Access Help you can create a short
cut and either pass a "command" or the name of a macro to execute to access.
So using the "Development" shortcut runs the code to link to the Test DBs,
and using the "Production" Shortcut runs the code to link to the Production
DBs.


--
-Steve


"Macsmasher" wrote:

Hi all,

We're running Access 2003, SQL 2005.

We have internal Access front-end apps that are distributed only within our
network. All workstations have the same network path, so there is no need
for linking tables at the client end. What I need to do is put together
something for our developers where we can change from our test server to live
server when we deploy a new release. Of course I've programmatically done
this with DAO in the past to a single Access back-end. And I can find code
to re-link to SQL server via ODBC. But I’m not quite sure how to put
together a solution for our needs. Here are some specifics...

We are linked to test SQL and Access DBs, and developers change the links to
live SQL and Access DBs right before deployment. Client never needs to link
tables.

We have multiple Access back-ends, but not all need to be re-linked. IOW,
we have some common lookup tables that always live on the live server even
when we're linked to test data.

We use ODBC connections to SQL using Windows username and password. Only
one server is used for test, and one used for live.

I'm thinking it would be best to have a table in the front-end with link
strings and a field to designate the connection as Test or Live. We would
have a drop-down on our developer admin form to select Test or Live, then run
the re-link procedure with a cmd button.

Anyway, thanks in advance for any input.
.

Relevant Pages

  • Updating DB with values depending on Key Value
    ... I have worked with DTS before, but usually just to import Access dbs to SQL ... I need to get this data into an existing table on the SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: Security - give developers read access to prod DBs
    ... > We have a test SQL 2000 server where most developers have their own SQL ... > databases on the prod SQL instance where all development databases are ...
    (microsoft.public.sqlserver.server)
  • Re: MS JDBC Rowset size doubled ?
    ... Bob Horkay wrote: ... > The developers claim they are not adding the asterisk and that SQL ... > Server is. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: WHERE 1=2 with performance nightmares
    ... Application server enabling technology for developers ... WHERE clause in our sql. ... Has that turned on some kind of server setting that cause all ...
    (borland.public.delphi.non-technical)
  • Re: Whats My Password?
    ... When using any instance of SQL Server you can access it via the network ... the database on my computer. ... My book is predominantly for Visual Studio/SQL Server ... developers as it discusses issues that all architectures are likely to see ...
    (microsoft.public.dotnet.framework.adonet)