Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mdb files
- Thread starter ilanrayn
- Start date
DotNetGnat
Programmer
You want to create an Access Database without an Access Database ?
You may find that a little difficult.. never heard of a free or opensource alternative - doesn't mean there isn't one though.
You may want to try the Access forum for more luck: forum181
Also, if you just want a free database why not try MSDE from Microsoft - similar to SQL Server, (much better than Access) and free.
Though if your website is hosted, check if they will support it.. they should do, but you never know.
A smile is worth a thousand kind words. So smile, it's easy!
You may find that a little difficult.. never heard of a free or opensource alternative - doesn't mean there isn't one though.
You may want to try the Access forum for more luck: forum181
Also, if you just want a free database why not try MSDE from Microsoft - similar to SQL Server, (much better than Access) and free.
Though if your website is hosted, check if they will support it.. they should do, but you never know.
A smile is worth a thousand kind words. So smile, it's easy!
- Thread starter
- #5
Which link are you referring to ?
Maybe you could provide some more details on your set-up.. e.g. server environment, access level to the webserver, local software available/OS etc etc.
A smile is worth a thousand kind words. So smile, it's easy!
No, they want to create an Access database without using the Access database program. That's different. I think you can do it through VB/VBScript using the Jet database engine and just passing the SQL CREATE statements to a connection.execute command.
Tracy Dryden
Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.
![[dragon]](/data/assets/smilies/dragon.gif "[dragon] [dragon]")
ilanrayn,
I think we need more info on what you are trying to do...
Are you trying to dynamically create the database - e.g. you have data in your main DB and want to provide sample mdb's for customers / visitors etc, based on the individual request via an ASP page. If so, the above link provided by DNG is what you need.
Or
Are you simply trying to create a database to use as a backend to your application, because you don't have the MS Access program (or you only use Linux without Wine etc), but your web host only supports MDB's ? If this is the case, you can do it all in the same way that is described in the above link, but it will be a bit more involved, and you will effectively have to write a mini DB management application. So it will probably be better to look for a pre-built solution - I'm sure there are free apps that will allow you to do this...
e.g.:
A smile is worth a thousand kind words. So smile, it's easy!
I think we need more info on what you are trying to do...
Are you trying to dynamically create the database - e.g. you have data in your main DB and want to provide sample mdb's for customers / visitors etc, based on the individual request via an ASP page. If so, the above link provided by DNG is what you need.
Or
Are you simply trying to create a database to use as a backend to your application, because you don't have the MS Access program (or you only use Linux without Wine etc), but your web host only supports MDB's ? If this is the case, you can do it all in the same way that is described in the above link, but it will be a bit more involved, and you will effectively have to write a mini DB management application. So it will probably be better to look for a pre-built solution - I'm sure there are free apps that will allow you to do this...
e.g.:
A smile is worth a thousand kind words. So smile, it's easy!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question