Ms access

Basically I am a Oracle guy. Now I am developping some form in SQL server. I wana use SQL DB as back end and access as front end. I wanna all the tables in SQL server not as the Access DB. Is it possible.
I do not have knowledge of VB or VB script
What should I do? Please helpIn Access, select File, New, from the menu and choose to create a Project with either a new or existing database. A wizard will guide you through establishing a connetion with your SQL database, and you can even perform some administrative functions from Access ala Enterprise Manager. This means you will need to be carefull that you don't unintentionally alter your SQL database, and that you will need to lock down your final Access file so that users don't mess with your database.
The Access file will have a .adp extenstion (Access Data Project).|||[thanks mate it works|||No worries. G'day!
;)

Moving Log Files

I have inherited a SQL Server environment that was haphazardly installed and managed. I am in the process of trying to apply some form of structure to this environment. Currently all data and log files reside in the default data directory. I am moving the
log files to a separate directory on a different drive. I know I can use sp_detach_db and sp_attach_db to move the log files, but how can I move the log files for master, msdb, model, and tempdb?
Any help would be greatly appreciated.
http://www.databasejournal.com/featu...le.php/3379901
|||Erik,
Thanks for the reply. This was exactly what I was looking for.
"erik perez" wrote:

> http://www.databasejournal.com/featu...le.php/3379901
>

Moving Log Files

I have inherited a SQL Server environment that was haphazardly installed and
managed. I am in the process of trying to apply some form of structure to t
his environment. Currently all data and log files reside in the default data
directory. I am moving the
log files to a separate directory on a different drive. I know I can use sp_
detach_db and sp_attach_db to move the log files, but how can I move the log
files for master, msdb, model, and tempdb?
Any help would be greatly appreciated.http://www.databasejournal.com/feat...cle.php/3379901|||Erik,
Thanks for the reply. This was exactly what I was looking for.
"erik perez" wrote:

> http://www.databasejournal.com/feat...cle.php/3379901
>