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
 SQL Server Administration (2005)
 access frontend

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2007-03-05 : 04:29:59
hi can you help me?

i need to make an access frontend to read specific queries from my sql server 2005 express backend.

how can i do this?

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2007-03-05 : 12:57:38
Esther, If I understood you correctly. what you are saying is you want to use Access front end to get data from a backend SQL2005Express edition.
If the queries are straight forward, Access lets you build queries online. if they are complex and dynamic, you may have to resort to VBA. It is a pain but works almost the same way as your .asp page.
Go to Top of Page

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2007-03-05 : 13:28:03
yes i want to use access frontend so that my client (who has used access until now) can browse teh table and see what it is them?

how can this be doen and what would the connection be?
Go to Top of Page
   

- Advertisement -