Can an MS Access database handle many users?

IGinc

Board Regular
Joined
Jun 14, 2009
Messages
148
I am creating a dating website, being new to creating databases, I was caught up in the creation of the database that I did not take the time to ask myself, which program I should use to create the database, I read that Access cannot handle many users/visitors accessing the database, and that MySQL is the better route.

1) Is this the case?
2) Can I migrate the table I have created from access 03 to MySQL.

Thanks.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

IGinc

Board Regular
Joined
Jun 14, 2009
Messages
148
Re: Can an MS Access database be used to build tables and then transfered to MySQL?

thanks for the continued responses,

I have been looking into the Web 2.0 Article, I came across it, and am exploring osDate...

I'm wondering since MySQL is linux based, and I am currently having trouble finding a working version of MySQL Front or Heidi SQL where I would have a front-end rather than a command line.....

Can an access database be built and then imported into MySQL later on?
 

HiTechCoach

Well-known Member
Joined
Aug 29, 2010
Messages
1,008
Re: Can an MS Access database be used to build tables and then transfered to MySQL?

I'm wondering since MySQL is linux based, and I am currently having trouble finding a working version of MySQL Front or Heidi SQL where I would have a front-end rather than a command line.....

MySQL is NOT just linux based. It is probably the most popular SQL server on the Linux platform. mySQLcan be run on many OS platforms including Windows.

I use a GUI front end to manage mySQL databases on a Windows servers on the LAN and on emote servers Windows, Linux, Unix, etc). The key to using it with remote sites is that teh remote site must be properly configured to allow remote connections. Most web hosting provides turn this of for security reasons.

Check out mySQL's official web site.

Can an access database be built and then imported into MySQL later on?

Yes but I would not recommend it. I would start with the back en in theSQL serer of your choice. Later you can downgrade the back end to Acess is needed.
 

Montez659

Well-known Member
Joined
May 4, 2005
Messages
918
Check put phpMyAdmin for a decent user interface to the mySQL environment. For that, I would definitely check out installing WAMP Server to test. It has phpMyAdmin built in and can turn an ordinary desktop into a makeshift test server.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,531
Messages
5,602,202
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top