By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,092 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,092 IT Pros & Developers. It's quick & easy.

choice of DB

P: n/a
Hi, i was doing a little Db in acces for my boss but now he wants it to
be linked with our business partner....So they can enter data in it..So
far i think i will need a bigger database with a lot more security
(manage password, give acces to a portion of it to some persons and
other parts to others)Now i know access is a nice front end, and i
already have forms and everything in access, my question is what DB
(SQL, MySql....) would be good for it.

By the way i think we have a SQL server already running so would it be
a good choice???
thx a lot....

It's my first time choosing this kind of stuff....

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
what would be the advantage and con. of each..

Nov 13 '05 #2

P: n/a
I can't say much bad about Microsoft SQL Server. It's powerful and easy to
administer. If you are not already very experienced with database server
administration, Microsoft SQL Server will give you the fewest hurdles.

I'm not saying you won't have to struggle a bit here and there, but it's the
easiest there for the situation you're in.

On 25 Jan 2005 07:29:21 -0800, ug********@hotmail.com wrote:
Hi, i was doing a little Db in acces for my boss but now he wants it to
be linked with our business partner....So they can enter data in it..So
far i think i will need a bigger database with a lot more security
(manage password, give acces to a portion of it to some persons and
other parts to others)Now i know access is a nice front end, and i
already have forms and everything in access, my question is what DB
(SQL, MySql....) would be good for it.

By the way i think we have a SQL server already running so would it be
a good choice???
thx a lot....

It's my first time choosing this kind of stuff....


Nov 13 '05 #3

P: n/a
ug********@hotmail.com wrote:
what would be the advantage and con. of each..


The advantage of already having a SQL Server instance trumps everything else
that could possibly be considered.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

P: n/a
ok, we have a specialist in SQL so it shouldn't be problem...

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.