Access a database from another file location via a form (instead of table link)?

[jssiadmin]

Is it possible to access a database from another file location via a form, instead of table link? I have a multitude of databases I need to link to one another in a method that is user friendly and controlled by the switchboard form.

[ranman256]

you could have user select the DB from a combo,
then it would relink the tables to that chosen db.
then run normal operations.

[kd2017]

Maybe this is what you're looking for? https://www.youtube.com/watch?v=0Qi_...&index=21&t=0s

[CJ_London]

do you mean the whole database or just one table? If the latter, you can use something like this as the recordsource to your form

SELECT *
FROM sometable IN 'C:\otherdbname.accdb'

[jssiadmin]

Thanks for the replies guys.

@kd2017: Not particularly but I can scour his channel for it.

@Ajax: The whole database, yes. I've got multiple database files, which are connected to my console databases (form/record making), and I am trying to connect those consoles to an uberconsole that can access the entire database.


I hope I'm making sense here. Not sure if it's even possible, but there must be some way of accessing the entire database from one console/file.

[CJ_London]

really depends what you mean by 'access a database'. And what you want to do once you've accessed it. And whether the databases are identical in terms of tables/field names etc

Databases are data - i.e. tables. Are you saying you want to access the queries/forms/reports etc as well?

Just another guess - look at the vba opendatabase command. Also consider using the msysobjects table to determine what the database contains

whatever you do will require code.