943,879 Members | Top Members by Rank

Ad:
Dec 1st, 2007
0

How to determine the availability of database file

Expand Post »
Greetings!

" Visual Basic 6 Program"

I want to open the database file base on the given filename. If the database file is present all data that i want to save will be save in this database. Else, if the database is not present it will create new database to save the data.

My idea is to make temporary database to copy all fields if the database is not present.
Tempory database will be a initial database if the given filename is not present then when i use it into my program then i will save this into another filename.

* the purpose of this is to monitor my monthly report in a year i want to separate all database file every month..

Anybody know how to determine if the database is present or not... If anybody can provide a syntax or logic for me it is a huge help..

thank you in advance
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
locsin is offline Offline
47 posts
since Aug 2007
Dec 2nd, 2007
0

Re: How to determine the availability of database file

1st answer: assuming you want to create ms access database . check if the file exist in your database folder (.mdb) then use the CopyFile App.Path to copy or create your database.

2nd answer: temporary database using ms access dont need to create a file because the database/table exist only during runtime. so filename doesnt really matter.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
student101110 is offline Offline
6 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: .vbs file
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: how many records can Access table hold?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC