Access Migration To SQL Server Issue

Nov 2, 2007

Good day dear experts,

I have a global question about the access migration to MSSQL serv , a lot of solution in google, but no clear anwers...
well just want to see your proposions: i'm now splitting between two ways,
to use ODBC linked table connection and MDB file as front. or use ADP file as a frontend and DAO as a SQL technology.
I have a new access database system without any data at the moment for real estate bussiness, about 15 tables, 4 forms, biggest one is abot 30 fields.
So it not seems to be a very big overload on queries. The problem is i allready developed the system on the access, and it seems to work fine, but when I tryed to move it on SQL throught ADP project, You know, i was kind of confused. :eek: and the idea of rewriting all the code i've made dissapoint me deeply ...

So, can't wait for your proposes, about this issue...
Is it ODBC or is it DAO ???
If it will be DAO afterall, may be you can give a link to the clear tutorial...
"How to modify code for ADP files."
beacaose i realy dont have much time to read a lot of prologs about the technologies and so on, i need to deal with this issue till next week !!! :(

Thnks a lot in advance...
Mike

View Replies


ADVERTISEMENT

SQL Server Migration Assistant For Access

Nov 23, 2006

Microsoft is offering a tool that "Automates database migration from Access to SQL Server 2005."

The tool is downloadable from here (http://www.microsoft.com/downloads/details.aspx?familyid=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en).

If this is what it sounds like, then it can be a very valuable tool. Has anyone used it? If so, what has your experience been like?

SHADOW

View 4 Replies View Related

Access Migration

Mar 5, 2008

hi all,

I'm trying to convert access 97 database running on XP to access 2000 running on Vista..

Can anyone guide me to some suitable website where I can learn of the problems that will arise together with their the solutions.

Regards
Eddie

View 1 Replies View Related

Access Tables For Migration

May 27, 2013

I need to create Access tables for migration.

One user can have multiple laptops.

Is this the best way to create the tables as shown below. (PK - primary key & FK - foreign key)

Table 1: User ID(PK), User name, Email, Contact, Comments

Table 2: Laptop ID (PK), User ID (FK), Location, Desk, Make, Migration Date, Migration Status

Can I create a query to join these two tables together so I can use the table view to enter the details ?

View 8 Replies View Related

Access Database Migration To Oracle

May 10, 2005

Hi, I have a question regarding improving the performance of an Access front-end linking to Oracle tables.

Basically what I have done so far is migrate around 35 or so tables into an Oracle 9i database. After linking the tables in Access and prototyping some of the existing forms/reports/queries in Access, I noticed that the speed performance of everything was noticeably slower. Any suggestions as to how I can resolve this issue? For read online queries and reports, I understand that I can use a pass-through query to speed things up. However, all the forms need to allow for data entry and based on my understanding, the pass-through query solution would NOT work for this.

Any suggestions? Any help would be appreciated.

View 4 Replies View Related

General Error With Migration 97 To Access 2003

Sep 29, 2005

In the company whe are migrating from NT4 with Access 97 to a XP And office 2003 enviroment.

This couses some serrius Isues.

one of them richt no is a Multi usser DB. 2 systems of XP and only one of them is able to run the DB. both instalations are the same. ... the DB is tested on more XP systems. but so als it seems only one person is able to run the DB at a time..

But a few can't run the DB at al.

the Software on all systems is the Same Image so there is no diference between OS and Office.

Who already migrated from 97 to 2003 and had isues with migrating..
like these.

.. on the department whe have 15 + diferent DB's in 97. and the Main developers of these DB's ore the IT department is not going to fix this.

View 2 Replies View Related

Legacy System Access 2.0 Migration Queries

Jun 12, 2006

First post, so I hope I'm following the post-etiquette!

Anyway, I've just been employed by a company who still uses access 2.0 and lotus smartsuite.

Basically I'm gonna have to migrate a few of their backbone databases to access 2000+

I've managed to find the old Microsoft access 2.0 book in the company amazingly, which is a help.

I was just wondering if anyone knows any good sites for migration, or any particular problems that may be encountered. I'm just doing some background work at the moment, this won't be happening for a few weeks (hopefully!)

Any help would be greatly appreciated.

I'll just take this opportunity to say that I've found the site very useful in the last few weeks and hope I can contribute in the future when I break out of newbie status!
-Spud.

View 4 Replies View Related

Web Migration

Mar 24, 2008

I'm not sure if this is even possible; but I figured if anyone knew the people here would!! :)

I've got a HUGE database that is shared out here locally. This DB has 70+, 150+ queries (I'm trying to whittle this down little by little), 60+ reports, and numerous macros. The DB resides on a local computer that is shared out throughout our local network.

We've come to the point now where I get asked several times a week to send data out to this place or that... Or, to send the whole DB out so another section in a different state can look at it. Pulling the data is easy, but the DB is too large to e-mail and since it is constantly updated (24/7 in use) uploading it to a file server just doesn't seem practicle.

How difficult would it be to migrate this over to a web product? Somethiing that could be accessed over the WWW. Would have to re-write several areas to add password protection/read-only permissions; but other than that, could it be done??

Thanks

View 14 Replies View Related

Migration Of Data

Dec 20, 2006

Any body have an idea how to migrate cobol index file into Access or any other database.

any tool method suggetions

View 4 Replies View Related

Database Migration

Jan 21, 2008

I have a database in MYSQL and the client wants to move it back to MS-Access. I need a tool that can lift the entire structure and DATA and migrate it.

Does anyone know of a good tool to do this ?

View 3 Replies View Related

Access FE SQL Server BE

Dec 5, 2007

We're currently looking at changing a couple of my more complex Access 2003 databases to Access Front End with a SQL Server Back End. This should give us better stability and reduce network traffic loads. I was looking at the Access help file on Upsizing and came across the following paragraph. On face value to a novice like me this would seem the easy option - but is it?

"Create an Access database front-end to an SQL Server database back-end so that you can create a front-end/back-end application.

This approach requires very little application modification since the code is still using the Jet database engine. "

Would anyone recommend this approach?

View 4 Replies View Related

SQL Server To Access

Feb 15, 2006

I am importing an Excel file into a table in SQL Server that was created by an AS400 program.

I linked this table in MS Access. The date fields from the SQL Server table are split out. DSREQM is the month and day. DSREQY is the year. When opening the table it looks like this:

DSREQM DSREQY
215 6

I need to be able to convert this is a field to 2/15/06. However I cannot get this to work. For some reason when I execute the query it comes out as 8/02. Here is what I have:

DelDate: Format([DSREQM],"mdd") & "/" & Format([DSREQY],"y")

Any ideas?

View 5 Replies View Related

Access Using Jet And SQL Server With ADO

Aug 29, 2007

Hi

I am attempting to write an application, using Access2003 as the front end. The Backend May be either Jet (ie an MDB), or SQL Server.

I am trying to make it so that the same code works regardless of the back end.

My approach has been to set the forms recordset to an ADO recordset like so:

Set Rs = New ADODB.Recordset
'Rs.CursorLocation = adUseClient
Rs.CursorLocation = adUseServer
Rs.Open strSQL, gcn, adOpenDynamic, adLockOptimistic
'
Set Me.Recordset = Rs

Anyone done this, and willing to sahre information/pitfalls.

First problem I am encountering is that Jet only seems to like .CursorLocation = adUseClient, and SQL Server only seemns to like .CursorLocation = adUseServer

View 6 Replies View Related

Installing Access On Server

Apr 26, 2005

Hi to everyone
Im not sure which thread i should be in, but here goes :confused: i want to create a members database for members on my forum with HTML!
Ive been told to make the database with ACCESS ive played for 2 days and im now acctually getting somewhere, i would like members to interacte with it ie....add there own details to it.
How do i do this and how do i get it to my server, well i did upload a tester but no one could see it and its says they need to have MS installed or something like that :eek:

What do i do here??
Thanks for ANY help

View 6 Replies View Related

MS Access On A CITRIS Server ?

Sep 7, 2005

I'm trying to help someone with Access on a CITRIS Server. I'm working with them VIA email. They say they're having problems communicating with printers and would like to utilize their email with Access. Can someone fill me in on common problems using Access with CITRIS Server as far as printers or email or anything else?

To be perfectly honest, I know nothing about CITRIS servers. Is CITRIS a hardware system or computer type of is it an operating system???

View 3 Replies View Related

Access Projects With SQL Server

Oct 26, 2006

I need to be able to add a feature to an Access project that will select a group of records based on an area code( user will have to be able to select a desired number like 100, or 1000), mark those as selected, and create a single csv file...The area codes are stored in the SQL SERVER database...right now they just export groups of #'s based on area code to excel select the amount they want and cut and paste into a flat file for another application to use...they would like to be able to select a number from a list box or type it in...like 100 ( which means take a 100 #'s from all different area codes) then have them automatically noted in database as being selected..and then export all selections to one csv file... should I do part of the work in the Sql Server behind the scenes..the format of the csv file also needs to be specific in that the first row is the columns separated by commas and then the data follows all text fields enclosed by qoutes..
Thanks for anyone's help ..Im very inexperienced with VB and Access

View 1 Replies View Related

MS Access And Sql Server Permissions

May 8, 2007

I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures. I finally had to give them permissions as db_owner so they could use my forms. Do I have to give them db_owner permissions to execute my stored procedures? I know I can go in and assign them execute permissions for my stored procedures, but there has to be a better way. Does anyone know how to give users execute permissions on stored procedures without having to give them db_owner permissions or having to grant execute permissions for each stored procedure individually?

I am still in the development phase of my project and having to assign users or groups with each stored procedure I create could really be a pain. Can someone please help me?

View 2 Replies View Related

SQL Server 2000 With MS Access

Nov 7, 2003

I am accessing a SQL Server 2000 database from MS Access. While I can view the tables and can add records, I cannot edit or change them. How do I get around this?

View 10 Replies View Related

Access / VBA / SQL Server Question:

Aug 29, 2005

I am trying to build a form to make deletes from our sql database easier for some of my coworkers.

They have a combo box that they select a patient name from, then based on that patient id, they have a second combo box that shows all appointments that patient has been to. All right so far, yes?

I want, after the first two selections are done and we have a patient and an appointment selected, to have a textbox that returns the count of the number of medical documents based on that appointment id.

I am trying to use a text box for this.
Code: "select count(appt_id) from template_audit where appt_id = " & Me.cboAppointment

I don't know what property of a text box to use to return a single sql statement into it. Anyone have any ideas?

Thanks.

View 2 Replies View Related

Migrate Access To Sql Server

Sep 26, 2005

The database that I have on MS Access has tables, queries, forms (VB code), reports and functions (VB). I could migrate the tables and queries through the Enterprise Manager. I want to have the forms and reports in html. Is there any software tool that can help me with over all migration?

View 1 Replies View Related

Ms Access Security On Server

Jan 15, 2006

I've create an ms access security workgroup and put .mdb and .mdw file to a folder under any acount on a server. When these files in my local machine it work properly. But when these files on server I myself cannot open .mdb file.
How to make ms access security on a server ?

View 1 Replies View Related

Difference Between MS Access And SQL Server

Feb 16, 2006

I know and have worked with MS Access for over 3 years now.
Just would like to know if there is very much difference between MS Access and SQL Server. Are they similiar or are they completely different .
In terms of designing forms, reports, sql.

Appreciate some feed back and also where I could view or look at sql server.

View 1 Replies View Related

Connection Between SQL Server And MS Access

Jun 17, 2006

Hi :

I have a question of the connection between SQL Server and MS Access.

I have a project, which is using SQL Server as backend, we use MS Access forms as the frontend.

Firstly, I created the datbase (db1) in the SQL Server, and create a few tables in db1. And then, I create a few forms in the MS Access, I used ODBC connection to link tables from SQL Server to MS Access, it is working fine. Those forms can access the linked tables.

After it is done, I put the MS Access database in the sharing drive, many people can share the files in this sharing drive.

When I go to my associate's computer, and then open the MS Access database in the sharing drive. The forms is working, but, it cannot access to linked tables from SQL Server.

I go back my computer again and then open the MS Access database, it is working fine.

What's the problem with it?
Does anybody need to install SQL Server software and also have db1 database in SQL Server and the path?

I want any user can access the linked tables from SQL Server, but I do NOT want any user can open the SQL Server and open the tables directly. I just want the users can access the linked tables through MS Access Forms only. Because I will make security in the MS Access. So, I don't let the users modify/open the tables in the MS Access, the users must access the tables via the forms only.

Please tell me the steps how to solve it.

Please help.

Thanks.

View 5 Replies View Related

Updating MS Access On Web Server

Dec 20, 2007

Hi, Using MS Access on a Server on the web with main programming in .asp
I have done all the hard work to have a userid logon with password and stop anyone getting in. I have now set up a change password facility and that again is working great on checking userid, old password, new and repeat new password.
I cannot get the update part working to update the new password. It is in the way I have specified the "call adorecordset.open" as that is the line I get the error as incompatible parameters.

Basic Code is :


set adoconnection = server.createobject("adodb.connection")
set adorecordset = server.createobject("adodb.recordset")
connectionstring = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=" & server.mappath(databaseid) & "" & databaseid & "user.mdb"

call adoconnection.open(connectionstring)
adorecordset.cursorlocation = aduseclient

sqlstring = "SELECT * from [tblOwnerLog] WHERE [UserId] = '"&username&"' AND [Password] = '"&oldpw&"';"

call adorecordset.open(sqlstring, adoconnection,adopenkeyset,adlockoptimistic)

I have tried many ways, by altering my SQLString etc, but seem to get all tied up.

I want to update adorecordset("password") with the new password.

Any help would be much appreciated.

Thanks

Jim

View 4 Replies View Related

Accessing Sql Server From Ms Access

Feb 20, 2008

Hi,

I would like to know how do i access sql server 2000 tables from a ms access database..

thanks,
ctmas

View 2 Replies View Related

Using Access As Front End For SQL Server

Jul 18, 2012

I am a computer novice with no experience in PHP or SQL Servers in general. Is there anyway to set up Access as a front-end to an MS SQL Server without having coding knowledge? Is there any good wizard that will export data/formats to a SQL Server while still keeping the interface mechanisms of Access?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved