all groups > sql server msde > october 2007 >
You're in the

sql server msde

group:

view MSDE with access


view MSDE with access Spechty
10/4/2007 1:04:00 PM
sql server msde:
I am logging ISA to MSDE. it creates a new mdf, and ldf each day.

I would like to create an Access front end to view each day.

Re: view MSDE with access Norman Yuan
10/4/2007 4:26:38 PM
Creating *.mdf and *.ldf each day? each pair of *.mdf/*.ldf is an SQL Server
database. and you do not access the files directly. With Access, you can use
ADP format to connect to a dtabase on MSDE:

1. Start Access.
2. ccreate a new ADP file, choosing to use existing database.
3. In "data Link properties" dialog box, specify MSDE server name, databse
name and login info (if you logged onto the box where MSDE runs as local
admin, you simply select "Windows Integrated Security"

[quoted text, click to view]
AddThis Social Bookmark Button