Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



MS Access to MySQL

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-04-2011
Member
 
Join Date: Jan 2011
Posts: 99
MS Access to MySQL
  

I am, by far and away, the major MySQL newbie yet. The situation currently is: One server with the .mdb file, and the clients every have access installed. It works, just about. The major problems are that manifold users cannot, truly, access the database at the similar, even if they are editing split records. What the database involves is a table with quite a lot of columns of data, I have obtained it into an SQL format, and I can attach to the SQL database on my localhost (In the genuine implementation it would be a local server), I guess I require to then study PHP to improvise a webpage that can inquiry the database, with consents based on who you log in as?

Reply With Quote
  #2  
Old 16-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,185
Re: MS Access to MySQL

You can set up the level of consents based on users (e.g. set up user accounts with separate rights for a variety of tables) within MySQL, and after that tie those to php pages/logins. Php is a simple way to query and exhibit the information, but it's not the just way. Remember if you are appearing to serve the pages inside with the SBS2008 server, you will necessitate installing and configuring PHP. You could utilize rather like EasyPHP to provide you a onetime typical install of MySQL, PHP and Apache on the server, but you might need to look at how it would interfere with IIS.
Reply With Quote
  #3  
Old 16-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: MS Access to MySQL

A bit more on the advanced side of things - Zend framework. If you are going to utilize PHP, begin by utilizing it right- Look into object oriented notions, MVC (Model View Control) intend techniques. With Zend you can improvise a database "CRUD" page in minutes by means of Zend DB/Zend Auth/Zend ACL. The whole thing is well recognized with instances, and there?s a 100 or so fraction series on using Zend as a podcast, they as well offer project code so you could in theory exercise one of theirs as a base.
Reply With Quote
  #4  
Old 16-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,022
Re: MS Access to MySQL

Here I wish to add something in this case. There?s a million and two ways to construct a frontend for PHP, even Ruby on Rails might be a choice, although my knowledge with that is extremely incomplete. I know many people who like it though. On the whole, one time you wrapped your head around PHP, php.net has a few luminous documentation of each single function and as its crowd commented, this frequently offers good instances.
Reply With Quote
  #5  
Old 16-04-2011
Member
 
Join Date: Dec 2010
Posts: 67
Re: MS Access to MySQL

Later than much reflection, I determined an application would be superior, as the majority of the other people in the office stared vacantly while I recommended a webpage on the intranet, but understood the notion of an application. I have hooked C# up to the MySQL database, which all works well, however. I am stressed to exercises how to make C# run a query based on what is chosen in the drop down list (Which inhabited from MySQL). So if I were to choose Customer 1 which occurs to be ID 2, how would I after that get the rest of the information to display?
Reply With Quote
  #6  
Old 28-04-2011
Member
 
Join Date: May 2008
Posts: 913
Re: MS Access to MySQL

To be truthful with you, if you are going to utilize C# you are much better utilizing SQL Express- the free edition of SQL. The cause for this is the MySQL .net connector - it?s just not as fine as the SQL native connector. You will as well be able to utilize the Visual Studio tools for designing and interrelating with the SQL database straight and you will just normally discover less resistance from the environment because you are doing it the way Microsoft wish you to. You either necessitates to look into Transactions or build a vital system of locks which stop your code interacting with a database record even as it?s in use.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MS Access to MySQL"
Thread Thread Starter Forum Replies Last Post
Advantages of Migrating from Microsoft Access to MySQL PsYcHo 1 Windows Software 5 27-03-2010 12:58 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Working with Access and MySQL Jacob Software Development 3 31-10-2009 08:12 PM
Mysql remote access Gomeler Software Development 3 30-10-2009 12:05 PM
Error 1045 - Access denied in PHP5 and MySQL Banjiji Software Development 3 28-08-2009 05:05 PM


All times are GMT +5.5. The time now is 01:15 PM.