Multiple Backend DBs

[dkuykendall]

I have a business application that uses a Frontend / backend setup. I would like to be able to have more than one backend and be able to have my customers switch between the backends (different business locations) I have the DB set up to relink to the backend but as long as the backend is functional it will not allow you to switch to a new or different backend.

Any suggestion?

Thanks
Don Kuykendall

 

[JonH]

Are you querying via SQL or using queries direct from an mde?

 

[dkuykendall]

The application is a mdb. but with all menus etc turned off. and it is run in the runtime mode.

 

[JonH]

Using SQL you can access another mdb e.g.

Dim dbs As Database
Dim rst As Recordset

Set Db = OpenDatabase("U:\My_Database.mdb")
Set rst = Db.OpenRecordset("SELECT * FROM tblPost")

This puts the query results into rst

I don't know of a way other than this I'm sorry.

Jon.