Found this in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect

...does that control the list?

"Bob...needs to use the same objects from the same application except for the Vacation table" so - Yes, I agree that you DENY him the vacation table, but the answer...

I don't agree with the official answer - it doesn't give Bob permission to the tables used by the Data Entry group.

1. Put your backup file in the sql backup folder, usually:

C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\

2. In EM, right-click on Databases, then click New database... and give it a name

3. Right-click on...

The sad fact is that Access does not support exporting directly from a sql pass-thru query into Excel. Not even in version 2003. You need to create another Access query...

Hello Antony,

I would use a stored procedure, because you are only using Access as a container to hold the forms & reports etc. Which means that the less you have...

Check out the Microsoft SQL Server 2005 Developer's Guide from McGraw-Hill Osborne 

 http://www.wvmitchell.com/library/details/1512.html

That is how dbf's work, you specify only the folder in ODBC.

That's because in the dBase world, each table and index is a separate file on the disk; the folder is...

The best book for somebody with your background:

Microsoft Access Developer's Guide to SQL Server, by Chipman and Baron, published by Sams. . .

http://www.wvmitchell.com/library/details/243.html

A .dbf file is usually a dBase file, that is not a text file format. You should select either dBASE III, IV or V -or- the MS dBase-VFP Driver.

Go to...

Yes, that is possible. . .if your security file is named Security.mdw, add this to the command-line or shortcut:

/wrkgrp Security.mdw

Did you set a password for the Admin user?

Dick, I don't think that will work any more with service pack 3 - you can't grant permission to truncate from within an sp.

Add these 3 lines to your asp code to get the data path:

Set fso = Server.CreateObject("Scripting.FileSystemObject")

Full_ASP_FILE_PATH = Server.mapPath(Request.ServerVariables("PATH_INFO"))

PATH_ONLY = fso.getParentFolderName(Full_ASP_FILE_PATH)

We set the margins to 0" all around, and then set the Acrobat print setup for "shrink large pages". Still using RS SP1. Users are told that html is for...