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

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

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







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