Create a database with custom extension for vb?
-
Hello! I have created a database software in vs 2013! But the problem is, the program loads a database created by ms access, i mean the program loads the database from an (.aacdb) file stored in the program directory! but is there a way to create a custom file type but my vb program will detect it as a databse and user will be able to read and write data in to the database from vb but the database will have a different file extension.For example: userdata.abc instead of userdata.aacdb...So is there a way to do so??
-
But how am i supposed to do that ? Any codes please?
-
u said if ur code doesn't work, then convert it ! But where is your code ??
-
But how am i supposed to do that ? Any codes please?
Member 13336882 wrote:
But how am i supposed to do that ? Any codes please?
How it is done is explained in the article I linked to. No code; this is a registry-setting, usually done from an installer, not a running application. If you want to have code, you could "search" this site and get to this[^].
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
u said if ur code doesn't work, then convert it ! But where is your code ??
-
but how am i supposed yo create the database file with a custom extension?? i mean, if create a db usin access, well then, accesss is the software which creates the (.aacdb) file right?? I mean that a software generates/exports the file right? idd so, which software should i use to make my own file type? u said it's a registry thing! well, i have read a lot of forums saying its a registry thung! ok, i get it! but how can i CREATE THE FILE?? registry cant create it, thn wht should i do????//
-
but how am i supposed yo create the database file with a custom extension?? i mean, if create a db usin access, well then, accesss is the software which creates the (.aacdb) file right?? I mean that a software generates/exports the file right? idd so, which software should i use to make my own file type? u said it's a registry thing! well, i have read a lot of forums saying its a registry thung! ok, i get it! but how can i CREATE THE FILE?? registry cant create it, thn wht should i do????//
-
But wait!! oke, if u try your method, i may get a new file, but will vb open it? because lemme remind u, i am making a database software.Well, when you create a db software in vb, u need to add an existing database using the DATASET CONTROL, which can only open (.aacdb) or other file types that are associated to database, so if i create a new file type using ur method, vb will not even be able too open it! EVEN IF U DONT USE THE DATASET CONTROL TO IMPORT AN EXISTING DATABASE, VB WILL CREATE A BLANK DB ITSELF WITH A FILE EXTENSION OF (.mdf)! well, it is back where it started?!!!!!
-
But wait!! oke, if u try your method, i may get a new file, but will vb open it? because lemme remind u, i am making a database software.Well, when you create a db software in vb, u need to add an existing database using the DATASET CONTROL, which can only open (.aacdb) or other file types that are associated to database, so if i create a new file type using ur method, vb will not even be able too open it! EVEN IF U DONT USE THE DATASET CONTROL TO IMPORT AN EXISTING DATABASE, VB WILL CREATE A BLANK DB ITSELF WITH A FILE EXTENSION OF (.mdf)! well, it is back where it started?!!!!!
Member 13336882 wrote:
when you create a db software in vb, u need to add an existing database using the DATASET CONTROL, which can only open (.aacdb) or other file types that are associated to database
The application "Access" cannot open Word-files, since it would not recognize the layout. An access-file that is saved with the file-extension "test" would still be openable by Access. It would just not open automatically using the correct application if it is not registered.
Member 13336882 wrote:
EVEN IF U DONT USE THE DATASET CONTROL TO IMPORT AN EXISTING DATABASE, VB WILL CREATE A BLANK DB ITSELF WITH A FILE EXTENSION OF (.mdf)! well, it is back where it started?!!!!!
..so? The wizard in VB is expecting that extension. If you want another then simple create a file with a different name.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Member 13336882 wrote:
when you create a db software in vb, u need to add an existing database using the DATASET CONTROL, which can only open (.aacdb) or other file types that are associated to database
The application "Access" cannot open Word-files, since it would not recognize the layout. An access-file that is saved with the file-extension "test" would still be openable by Access. It would just not open automatically using the correct application if it is not registered.
Member 13336882 wrote:
EVEN IF U DONT USE THE DATASET CONTROL TO IMPORT AN EXISTING DATABASE, VB WILL CREATE A BLANK DB ITSELF WITH A FILE EXTENSION OF (.mdf)! well, it is back where it started?!!!!!
..so? The wizard in VB is expecting that extension. If you want another then simple create a file with a different name.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
can u please elaborate??
-
can u please elaborate??
On which part? The "accdb" and "mdf" file types are only registered on machines that have Access installed (a simplification); but it still is an Access database regardless of whether Access is installed or not. It will remain an Access database if you change its file-extension.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Hello! I have created a database software in vs 2013! But the problem is, the program loads a database created by ms access, i mean the program loads the database from an (.aacdb) file stored in the program directory! but is there a way to create a custom file type but my vb program will detect it as a databse and user will be able to read and write data in to the database from vb but the database will have a different file extension.For example: userdata.abc instead of userdata.aacdb...So is there a way to do so??
-
Yes, it's easy. You just have to write all the database handling code in your application. So if you have a few years' of free time ...
what are da codes thn? at least any link to an article??
-
On which part? The "accdb" and "mdf" file types are only registered on machines that have Access installed (a simplification); but it still is an Access database regardless of whether Access is installed or not. It will remain an Access database if you change its file-extension.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
okeee....finally i get it!! But, when i am done changing the file type, how wiuld i add it in vb using DATASET control??
-
what are da codes thn? at least any link to an article??
-
okeee....finally i get it!! But, when i am done changing the file type, how wiuld i add it in vb using DATASET control??
The same way you use a regular database-file; it still is one after all, and the wizards and tools won't care about the name. Most of us would probably not use the wizard and load the data from code. That way one has a bit more control over what is happening. Basically, you make a connection, issue a command, and retrieve the results thereof.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)