Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Creating Databases, from programs
jcguy
post Sep 9 2005, 01:06 PM
Post #1


Premium Member
Group Icon

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?
Go to the top of the page
 
+Quote Post
plot
post Sep 9 2005, 03:56 PM
Post #2


Premium Member
Group Icon

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 tongue.gif so i would know
Go to the top of the page
 
+Quote Post
yordan
post Sep 9 2005, 06:52 PM
Post #3


Way Out Of Control - You need a life :)
Group Icon

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
Go to the top of the page
 
+Quote Post
thedevil
post Sep 13 2005, 02:11 PM
Post #4


Member - Active Contributor
Group Icon

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
Go to the top of the page
 
+Quote Post
jvizueta
post Sep 22 2005, 11:22 PM
Post #5


Newbie [ Level 2 ]
Group Icon

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.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. The Best Database(41)
  2. Need Advice On Creating Online Music Database(6)
  3. Creating MySQL DB(15)
  4. Hosting A Server On Database(6)
  5. Migrating Databases(2)
  6. Unexpected Database Crashes(0)
  7. Combining Databases(4)
  8. Creating Tables In MySQL On Home Comp(8)
  9. Updating A Database's Tables(10)
  10. What Is A Database How Do I Use One?(7)
  11. How To Setup SMF Databases?(4)
  12. Copy Databases In phpMyAdmin(3)
  13. Can You Make Your Own MySQL Databases?(7)
  14. Creating A Online Community With Php And Mysql(10)
  15. Ms Databases(6)
  1. How Do You Make Large Databases?(14)
  2. Examining Databases At A Whole Glance(7)
  3. All About Databases(3)
  4. Free Graphical Tools For Databases(7)
  5. Databases(2)


 



- Lo-Fi Version Time is now: 7th October 2008 - 01:30 AM