Access and SQLServer Express 2005

[BillD]

I am not experienced with SQL Server. I am testing using an Access front end
and an SQL Server backend. I installed SQLServer Express 2005 on my PC which
is running Windows 2000 Pro. I used SQL Server Migration assistant to convert
an Access Database to SQL Server. The migration process was successful. I can
use the Access front end to access the SQLServer backend tables.
Using an Access Split database with a front end and backend, I can open the
backend and see the tables and data. With the SQL Server backend, I cannot
see the data except by opening a linked table in the Access front end. Is
there an SQL Server file somewhere that I am not seeing?
With Access I can place the Backend in any folder I want and then relink the
front end to the backend database tables. Is there an SQL server file that I
could do the same with?

 

[Andrew]

I am not experienced with SQL Server. I am testing using an Access front end
and an SQL Server backend. I installed SQLServer Express 2005 on my PC which
is running Windows 2000 Pro. I used SQL Server Migration assistant to convert
an Access Database to SQL Server. The migration process was successful. Ican
use the Access front end to access the SQLServer backend tables.
Using an Access Split database with a front end and backend, I can open the
backend and see the tables and data. With the SQL Server backend, I cannot
see the data except by opening a linked table in the Access front end. Is
there an SQL Server file somewhere that I am not seeing?
With Access I can place the Backend in any folder I want and then relink the
front end to the backend database tables. Is there an SQL server file that I
could do the same with?

Hi

Sounds to me like you need to get a copy of the SQL Server Management
Studio Express.

When you install SQL Server Express edition, you only get the database
engine, not the front end to allow you to issue queries etc. However,
the Management Studio Express is also a free download, and you can get
it from here:

http://www.microsoft.com/downloads/...F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

Alternatively, do a search for SQL Server Management Studio Express
from the front page of the Microsoft website.

Regards
Andrew

 

[BillD]

Thanks for the reply. I do have a copy of the SQL Server Management Studio
Express. I can look at the tables and field names but cannot look at the
data in the fields like in an access database. Maybe I am not looking in the
area of Management studio express.

Bill D

 

[a a r o n . k e m p f]

if I were you-- I'd change to SQL 2000 and just use Access Data
Projects.

then you can move to SQL 2005 when you're ready to go into production

ADP is ten times simpler than SSMS.

-Aaron