|
|
|
|
![]() ![]() |
Sep 9 2005, 01:06 PM
Post
#1
|
|
|
Premium Member Group: Members Posts: 382 Joined: 5-September 04 Member No.: 255 |
I jsut went throught PC magazine today and i found out that you can actually create a database using Microsoft Access and Excel. And computers and servers online can actually use these databases and conduct queries with them. I've always though of databases as MYSQL, Microsoft SQL server and so on. So it is possible to store data to a Microsoft Access database and manipulate it online?
|
|
|
|
Sep 9 2005, 03:56 PM
Post
#2
|
|
|
Premium Member Group: Members Posts: 206 Joined: 4-September 05 Member No.: 8,310 |
im not sure, this would be the first time ive ever heard of this but i dont use microsoft excel or access, i use webuilder
|
|
|
|
Sep 9 2005, 06:52 PM
Post
#3
|
|
|
Way Out Of Control - You need a life :) Group: [MODERATOR] Posts: 2,031 Joined: 16-August 05 Member No.: 7,896 |
@jcguy : you are right, it's possible to use Microsoft access, having the data on a remote database : mysql database if you have a small Unix computer, or an oracle database if you have a huge AIX computer with undreds of terabytes data. Access has it's own settings where you explain that the data are not local to your computer, but are hosted by a remote database. Of course it has to be correctly installed and configured (strangely, Microsoft things work well when linked to Microsoft other things, and need a lot of administration if linked to things like Oracle or Informix or even mysql).
Unfortunately, I did not use access that way, I am more familiar with Oracle, but I have seen people using that kind of bridges for demonstrating purposes. Regards Yordan |
|
|
|
Sep 13 2005, 02:11 PM
Post
#4
|
|
|
Member - Active Contributor Group: Members Posts: 82 Joined: 17-November 04 Member No.: 1,392 |
Yes you can use mysql database on the server as well. The fact is most of the small asp based site use ms access single file based database that is ms access. You need to have a server that has the microsoft's jet (ADODB) to do such things. These are simple to connect.
Though I hardly use the msaccess database and hardly use asp so i am afraid i could not give the detail implementation on that. but it is for sure it can be used. But about excel i never knew it, rather i have used it as a CSV file. that is it i ever knew |
|
|
|
Sep 22 2005, 11:22 PM
Post
#5
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 22 Joined: 13-September 05 Member No.: 8,434 |
Check it:
http://data-conversions.net/wp01.html It's a report about Mysql and Microsoft Access, remember Access is not very stable as he is it mysql. |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 7th October 2008 - 01:30 AM |