I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA.
Can someone tell me how to do this or tell me about some tutorial for this?
If you are just using Access as a front end to MSSQL i would recommend creating an Access Project (adp). In Access you select new from the file menu and chose "Project using existing data...".