MS Access as backup database

Question

MS Access as backup database

Nuts

SSCrazy

Points: 2547
More actions
February 22, 2007 at 8:09 pm

#176089

Hi Guys
I have attached an access database to my SQL Server 2005 as a backend.
But there is a query which does not seem to be working.
I have used forms in my access database and the query is as follows
select lookup_Staff.staff_name from lookup_staff where
(((lookup_staff.team_ID) = Forms!Frm_User!txt_team)) order by Lookup_staff.staff_name

Can you guys help with that??

Thanks
Mita

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I have attached an access database to my SQL Server 2005 as a backend

Please clarify what you mean by this. SQL Server is a backend database already. Do you mean you've connected from SQL to access via a linked server?

Forms!Frm_User!txt_team

That's a reference to an open access form. I's only going to work if you're in the access front end, with that form open, and querying from there. If you're querying from anywhere else, that will not work.

Please can you clarify your situation and what you're trying to do.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Nuts SSCrazy Points: 2547 More actions · Answer 2

Hi

Basicallly I have connected SQL as back end and MS Access as Front end

This is the current situation.

Thanks

Mita

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

OK, that makes a bit more sense.

Where is that query? Within a report/form/object data source? in a stored proc?

What's the error that you get?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

It's the data source for a form? Is it set as a pass-through query?

What error are you getting?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

I haven't worked with Access for several years, but if I recall, those queries should be executed client side, not server-side.

Can you please post the exact error, that way maybe I can see where it's coming from (access or sql)

Is it a passthrough query?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass