Search results for query: *

This code will get you the vendors who have alphabetical names between 'Jones Supply' and 'Smith_Sales' declare @BeginVendor varchar(30), @EndVendor varchar(30) set @BeginVendor = 'Jones Supply' set @EndVendor = 'Smith_Sales' Select Vendor_name from Vendors where Vendor_name between...

Create a DTS package. First open up a connection with the Microsoft OLE DB Provider for SQL Server. Login to the SQL server with windows authentication or SQL Server authentication, which ever is appropriate. Then select the database you need to connect to. Next make a connection to Microsoft...

JEDEL I pulled this code out of an application of mine that is currently in production. It includes a class called clsDataBase and a sub routine that will pull data from a client database through the class. I hope the following code helps. 'This a class I call clsDataBase Option Explicit...

Check out the upsizing wizard that comes with access 97

Open Enterprise Manager Right click on the server and select "Properties" Click on the database settings tab of the dialog window At the bottom of the dialog window either enter the new location or click on the elipsis to the right and set the path Hope this helps Gary