choice of DB - Microsoft Access / VBA

ugo_lavoie

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

Subscribe Reply

1232

ugo_lavoie

what would be the advantage and con. of each..

Nov 13 '05 #2

Steve Jorgensen

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

Rick Brandt

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

ugo_lavoie

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

Nov 13 '05 #5

Similar topics

198

7522

The Industry choice

by: Sridhar R | last post by:

>From technical point of view, I could not understand the the reasoning behind using Java in major companies. Sure that Python, is used in some, but still Java is considered as a sure-job...

Python

510

Web Service returning xs:choice as return type in C++ .NET

by: dgaucher | last post by:

Hi, I want to consume a Web Service that returns a choice, but my C++ client always receives the same returned type. On the other hand, when I am using a Java client, it is working fine (of...

.NET Framework

1529

usage of "Choice" Compositor with Attributes/attribute

by: kosaraju.puneeth | last post by:

I want an element that must have either attribute A or B. <Thing1 A="aaa"/> <Thing1 B="bbb"/> I want to enforce this in my schema . If A and B were elements, I could use choice.

.NET Framework

8985

xsd.exe and choice

by: Dennis Vroegop | last post by:

Hi there! I have the following XSD (Well, this is not the real one, but the concept is the same....) <?xml version="1.0" encoding="UTF-8"?> <xs:schema...

.NET Framework

2903

xs:choice

by: Oleg Ogurok | last post by:

Hi all, I have a complex type defined as follows: <xs:complexType name="SchedulingMethodType"> <xs:choice maxOccurs="1"> <xs:element name="Interval" type="xs:duration" /> <xs:element...

.NET Framework

1708

problem compiling xsd with xs:choice node

by: Sergey Poberezovskiy | last post by:

Hi, As part of my schema I need to ensure that at least one of two fields have values. I defined my schema as follows: .... <xs:choice> <xs:element ref="el1"/> <xs:element ref="el2"/>...

.NET Framework

2447

Help -- xs:Choice minOccurs not being enforced!

by: rbarschaw | last post by:

I have the following schema designed: <xs:complexType name="AzzFeature-BoxType" mixed="true"> <xs:choice minOccurs="1" maxOccurs="unbounded"> <xs:element ref="Sub-Head" minOccurs="1"...

.NET Framework

1484

having difficulties with 'choice'

by: SL33PY | last post by:

Hi, I'm currently busy writing an xsd at one point in time i whish that my xml must look like: <object> <loc> <disk> <drive>c</drive> <path>temp\path</path> <files>*.*</files>...

.NET Framework

1658

XML Schema --- <xs:choice maxOccurs=5>

by: hooomee | last post by:

Given: <xs:choice maxOccurs=5> <xs:element name="Foo" type="bar" /> <xs:element name="Foo1" type="bar" /> <xs:element name="Foo2" type="bar" /> </xs:choice> Is the choice made once and then...

.NET Framework

2825

xs:choice and child elements with minOccurs=0

by: Peter Larsen | last post by:

Is this really a valid schema design? <?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="root">...

.NET Framework

7388

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7545

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7111

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7539

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5692

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5095

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

1605

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

807

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

461

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General