Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Would it be possible to migrate the MS Access 2000 to MS SQL Server
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?
If I migrate the MS Access to SQL Server, would the queries, back-end
VBA, macro, tables and forms be affected? Do I need to change the MS
Access data type to SQL server supported data type?
Which tool I can use to do the migration? Upsizing wizard or exporting...Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Most of our MS SQL Servers are still running on SQL 2000, but being I
will soon be upgrading my workstation to Vista Business I'd like to
install MS SQL 2005 Enterprise Manager to manage them all. When I
tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a
message saying it's not compatible, so I'll have to use 2005 I guess.
We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
work with these okay? Also I want to make sure SQL 2005 Enterprise
Manager won't be adding to, changing, or 'upgrading' the DTS scripts or
anything on the SQL 2000 servers as we still have folks using SQL 2000
Thanks for any suggestions. I'm always leery when using cross-versions
of Microsoft applications because they are often incompatible or they
do squirly things that often break stuff.
Alex (email@example.com) writes:
> We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
> work with these okay? Also I want to make sure SQL 2005 Enterprise
> Manager won't be adding to, changing, or 'upgrading' the DTS scripts or
> anything on the SQL 2000 servers as we still have folks using SQL 2000
> Enterprise Manager.
> Thanks for any suggestions. I'm always leery when using cross-versions
> of Microsoft applications because they are often incompatible or they
> do squirly things that often break stuff.
There isn't any Enterpr...SQL Server "Linked Server" to MS Access Database
I have a very frustrating problem. I have a situation that works fine
on some computers, but not on others. I have SQL Server Express 2005
and Access 2003 loaded on 4 computers. I have set up a "Linked
Server" in SQL Server linked to my Access database. I am running
queries on t-SQL against the Access tables through the linked server.
On all of the computers, I can do select queries and they all work
great but what I need to do is run Update, Insert, Delete queries as
well. On a couple of the computers, it works fine, locally and across
the LAN, and a VPN as far as that goes. But on other computers I can
do Select queries (also across the network) but no update queries. I
get the error message "OLE DB provider "Microsoft.Jet.OLEDB.4.0" for
linked server "securedjetls" returned message "Operation must use an
updateable query." where securedjetls is the name of the linked
server. The Access database on the computer that is not working is a
copy of the database from the computer that is working and any of the
tables that I'm trying to update have primary keys, so that's not the
...How to connect MS Access form to MS SQL Server
I created an application which use MS Access 2000 as user interface and
MS SQL Server 2000 as backend. If I want to get data from MS SQL Sever
2000 and display them on the MS Access 2000 form, where do I set the
database connection to the form (i.e. tell the form to get data from MS
SQL server database)?
In Windows control panel, admin tools, data sources (ODBC), create a
system DSN of type SQL server and fill in the parameters for your SQL
database. In Access, select file / get external data, files of type
ODBC. Select machine data source, select the DSN you created and the
table(s) you need.
...MS-Access 2003 & SQL Server
I have a form in a Access Project (SQL DB on the back end). On this form I
have created a Combo box that pulls a list of dept and dept #'s from the
DEPT table, and displays the dept name in the Combo box. I tried a view
instead of a table but the Combo box would not update. On this form I also
have a sub form. The sub form has on it, among other things, the following
fields; SVCCODE, SVCODE TOTAL. I also have hidden on the sub form a GLCODE
and GLDESC fields.
What I need to happen is when the Main form Combo box is changed to a new
dept desc, let say Radiology, I want the subform to display the radiology
What is actually happening is when the form opens a list of SVCCODES are
displayed, I am not sure what they are connected to, and when I choose a
dept name from the combo box the SVCCODE's display, on the subform, the
department list of service codes. For example when I open the form, the
subform starts off with the list of service codes I mentioned above and the
Combo box is blank, but then when I change to a different department, in the
combo box on the main form, the subform does not display those SVCCODE
records correlating to the main forms combo box, instead it displays the
SVCCODE's for the department in the list from the department table. So if I
change to Radiology, it does not care and displays the BLOOD BANK SVCCODE's,
those being the next department.
One side note I can hit enter with the Combo box highlight...MS Access & SQL Database for JPEGS
I'm trying to create a web accessed JPEG database for all of my
p 0 r m pics. Anybody know where to start? The site I'm interested
in putting in an Access database is at the link below:
Don't click on this link unless you want to be seriously offended.
I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
imported to MS Access?
Can you answer this question?
Thank you in advance for posts
Marcin from Poland.
On Tue, 19 Apr 2005 17:23:48 +0200, "Kamyk" <firstname.lastname@example.org>
>I have such question to all of you.
>I have some tables linked from MS SQL Server 2000. Is time of processing
>based on these linked tables from MS SQL Server 2000, faster or slower than
>the time of processing the same query based on tables, which are not linked
>imported to MS Access?
>Can you answer this question?
>Thank you in advance for posts
>Marcin from Poland.
That depends on a lot of things...
The most obvious thing it depends on is the size of the result set. In a
client/server arrangement, you want to keep result sizes down, and do
aggregation and filtering on the server.
Next, how many people will be sharing the back-end data. Access slows down as
soon as 2 people are sharing a JET back-end, but the server won't have this
limitation. On the other hand, if the server is too slow, or you're trying to
use MSDE with more users than it's optimized for, the server will be slow.
There are m...what is equivalent of format(date) function of MS Access in MS Sql Server 2000
I am facing a problem with a sql what i used in MS Access but its not
returning the same result in MS Sql Server 2000. Here i am giving the
SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE
The above sql in ACCESS return me the date in below format in one
Friday 09, 2003
But in Sql server 2000 i am not getting the same format eventhough i
am using convert function, date part function etc.
Please if you find the solution would be helpful for me..
If you field is a datetime, you can use the CONVERT function to conver...Adding records to a SQL Server database from MS Access
Thanks in advance for your help.
I have just upsized an Access database to SQL Server with the hope of
using a fairly extensive Access application that was part of it. But
now, the forms will not allow the addition of new records (the >*
button is greyed out). The forms use a macro to advance the dataset to
a new record. How can I get the additions (inserts) turned back on?
...General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
I am working on two versions of an application, one of which will be a
windows forms application (which will need to be redistributable) and
the other will be a web application.
I have MS Visual Studio 2005 (along with the developer's edition of MS
SQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun's
application server, Tomcat and Apache web server. I am working on
Windows XP Pro, and have installed the .NET 3 SDK and all relevant
related products I could find (e.g. 2 extensions packages for Visual
I have one MS Access database, to which my users should have read only
access. I have, and have used, a tool for importing MS Access
databases into MySQL. I expect that SQL Server has a similar utility
hidden somewhere (where I haven't yet looked, though I HAVE been
looking - obviously in the wrong places). I have located a similar
utility for importing MS Access databases into PostgreSQL. I have not
yet decided which servers to use for the web version, but that is
another story, for which I may raise another thread in due course (but
I welcome suggestions which may reduce the effort required given
required effort for the windows forms app).
My problem is for the windows form aplication (intended for use by a
single family). I expect to use ADO.NET. The question is, should I
import the Access database into MS SQL, and redistribute it, along with
MS SQL Server Express (or is that necessary), or distribute it just as
an Access database a...MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
the MS SQL 2000 Server JDBC driver.
I have installed and configured the MS SQL Server 2000 onto two computers,
which reside on the same network. (In fact, these two computers comprise
the entire network).
The network server (computer name=SUNCDS1), and the lone node (SUNCDS2),
each have their own SQL Server 2000 instance.
The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL
Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2.
It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise
console does not show the SQL Server Agent as being started, but I can
navigate to the SUNCDS2 databases, and display the table information. If I
try to start the SQL Server Agent for SUNCDS2, I receive the message "Access
is Denied". The enterprise console on the SUNCDS2 machine indeed shows the
SQL Server Agent as being started.
I have written a sample Java application that uses both the MS SQL Server
ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish
a connection to the SUNCDS2 instance. This application resides on the
SUNCDS1 network server. The ODBC driver will connect to SUNCDS2 instance
wihout a problem.
The JDBC driver does not connect to SUNCDS2. The JDBC driver will, however,
connect to the local SQL Server instance that resides on SUNCDS1.
Following are the code snippet to est...Php and DataBase Abstraction for mySql, Sql Server, and MS Access?
Is there a good DataBase Abstraction layer that will handle the
mySql, Sql Server, and MS Access engines? I do not wish to write the
same functions with the three different PHP db functions.
I see that php_dba is listed as an extension, but I determine which
DBs are supported. However, I think that it does not support the ones
> Is there a good DataBase Abstraction layer that will handle the
> mySql, Sql Server, and MS Access engines? I do not wish to write the
> same functions with the three different PHP db functions.
> I see that php_...Re: Accessing MS SQL server or ORACLE database from the HP3K
One small clarification to my previous question:
We are not trying to migrate our IMAGE data to another platform. We are
trying to provide an enhancement where data that already exist in a
database on another platform can be viewed, extracted and used to
"complete" an existing entry in the IMAGE database, thus eliminating the
need for the user to manually 're-enter' the data.
I was asked the following question today and decided to turn to y...Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9
Complete MVDBMS neophyte -I may not even qualify at the neophyte
level- that needs a simple solution to move data -in batch
initially...real-time eventually- from RDBMSs such as SQL Server 2000
or Access 2002 (XP) to UniData 5.2.9.
Any leads would be greatly appreciated.
Ryan N. wrote:
> Complete MVDBMS neophyte -I may not even qualify at the neophyte
> level- that needs a simple solution to move data -in batch
> initially...real-time eventually- from RDBMSs such as SQL Server 2000
> or Access 2002 (XP) to UniData 5.2.9.
> Any leads would be greatly appreciated.
> --Ryan N.
Accuterm, look at the Excel option, and then the
scripting to move it on.
Better yet, most likely you need a consultant. Check
out Tony Gravagno. He's good at building interfaces,
and has most of the tools pre-built. He is at
http:(no spam)//nebula-rnd.com/ get rid of the
HTH, Patrick <;=)
"(Latimerp)" <"(Latimerp)"@comcast.net> wrote:
>Ryan N. wrote:
>> Complete MVDBMS neophyte -I may not even qualify at the neophyte
>> level- that needs a simple solution to move data -in batch
>> initially...real-time eventually- from RDBMSs such as SQL Server 2000
>> or Access 2002 (XP) to UniData 5.2.9.
>> Any leads would be greatly appreciated.
>> --Ryan N.
>Accuterm, look at the Excel option, and then t...Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how
can i make client access database located on the server?
"HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message
>I m currently developing a java based application and want to know how
> can i make client access database located on the server?
I think you're going to have to expand a little bit more in your question
here, as is not 100% quite clear what you're trying to do.
You might want to make a little bit of a distinction between MS access, the
development system that allows you to write code, build forms, and build
reports, and that of the database engine that you choose to use with MS
access. When you build an application MS access, you then choose your
database engine, that might be oracle, SQL server, or perhaps more often
leave the default jet database.
So when you say make a client access application, are you talking about a
piece of software that you plan to install and each computer? The fact that
your introducing the issue of java further complicates your question.
Perhaps your question is simply you have some java code running on a server,
and with to open a mdb file (an access database file). In this situation
you're not really using MS access at all here (you using what is called the
jet database engine to read that mdb file). For all the trouble in this type
of sce...MS Access, SQL Server, Web server
I am planning to write an application using MS Access as front-end.
User enters records (mostly 15 records or less per user per day) into an
Access database. Having done that, users click a button to transfer
these records to a web server hosting an SQL Server database (set up by
a service provider). Each record represents a job; provider will update
its status when a job is done.
At the end of day, user will open up the database to enquire the records
status, which will be retrieved from the web server (through HTTP protocol)
A service provider will probably have 2000 records/jobs per day, which
will be fetched from the web server to its PC for job scheduling purposes.
Can someone advise me as to how to go about doing this ? I have read a
little on WinInet APIs of MS Visual Studio 6, but I am still not sure;
eg how to get SQL server to send data to client PC using HTTP.
Thanks for your advice.
I can't really understand the scenario here. You are going to have to
explain this better.
1. Who are the users? What do they do? Are they mobile in that they
are not connected to the network when they are working, like traveling
2. Who are the service providers? I'm assuming that these are not
Internet Service Providers or Application Service Providers, but rather
people who work for the company and do things for customers. What kind
of jobs do they do? Do they provide their services in places where
they h...Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
Probably this question has been asked hundreds of times and yet net
search has not generated satisfactory enough answer, at least, to me.
And OK, let's assume your organization has more than 200 employees,
just one measure to indicate that it's not small and data processing
needs are quite extensive (for both OLTP and OLAP).
We've heard so much about concurrency support, stability and
performance. Are there any real persuasive paper out there to talk
about it? Now, let me also put it in another perspective, say, you're
a Microsoft sql server sales guy or gal for that matte...Re: Accessing MS SQL server or ORACLE database from the HP3K #3
if nothing else helps, you could use Java and JDBC with the JDBC
driver of the respective target database. A small example showing
access to an Image/SQL database can be found on the following web
page (and can be adjusted to use an MSSQL or Oracle JDBC driver
and database URL/logon fairly easily)...
http://www.editcorp.com/Personal/Lars_Appel/JavaDemo/ -> JdbcProgram
Calling Java from COBOL as a subprogram, however, is probably not
the way that I would go, if exploring this road. I would probably
let a program similar to the above run as a "gateway" in a sep...Re: Accessing MS SQL server or ORACLE database from the HP3K #6
On July 9, 2003 11:23 am, Duane Percox wrote:
> * Performance was not that great so you wouldn't want to use this
> for production, but proof of concept and for learning it is ok.
Do you have any performance numbers for it all on Linux?
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
...Re: Accessing MS SQL server or ORACLE database from the HP3K #3
In a message dated 7/8/03 5:23:24 AM Pacific Daylight Time,
> It's not MS SQL or Oracle but for what it's worth, we once had a Cobol
> accessing a PostgreSQL database that resided on a Linux server by using the
> libraries included with Mark Bixby's PostgreSQL port.
I for one would absolutely love to see an example of that! Sometime soon (?)
I hope to be able to finally spend some time working with PostgreSQL on MPE
and/or Linux. Having a known working example of how to access it via COBOL is
a great ...Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?
I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Per Sue Bricker:
>Is it possible to create an MS/ACCESS database application and package
>it for users who do not have MS/ACCESS loaded in their PCs?
>I was told that this is possible, but I don't know what software is
>needed. Do you know? If so, please answer this post. Thanks.
I think it comes down to semantics.
"Licensed" vs "Loaded".
No you can't create an app that will run on a PC with nothing loaded.
Yes you can create an app that will run on a PC where nobody's paid the fee to
run MS Access.
You still have to install something on that PC, however. What it is is a
freebie version of MS Access that only runs applications - doesn't allow anybody
to develop an app.
You develop the app on your PC, which has MS Access installed.
Then somebody installs the freebie ("Runtime Access") on somebody's PC and they
can run the app you developed without having to pay any money to anybody.
If Access isn't present, some version of it must be installed to run an
Access database. VB.NET, ...MS Access conversion to MS SQL
I've been developing a database for a department in a local
organisation. The database is in Microsoft Access and uses tables,
queries, forms and reports. Written into the forms is vast amounts of
visual basic. There are also a couple of macros.
In the time I've been developing this database (a year now, as I went
back to university, and then finished university and returned to
finish off the DB) the organisation I've been working for have decided
to start using MS SQL. The department I am working for aren't to happy
as not only my database but most of theirs are in Access and no one
seems to have actually used SQL or know anything much about it.
Basically, I need to learn about how to convert from Access to SQL. I
understand we use the upsizing wizard. I've managed to track down some
of the rules I have to use in the conversion (like no spaces in names,
no apostrophes etc), but I'd like to know if anyone could tell me more
about the upsizing procedure. I'm also concerned about the vast
amounts of forms I've made (It's a 109mb database with no data - all
down to the forms!). What happens to these? Does SQL use forms, or
will all of these be lost? And what about queries?
Any information from someone who has knowledge of these things would
be greatly appreciated!
An account of how I did it can be found at:
1. Close all database objects...Database migration from Sybase ASE 12.x to MS SQL Server 2005
We are going to be migrating an application and the first step is to
migration the Sybase database to SQL Server 2005 database. Can anyone shed
some light into this and help me understand the process involved? What are
the possible pitfalls? What should the approach be?
Any help would be greatly appreciated?
...Loads of errors when querying MS SQL Server Express 2005 from Access 2007
I wonder if you could help - I have an SQL server database with four
I have a 'tblContact':
I have a =91tblClient=92:
I have a =91bltClientContactLinkTable=92:
And fiinally a tblPosition:
The query below (when run through a Query Analyser connected diretly
to the SQL server) displays the first and last name of all contacts
along with the company they work for and the position the hold. If
they don't have a position it returns 'no position'.
coalesce(tblPosition.Description, 'no position') as Description
INNER JOIN tblContact ON (tblContact.ContactID =3D
INNER JOIN tblClient ON (tblClient.ClientID =3D
LEFT JOIN tblPosition ON (tblContactClientLinkTable.PositionID =3D
However, If I connect to the server from Access so I can actually edit
the data easily I get problems
Once I'd added all the tables I need (through ODBC linked table),