Convert MS Access 2000 to SQL Server 2000 1

[toekneel]

I've been working at converting a database from MS Access 2000 into a SQL Server 2000 (back end)- Microsoft Access Project (front end). Does anyone have any clues about where to look for the best help? I've been digging through MS Knowledge Base and made VERY slow progress. Seems like for every step I need to take, it takes a ton of research just to find out how to hurdle my next step.

Here's a sample of current steps that are causing problems:

1) Conversion of action queries in Access into SQL Server. I've been able to set these up as Stored Procedures, but having problems getting them to run from the front end. I've tried running them by calling them in macros, but they always present an error message with the good old "halt" screen, even after they successfully run.

2) I have several forms that call up other forms (not subforms due to necessity in most cases) where I could easily open the forms by using parameters within MS Access. I'm not able to run the underlying parameterized queries in SQL Server.

Seems like every time I clear one hurdle, I come to another, so I'd love to find a site (or even a forum) devoted to this whole process!

Tony

 

[tlbroadbent]

Check this page for lots of information about integrating SQL Server and Access.

http://msdn.microsoft.com/library/en-us/dnacc97/html/acsqlres.asp

You'll want to pay special attention to these links.

http://msdn.microsoft.com/library/en-us/dnacc97/html/acsqlres.asp?frame=true#acsqlres_upsize

http://www.ssw.com.au/ssw/UpsizingPRO/frmLinks.htm

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm