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 Replies


ADVERTISEMENT

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

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 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 1 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

Queries :: Unable To Convert Text Into Date With Different System Language Settings In MS Access

Jun 6, 2013

I have a table in access database which contains a text field 'EDate' that stores Date value in format (12-Apr-2013). Now I want to run a sql query on that field. User will give an input date. The sql query needs to fetch me all the records from access database whose Edate is less than or equal to the user input date.

I am using DateValue function to convert my text filed Edate into date. My query is something like this:

select * from table_name where DateValue(EDate)<='user_input_date'

I am able to perform above task if the system language settings are 'English'. But if system language settings are different say Turkish, then the query fails.

I searched a lot on web and found that DateTime function compares test data with the system date time format and gives the result. Thus it fails with different language settings.

View 3 Replies View Related

Stupid Question: Autonumber, Legacy Data

Jan 29, 2008

version: access 2000.

OK, i have what may be a fantastically stupid question. i did a search (http://www.access-programmers.co.uk/forums/search.php?searchid=1806902&pp=25&page=2) on this and didn't find anything that seemd to address it.

my issue: autonumber field, sole primary key. i am adapting a legacy (non-access) db into access. it was originally an autonumber field but during import, the data type was set to number and of course, i cannot convert it back now into autonumber.

i already duped the PK field as an autonumber and tried an update query to "correct" the autonumbering PK field as i believe is suggested here (http://www.access-programmers.co.uk/forums/showthread.php?t=138484) but it won't permit me to do this.

b/c it's legacy data, i want to preserve the original values in the autonumber, but am unclear on what next steps might be available to me.

thoughts, anyone?

ed

View 2 Replies View Related

Tables :: Primary Web Based Inventory System - Update Raw Data From Another System

Mar 13, 2014

I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.

View 2 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

Getting Into An Access System

Jun 12, 2007

Someone, who is no longer working at out organisation, created a system in Access which we are trying to get into, however the creater put on some security which will not let us open the system to alter. Is there a way of getting into this?

View 11 Replies View Related

How To Update A Live System With My Reports & Queries

Mar 22, 2007

I am writing reports and queries for an Access database used by a small business. I have a copy of their data and am making the report and query additions to that. Now how do I get my additions to the 'live' system?

Robert

View 2 Replies View Related

Access Quiz System

Jul 29, 2005

hi
i am trying to make a quiz system using ms access
i want to select 30 questions randomly from a questionbak of 100 or more
also i need to select 3 answers randomly including the corect answer
from answer bank that has 5 possible answers for each question

tblquestionbank
QID Question
1 Question1
2 Question2
3 Question3

tblanswerbank
AID QID ANSWER CORRECT
1 1 Q1 answer a true
2 1 Q1 answer b false
3 1 Q1 answer c false
4 1 Q1 answer d false
5 1 Q1 answer e false

the field correct is for identifying the correct answer yes/no filed

so far i have been able to get the questions randomly
that is generating a random number in the query and selecting
top 30 records

ideas and help would be appreciated

View 1 Replies View Related

Queries :: Linking Weekly Rota System To A Date

Oct 4, 2013

I have a staff rota system that works on a rolling 4 weekly basis. I am using a table to store the shifts of a person dependent on week. I want to be able to tell access that Monday on week 1 corresponds to a certain date and then get access to figure out the rolling system based on that date.

eg Monday 21/7/13 is week 1 (7 days later it knows it is linked to week 2)

This is so if a staff member is off sick I can say they were off sick on the 24th and it will populate their timesheet with the corresponding shift without me having to input it manually. Doable?

View 1 Replies View Related

Queries :: Set Month Or Year Default As Per System Date

Oct 16, 2013

How can I set Month or Year default as per the system date. ie Only select records by Month (October) or Year (2013) as per system date?

View 3 Replies View Related

Implement Barcode System With Access

Feb 1, 2006

Sorry for the flashy post.

1.st Job:
I have an access 2003 db. I want to implement barcode system to the DB in which I can print barcodes in any kind of barcode printer and also when imputing an order read data from barcode scanner etc.

2nd Job:
I want to put access db to a server so I can view reports, forms, imput data and retrive data from internet explorer window (with a password).

I will give my DB to you so you can work on it. Please do the pricing seperate for each job.

Please PM or Reply if you have more than 500 posts. PLEASE RESPOND IF YOU REALLY KNOW HOW TO DO IT.

Thanks in advance.

View 3 Replies View Related

Access 2003 Using System DSN Problem

Jun 20, 2007

I have a system DSN, pervasive ODBC engine interface. In Access 2003 I can link to the DSN but can only link to some of the files. This started when I changed to a new computer. Before, I had a link to the same database using Access 2002 with no problems.

Any help will be greatly appreciated.

Brad

View 8 Replies View Related

Access System Size Recommendations

Jan 3, 2008

Hi,
I have been given an Access database to maintain and it has some performance issues.
I have been looking through this forums for recommendatons regardng size etc but didn't really find anything.

It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB.

In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload!
I don't know if it is due to the way it is done, the VB code calls a macro that calls a query.
Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access..

Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system?

Thanks /H

View 3 Replies View Related

Access Errors And Crashes On New System

Jul 24, 2012

My office computer, along with the phone system, printers etc took a lightening strike last week. The hard drive survived but not the computer. I was able to get the office access db onto a new system but now I get errors when running it. When opened, the main menu appears. Whoopee!Not so fast. When I select an item, I get "the expression On Click you entered as the event property setting produced the following Automation error. The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]There may have been an error evaluating the function, event, or macro"

Pressing the button a second time does not produce the error and opens the correct form.This form works properly. The second problem is with a second report form that opens properly.This form expects dates and accepts them but when I try to print the report, access closes with no error message.

View 7 Replies View Related

Queries :: Booking System - Finding Available Room For Date Range?

Feb 18, 2014

So I'm trying to do this database for my ICT coursework and its a full system for dog kennels.

So in actuality the rooms are kennels.

I have a table tblbookings that amongst others has fields:

Kennel No
Date In
Date Out

I need a way of users entering the requested dates for a new booking and getting an output of a list of all kennels that are available to book for that full date range or even better, a way of running this straight from the form for a new booking frmbookings to just leave the first available kennel no. in the field KennelNo?

View 5 Replies View Related

Code To Link From Access To Company System

Oct 21, 2004

Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?

View 2 Replies View Related

Queries :: Automated System - Appending New Contacts To Data / Different Field Names

Jan 30, 2015

I'm creating an automated system on access, basically it uploads client's files and analyses their data. The files will always be different, with the amount of fields changing and with different field names each time

One part of it, is appending new contacts to their data. This means records which we can add new contacts to, needs to be duplicated with the new contact placed at the end. So it needs to be like

Company Name New Contact Name
A
B
B Tom
B Harry

Because it's automated with different field names each time, the duplicating part is an issue. I can use the * rule which appends all fields, however this will not work in this case, if we are adding more than 1 new contact, the new contact will be duplicated rather than having 2 new different contacts.

Ideally I want rule saying, append all fields EXCEPT the fields where the new contacts are placed, but I don't think this is possible

I'm using Access 07 for this. Using a mix of VBA and SQL in the modules

View 2 Replies View Related

User Authentication System For Access 2007 Questions

Jan 1, 2008

Alrighty -

After learning that 2007 has no User Security roles, and not having Sharepoint or a SQL server, I decided to work starting with Bob's Simple Login script located here (http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx).

I've got it functioning fine and incorporated some of the options also made available here (http://www.databasedev.co.uk/login.html).

You'll see the code below used to store info in a hidden form that is holding the username and permissions level. I'm looking to try and store this information into a global variable instead of a hidden table.

I know that I could define it as a variable right here in the code, but how do I define it as a Global variable so I can use it later in the application in the VBA?


Private Sub cmdLogin_Click()
Dim strUser As String
Dim strPWD As String
Dim intUSL As Integer

strUser = Me.txtUser
If DCount("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") > 0 Then
strPWD = DLookup("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'")
If strPWD = Me.txtPwd Then
intUSL = DLookup("[SecurityGroup]", "tblUsers", "[UserName]='" & Me.txtUser & "'")
Forms!frmUSL.txtUN = strUser
Forms!frmUSL.txtUSL = intUSL
Select Case intUSL
Case 1
DoCmd.OpenForm "frmHome", acNormal
Case 2
DoCmd.OpenForm "frmHome", acNormal, , , acFormReadOnly
Case 3
MsgBox "Not configured yet", vbExclamation, "Not configured"
Case 4
MsgBox "Not configured yet", vbExclamation, "Not configured"
End Select
DoCmd.Close acForm, "frmLogin", acSaveNo
Else
If MsgBox("You entered an incorrect password" & vbCrLf & _
"Would you like to re-end your password?", vbQuestion + vbYesNo, "Restricted Access") = vbYes Then
Me.txtPwd.Value = ""
Counter = Counter + 1
If Counter = DLookup("[OptionValueNum]", "tblOptions", "[OptionsID]=1") Then
MsgBox "You have entered an incorrect password too many times. This database will now close!", vbCritical, "Wrong password!"
DoCmd.Quit
End If
Else
DoCmd.Quit
End If
End If
End If
End Sub

View 4 Replies View Related







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