sql frontend to access backend

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

sql frontend to access backend

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-08-02 : 04:32:22

I know this is not the best way to do it but I need temporarily to make my sql table a frontend to an access backend?

is this possible?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-02 : 11:16:22

Do you mean you need to query access data from sql server? perhaps you can create a view which selects using OPENQUEERY.

Search for it here - lots of topics including this one:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124072&SearchTerms=openquery,access

Be One with the Optimizer
TG

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-08-02 : 12:16:43

thanks - that's just what I needed

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-08-04 : 04:13:59

this worked and when I query it in sql I see all the records but when I run the same query from my vb application it doesn't return any? do you know why?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources