PC Review


Reply
Thread Tools Rate Thread

Create New Database

 
 
=?Utf-8?B?TmlnZWw=?=
Guest
Posts: n/a
 
      29th Jun 2005
I have a data file lets call it data.mdb, and I have a front end data base
called forms

What I want to be able to do is automatically create a copy of the data.mdb
file called data2.mdb when I click a button on the forms database.

Is there anyway this can be coded
 
Reply With Quote
 
 
 
 
=?Utf-8?B?a2ttY2c=?=
Guest
Posts: n/a
 
      29th Jun 2005
Nigel,

Try this

Private Sub cmdBackup_Click()
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile "c:\tempfolder\data.mdb", "c:\tempfolder\data2.mdb"
Set fs = Nothing
End Sub

Ken

"Nigel" wrote:

> I have a data file lets call it data.mdb, and I have a front end data base
> called forms
>
> What I want to be able to do is automatically create a copy of the data.mdb
> file called data2.mdb when I click a button on the forms database.
>
> Is there anyway this can be coded

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CREATE DATABASE permission denied in database 'master'. ravi.govindaraju@gmail.com Microsoft ASP .NET 0 5th Apr 2007 05:10 PM
Create a link between Access Database and Pervasive Database =?Utf-8?B?TGF2YXRyZXNz?= Microsoft Access VBA Modules 1 26th Oct 2006 09:34 PM
CREATE DATABASE permission denied in database 'master' casper Microsoft ASP .NET 0 24th Apr 2006 03:41 PM
Create new database on command from existing database =?Utf-8?B?RGFyUw==?= Microsoft Access 2 18th Dec 2005 04:56 AM
HELP- trying to create a database to create Student Progress repor =?Utf-8?B?bXJzcjg0?= Microsoft Access Database Table Design 7 24th Feb 2005 07:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:07 AM.