Access multiple record source

[SSharp]

I have a need to assign a record source to an Access form (for display only) to a stored proc that is one a different server and different database that is linked to the Access database.

[ItsMe]

What happens when you use the wizard to build a Test form and assign the table/query of your choice to the
Test form?

[SSharp]

I'm sorry, I was on a conference call while typing request.
I will try to do a better job of explaining.

For example purposes I will refer to the servers and dbs with aliases.

The Access database is linked to a SQL db (call it DB1) which resides on a server (call it ServerA).
The question is "Can I create a simple inquiry form that has a record source from a stored procedure that is querying data from a SQL db (call it DB2) that resides on ServerB.

[ItsMe]

Newer versions of Access can do some calculations at this level when they act as a BE. I am still trying to comprehend when and where this is a benefit though.

As for SQL server, I do not know what it is capable of. If I were to venture a guess I would say you would be better off looking for another option.

I have been successful with OBDC connections in accomplishing tasks in the past. Your situation may have some nuances that are making this a little more complex though. Why can't you have the procedures run in runtime on the client? What hurdles are you facing?

Not sure I have an answer but I am curious at the least.