your view also has the dbo prefix?

nice that you backup all database in case the hardware breaks (we had one by a defect harddisk shortcircuiting the san-backplane)

you could use the nolock hint

I don't know for sure but I thought there was a lengthlimit for the name of the primary key.

You could also try to remove the statistics and see what happens.

Is the system dsn installed on the other machines with the same name?

How does your connectionstring looks like?

Perhaps it doesn't display hidden tables.

Extra->options->Display->Hidden objects

Never done the conversion myself but from

http://www.dbforums.com/archive/index.php/t-947624.html

it should be

Well, the good news is I finally figured it out. Quite a switch from the old DAO methods, but I guess...

Are the awe parameters setup correctly? (windows)

Have you set the memory for sql server to a fixed size (min & max)?

Sql server also needs the rights to lock pages in...

You can use ODBC linked tables in the mdb files as a short term workaround.

There could be some change of behaviour in record locking ...

Also have a look at

http://www.sqlservercentral.com/Forums/Topic247770-131-1.aspx

where...

Business Intelligence. Trying to get more usefull information out of your data.

Not that I'm aware of. Maybe if you make a new class (Querydef2) of it.

I would run it on the databases mentioned

in [Contributions]

and those mentioned in [SLXReporting].[dbo].[vw_SLX_ADDRESS],[SLXReporting].[dbo].[vw_SLX_ACCOUNT]

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

General network error. Check your network documentation.

is usually a sign of database corruption.

4-6 terabyte is quite large, but it mostly depends on business requirements. (response, recovery, load, ...)

As you are new to the area, can you contact a consultant?

You might look up...

Recordcount Ado:

Note: This property will return -1 for a forward-only cursor; the actual count for a static or keyset cursor; and -1 or the actual count for a dynamic cursor....