Access 2003 and SQL Express

Is there a way to integrate Access 2003 as the Front End for SQL Express?

I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow.

As you can see, I am totally new to SQL and any help would be appreciated.

Thank You,

James

The default login/password would probably be sa, with an empty password. That's generally what SQL Server uses before it's changed by the end user.

|||Create an ODBC connection using administrative tools, and then connect to it from ACCESS.|||Where can I find the appropraite adminstrative tools?|||

Run the following from DOS:

%SystemRoot%\system32\odbcad32.exe

This creates ODBC connections. Administrative tools gives you access features of the OS to meddle with, important if you are a programmer. I would suggest you get familiar with them, although I believe you need to be an administrator to access them. To add the shortcut to the Start Menu\All Programs menu

Right Click on taskbar\ start menu:

Properties>Start Menu Tab>Customize>Advanced Tab

Also, you have access to a full range of management utilites from mmc.exe. Run this, then add the appropriate snap ins.

Check out this link from MS:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/app_misc_pr_load_snapin.mspx

HTH

|||

Thanks a lot for the help. Defintely helped out a lot!