How are you connecting to SQL Server? Through ODBC or with an ADP? If you've
upsized and are using ODBC, you should still be able to use Access queries.
Here's a page that might help:
http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx
Also, there's an excellent book that covers the whole topic:
http://www.amazon.com/Microsoft-Access-Developers-Guide-SQL-Server/dp/0672319446/sr=8-1/qid=1157154528/ref=sr_1_1/002-3334837-9911242?ie=UTF8&s=books
Hope this helps,
Barry
"Zack Godula" wrote:
[Quoted Text] > My database was just moved onto an SQL server, and I have very little
> experience with SQL servers. Before the switch, I used combo boxes on a form
> to narrow data in a query. These combo boxes could be changed by the user,
> and they could then view a report based on their selections in the combo
> boxes. Since the database has been moved to the SQL server, the queries that
> used the combo boxes for criteria have been lost. When I tried to re-create
> the queries in a view or stored procedure it would not return any records
> based on the combo boxes. A link to an informative web-site or any help
> would be greatly appreciated. Thank you in advance.
|