Attach SQL database

[moolie]

Hello all.

I'm trying to create a function in an Access front end that will allow me to attach and detach database's on the hosting SQL server. Any suggestions?

 

[HitechUser]

moolie,

This maybe..

http://www.tek-tips.com/viewthread.cfm?qid=926072

or this...

http://www.tek-tips.com/viewthread.cfm?qid=859149

or this...

http://www.tek-tips.com/viewthread.cfm?qid=897633

or seach this forum... using SQL server..

Good Luck...

 

[moolie]

thanks for the responce.

I am changing my request.

I have been able to connect using a script run through osql from command line that I will activate from access no biggie.

exec sp_attach_db N'test',
@filename1 = N'C:\test\test.mdf'
@filename2 = N'C:\test\test.ldf'
go

This attached the db in sql server and calls in TEST.

Next I need to add a user login to this db and assign permissions to it.

Maybe the sql server forum would be better.