Re: help with web-database
Doug Wycoff (dwycoff@aol.com) wrote: : In article <4jsko0$hue@grid.direct.ca>, Darcy_Buskermolen@Cyberstore.ca says... : > : >I have a question regarding a web-database. : > : >I have a "parking space" on an BSDI-unix web server. I have a MS Access : >database which I maintain on my local network (not internet'd). I would like : >to upload my MS-Access database once a week to the unix system (3000- miles : >away). : > : >I would like this database to be accessabl via the WWW for people to search : >and possably modify.. : > : >This database does not nessasarly have to be Access once it is on the server : >but this is what I create it in. : > : >ie. you could export tha db as "tab field" and inport it into ??? unix : >database to be used? : > : >Any comments would be muchly liked : >Could you pls e-mail me with responces : > : I did this just last week. I keep my SQl Server on a different machine, which : happens to run Microsoft Internet Information Server. The MS Server can access my : sql server with some special queries and html forms. I run a database and export : it DIRECTLY in the server. YOU MUST FIRST HAVE A ODBC CONNECTION. To test this, The way I get an ODBC connection is to use HotSockets by Ensodex. It allows me to do ODBC over the internet. This way I can connect machines that are not on Microsoft network. Their ODBC driver would sit on MS Access and the HotSockets server sits in from the of "unix system" (or SQL Server). Then you can push and pull any information you want from the database. I believe that Ensodex also has utilities that would help you load and unload a database over the internet (no special connections required). They can be reached at: http://www.ensodex.com/ : if you can open MS Query and connect to the server, then you have a odbc : connection, OR add it to it with the odbc tool. : In access select the table to export, choose ()ODBC* in the file type, you can : then choose the odbc driver, you will then be prompted for a user id and password. : Then it will export it into the database. BUT here is the downside. When it is : imported, the database designates the field charactestics to what it wants. You : cannot choose. So if you want to query off of this you will have to write the : query off of it. : Here is another option. You will have to open the table in DETAIL view, edit the : specs, usually you can designate the characteristics as DOUBLE, TEXT, or : DATE/TIME. So, you may now export it as TEXT/DELIMITED and assign the specs for : that table in ACCESS so you can use the same specs again. (I use a dummy query : and table so I just clear the temp table, append into the temp table[which already : have the fields set to either DOUBLE, TEXT, or DATE/TIME], and export the table : with the save specs.) THEN create the tabel in the web server with those specs : that you exported that access table. : ---------------------------------------------------------------------------------- : ---- : If you wanted to export it 300 miles away, the open ODBC in the main, choose add, : select the correct driver to the database you plan to export to, fill in the name, : I.P. address and if need be the library driver. Then save. : To test this connection opem MS Query (which is included in every MS Office : installation) and choose new, select 'Other' if you do not see you odbc driver, : then select the name you gave it, choose ok, then choose 'USE' and it will prompt : you for user id and password. Then it should take only a few seconds to connect. : If you get an error, you are usually using the worg library file. : -------------------------------------------------------------------------------- : If you need any help please feel free to e-mail me at moz@hti.net or moz@slip.net, : I use ACCESS alot and SQL, Linux, Folkweb, MS Internet Info. Server.