connecting to Sql Server Express 2008 64 bit

[tgh]

Howdy,
I've developed an application in Access 2007 that uses SQL Express 2008 (32
bit) as a back end.
The Access front end and SQL backend are both local on an XP SP3 system and
work in this environment without a hitch.

I've got a new Server running Windows Server 2008 R2 Standard, and installed
SQL Server 2008 Express 64 bit with Advanced tools on the R2 server.

I detatched the project DB from the 32 bit instance and attached it to the
64 bit instance on the R2 server.

I can connect both locally and over the network to the 64 bit instance (via
OBDC), but the tables for my project database do not show up in the link
table dialog. Only the system tables are shown.

In my DATA Source, I'm using the SQL Native Client 10.0 driver, version
2007.100.2531.00.
Can anyone help me with this?

 

[AccessVandal via AccessMonster.com]

I don't have Win2008 server and SQL Express 2008 64bit so can't help much.

Have you check the user security? Do you, the current user have access to the
database? It seems like you have acccess to SQL server but not the database.