Database Migration
Jan 21, 2008I 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 ?
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 ?
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.
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
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
Any body have an idea how to migrate cobol index file into Access or any other database.
any tool method suggetions
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 ?
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
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
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.
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.
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedDatabase: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
Thanks!
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies View RelatedIs it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.
View 2 Replies View RelatedI created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.
the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.
Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?
I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.
Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.
This way we can have several txt file for several project and use always the same exe database.
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
Does anyone know how this is done?
Thank you in advance for your help,
~Kilch :eek:
The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp
Jabez
I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.
View 3 Replies View RelatedI have a car dealership database and have a servicing section.
I want to create a form to service these vehicles.
The only vehicles which will be displayed on the from are the sold ones (because you cannot service a vehcile which hasnt been sold) which i have a query for.
I also want the form to display the customer who owns the car the service details (eg what they need), the parts availiable and the parts required for the service.
The calculations i need to make in this form are as follows
quantity needed (parts required table) - quantity in stock (purchasing customer parts table)
quantity needed (parts required table) * price (Parts Table) + labour (servicing table) = part/labour costs (servicing table)
http://pic18.picturetrail.com/VOL885/3178839/6480291/97832270.jpg
any suggestions on how to do this would be fantastic
i havent been able to figure out how to get my subform to work properly....
i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 )
it is really important that i figure this out so that i can keep my job..
how else can i obtain help? even if i have to pay for it?
what do you guys suggest?
Hi all,
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
Please help
Thanks!