lidds Posted December 9, 2004 Posted December 9, 2004 I am currently writing a car valet application using MSDE. Within this application I have a default database that has all the tables created to run my application. The way I am wanting my application to work is by having seperator databases for each company that the car valet company is working for. What I have done is created a form for the car valet company to enter the company name and when they click the OK button on the form copy the default database to a new name and attach it to MSDE. The problem is that I do not know how to do this, does anyone have some sample code in vb.net that could acheive this??? Cheers Simon Quote
*Gurus* Derek Stone Posted December 10, 2004 *Gurus* Posted December 10, 2004 EXEC sp_attach_db 'foobar', 'default.mdf', 'default_log.ldf' Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.