Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-07-2008, 08:59 AM   #1
Somebody
Registered User
 
Join Date: Apr 2008
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Somebody is on a distinguished road
Create a new .mdb with vba

hi

is there a command or function that i can use to create a new database (.mdb) to a location that would be entered by a user

I essentialy want to be able create a back-end and put tables in it
i dont have a problem with coping table in a database but i cant create one with nothing in it

Thanks in advance

Somebody is offline   Reply With Quote
Old 07-07-2008, 09:17 AM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Dim dbNew As DAO.Database
Set dbNew = CreateDatabase("YourPath" & "YourDBname", dbLangGeneral)
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a DSN using VBA (or VBS) Guus2005 Modules & VBA 0 11-07-2007 04:43 AM
Create VIEW from SQL Query on a TABLE using VBA surferxx Queries 2 11-28-2006 04:58 PM
Create an mdb file using VBA? servoss Modules & VBA 4 11-13-2006 03:02 PM
[SOLVED] Create a txt file and modifiying it...using vba krishna Modules & VBA 0 12-06-2005 10:25 PM
Create Excel Worksheet thru Access VBA mays0515 Modules & VBA 3 06-09-2004 09:47 PM




All times are GMT -8. The time now is 02:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World