I am developing an SQL Backend and MS Access Frontend.
I have been looking for a good inexpensive install program that would allow me to connect the frontend to an existing SQL server. With little success.
If you could direct me to something, I would be very appreciative.
Thanks,
brosner
9  1415 
I am developing an SQL Backend and MS Access Frontend.
I have been looking for a good inexpensive install program that would allow me to connect the frontend to an existing SQL server. With little success.
If you could direct me to something, I would be very appreciative.
Thanks,
brosner
brosner
Not sure why you need an install program. Access uses odbc to connect to SQL Server.
Mary
NeoPa 32,556
Expert Mod 16PB
The drivers to enable you to connect from a Front-End of Access to a Back-End of SQL Server are freely available in both packages.
brosner
Not sure why you need an install program. Access uses odbc to connect to SQL Server.
Mary
Mary,
Thanks for responding. I plan on have over 20 clients in different locations using their own SQL server. When one of my clients asked for a custom report, I want to create the report, in the version of my software just for them, and send it to them to install. The clients will not be IT people, so I want to make the install as simple as possible.
The way you phrased your response might mean I'm missing something in the way I'm thinking about this. If so, would you mind enlightening me.
Thanks again,
brosner
The drivers to enable you to connect from a Front-End of Access to a Back-End of SQL Server are freely available in both packages.
NeoPa,
Thanks for replying.
I "think" I need an install program because I will have 20 clients at different locations using their own SQL server. When one wants a customize report and I create it. I [again] "think" I need to send the new version of MS Access with an install program to link to their SQL server. My clients will not be IT people.
If I do not need an install program, please explain how the client could hook themselves up.
Thanks again for your reply,
brosner
NeoPa 32,556
Expert Mod 16PB
I'm afraid I'm not aware of any such package.
What you're asking for really then, is an installation routine that will install all of :
SQL Server; Access & your application.
Seems a tall order, but you may get some luck if you ask this in the MS SQL forum.
There's no harm in leaving this here in case anyone in Access can throw any light or point you in the right direction, but I certainly don't know of anything.
You could look up under MS's SMS I suppose, as a rollout tool, but I can't promise it can handle all you need.
I'm afraid I'm not aware of any such package.
What you're asking for really then, is an installation routine that will install all of :
SQL Server; Access & your application.
Seems a tall order, but you may get some luck if you ask this in the MS SQL forum.
There's no harm in leaving this here in case anyone in Access can throw any light or point you in the right direction, but I certainly don't know of anything.
You could look up under MS's SMS I suppose, as a rollout tool, but I can't promise it can handle all you need.
NeoPa,
Actually, I want to install all that you said except the SQL Server. Just the links to the clients tables in their SQL server.
I'll check with MS SMS.
Thanks.
brosner
NeoPa 32,556
Expert Mod 16PB
Do they all use separate SQL Servers or are they all linked into the same one via a network?
Do they all use separate SQL Servers or are they all linked into the same one via a network?
NeoPa,
They all use separate SQL servers. I installed the tables to run with my application. All clients are different companies using their own network.
brosner
NeoPa 32,556
Expert Mod 16PB
In that case I can't think of much else to help I'm afraid.
You could try asking for help in our Windows forum. They're helpful when they can be. Give them a try.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Clark B |
last post by:
Hi there!
I have a small application that I want to distribute to users. I want an
easy installation program and for this I need some help. The application is
an excel client (an excel add-in...
|
by: Tim Marsden |
last post by:
Hi,
Any suggestions on how I can secure my application with some kind of
installation key, or put a expiry date on the software.
Tim
|
by: Jimbo |
last post by:
I am trying to install Sql Server on a Win 2000 Server...It keeps
failing and I dont know why...I turned off my anti-virus for
installation and am logged in as an admin..heres the output of the...
|
by: Scott Glasgow |
last post by:
I have the Microsoft Visual Basic .NET Deluxe Learning Edition from
Microsoft and am trying to reinstall it after a hardware system crash
requiring complete reformat/reinstall of Windows XP Pro and...
|
by: MLH |
last post by:
I tested the install fileset on my laptop before leaving the
office. It worked perfectly.
My-App installation was terminated prematurely because
DAO350.DLL would not register in registry. So I...
|
by: salad |
last post by:
Hi. I have some questions regarding the distribution and installation
of an application.
My current application is written in A97. I figure its time the
application is upgraded to A2003 to...
|
by: dani kotlar |
last post by:
I have two questions concerning publishing and installation:
1. I used the publish wizard to publish an application. The application
gets installed on the target computer in some obscure folder. My...
|
by: =?Utf-8?B?d2luZHNpbQ==?= |
last post by:
Hi,
I have 3 C# programs (version: 4.6.0; 4.6.1; 4.7.0) now.When I firstly
install v4.6.0 and next v4.6.1,that is ok---that means v4.6.1 becomes the
current program to open the project...
|
by: =?Utf-8?B?R3JlZw==?= |
last post by:
I have no idea where to post this question, or even if its appropriate for me
to post it here. I don't know if installing a VB.Net program has caused the
problem I'm having or not. All I know is I...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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...
| |
