Hi,

I've checked the planning account and it's not orphaned, has the role db_datareader and has permissions for all tables.

As I've mentioned before I have the same problem if I configure...

Hi,

Here's what I've done.

The following was done on an XP (32bit SP3) machine.

I deleted all existing system DSNs.

Clicked Start, Control Panel, Administrative Tools.

Double clicked Data Sources (ODBC).

On the ODBC Data...

Hi,

I've checked the DSN settings and it's using the correct SQL user account and points to the correct database.

None of the tables/views show up regardless of whether I attempt to...

Hi,

I agree that it shouldn't be that hard, but it is.

I have configured the DSN to use the SQL Server Account which worked fine with 'Microsoft SQL Server Management Studio...

Hi,

I don't have any client machines (all Win XP) which are able to see the list of tables/views on the SQL 2000 server over an ODBC connection.

I can see the...

Hi,

The planning DSN was listed under the System DSN tab.

The authentication was (and still is) set to SQL Server Authentication.

The default database was 'greyed out' and set to planning.

When I...

Hi,

In the blank MS Access database I've created the MSysObjects table contains the default 17rows, none of which have a value in the Connect column.

I'm unable to link/import any tables...

Hi,

I've tried using the 'sa' login and another login which had been working fine for years. The permissions for the other login are:

public

db_ddladmin

db_datareader

db_datawriter

I can access the data via ODBC assuming...

Hi,

The default database is set by the SQL server user login to our 'planning' database.

I've also manually set the database to 'planning' in the ODBC connection but still no SQL...