Change MDB path for mde front-end

[linmatt]

Is it possible to change the path of a backend database in a front-end in Access 2000? I need to move the back-end onto a new server but don't want to have to replace all the client front-ends. Is the path a registry entry or in a config file somewhere or is it in the dark vault of Microsoft's hidden files somewhere in another dimension?

Clients are a mix of W98 and 2000, the server is NT4 moving to a Windows 2000 server.

Many thanks in advance

Matt

 

[mp9]

When you attach files (as you do in front-end/back-end set-ups) Access stores connection details in a hidden table called MSysObjects (try

SELECT [Name], [Database] FROM MSysObjects WHERE TYPE=6;

to see this).

I may be wrong (if I am, someone is bound to tell me), but I'm not sure you can modify these values programmatically or using SQL.

What you can do is use VBA to delete the existing connections and then reattach to the new location. Then use an AutoExec macro (or similar) to get your user's to run this VBA script the next time they log in, to update their front-ends.

HTH

http://www22.brinkster.com/accessory/

 

[linmatt]

Thanks for the reply...

All I get is a blank query table if I run the query. I'm not up on Access VBA very much so I'd appreciate some help with that. I use it with Excel mostly.

Matt

 

[JeremyNYC]

If you're worried about replacing the front end on every user's workstation, you're probably not using an automated method of rolling out new front ends. You can set it up so that you don't have to touch a single PC to get the new front end onto everyone's machine.

I've got a write up on deploying databases on the developers' section of my website that details how to go about this.

There will always be things like this that come up, and updates that need to be made to the front end. There are several methods for doing what I document in that write-up, but I highly suggest you use one of them. It'll save you a lot of stress.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.