Did you make certain that, up at the server level in 2005, you authorized whatever Windows groups or users you had authorized in 2000?

Although the users or groups are recreated...

Hyperlinks can be stored as plain text in a varchar or nvarchar field in SQL Server.  Your interface (access, asp, vb, whatever) will provide a control that you put on...

Open your table in design view.  Click on the name of the field you want to index.  Look near the bottom and select the kind of index you want (not...

I think that the answer is actually pretty easy these days:  Use MDB.

ADP's, although they can use SQL Server 2005 data, do not allow you to make any table changes,...

Kevin - Thanks for the detailed reply.  It's a great checklist to keep handy.

You can't add columns to a linked table through the MDB interface.

You can issue DDL SQL using the ADODB.CONNECTION object. 

    Dim myconn As New ADODB.Connection

    With myconn

        .ConnectionString =...

Actually, ADP's seem to be on their way out.  Look around the web, comp.databases.ms-access (newgroup) for example, and you will see sad comments that ADP's are no longer even recommended...

As long as the library is installed, you should be able to go into a module, then select Tools, then References, locate the SQLDMO library in the popup dialog box,...

How about looking in some PHP forums, such as :

http://www.phpfreaks.com/tutorials/61/0.php (Microsoft Access Database ODBC and PHP)

http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/163447  (Title: Microsoft Access Database Connectivity (DSN-Less) )

http://www.phpbuilder.com/columns/siddarth20000228.php3  (Interfacing With MS Access 97+)

Any joy...

Sounds like you don't have the SQLDMO library (dll file) on your computer.   Mine is here:

C:\Program Files\Microsoft SQL Server\80\Tools\binn\SQLDMO.DLL

Within Access you can check by opening a module, then clicking Tools,...

While we're at it, start here:

http://www.sqlservercentral.com/search/turbo.asp

In the search textbox, just type shrinkdatabase and you'll find a couple of articles and quite a few discussions.

There's not a one-button equivalent, but check out these topics:

dbcc shrinkdatabase

dbcc shrinkfile

backup (study LOG and NO_TRUNCATE options)

These will get you started.  Our dba sets up our official backups, so I'm...

If you know how to handle CURSORs in SQL Servers it's no problem.

Suggestion:  Instead of doing the fanciest approach, there's another kind of elegant.  Unless the tables you need to...

I don't know anything about putting an Access MDB on a unix share, so I'd have to put it on a Windows share first, get it working there to be...

There are lots of variables here.  Start with this: What are you referring to in the dlookup expression to get the value of the employee number? 

--If you are referring...