Migrating A97 -> A2K
Jan 26, 2006
We are upgrading our Access 97 databases in our company since we were told that Microsoft is, or will soon no longer, support A97.
I've migrated a few of our simpler databases already. Everything went without a hitch and all functionality was retained.
Word spread and now other depts are seeking my assistance. Some of these databases are somewhat complex in regard to their use of modules and linked/ODBC tables.
If I were to attempt to convert the 97 version (copy of course), and if anything were not to convert properly, would Access tell me in the form of an error message or table? Or do I have to manually test all functionality in the 2000 version and hope that I didn't miss anything?
View Replies
Jul 25, 2006
Hello all...
How do you merge / append records from one database into another? The old database was very poorly designed (i.e. no normalization), but much of the data is the same.
Instinct from what I have learned says do this:
- create a query in each database that joins all fields together into a flat table
- run an update query that migrates the source data to the new database.
I really have no idea though, and to be honest... even if this is how it is done, I am very unsure how to proceed!
All help is very appreciated!
View 1 Replies
View Related
Dec 14, 2005
I have a somewhat complex question.
We currently run Access 97 in the following way. We are looking for a solution where new members can access our data and change it using the internet. We are not sure of the best way.
Our database is split between "data" and "front-end". The "data" is kept on our win2000 server and is split into a "master" and several replicas. Some employees run their "front end" acceess programs on fixed computers attached to our network and simply attach to the "master" "data" database on our server. 4 employees use laptops and run their "fronends" by attaching to their own "replicas" of the "master" which they carry around with them. Once in a while, ususally daily, they synchronise their "replica" with the "master" on our server by simply attaching to our network using ethernet or WiFi.
What would be the best way to allow new members to join in the fun? There could be as many as 10 new members (brining the total to 16). The main problem is that they are located in different countries and ideally need to have a web or VPN access to our server. Does anyone have some suggestions? Should we migrate to SQL?
The database "data" is about 180Mb in size and has 40 odd tables that are used in a complex way by the "front ends". All queries are stored in the "front ends".
?? I would really appreciated some ideas..
Thomas
View 4 Replies
View Related
Apr 24, 2014
I need to migrate the contents of a table from Access Jet or Ace to SQL Server.
The table has 2 fields, an integer and a BMP image ex
Field1 Field2
1 BMPimage
2 BMPimage
3 BMPimage
4 BMPimage
If I manage to export the images to files like 1.bmp, 2.bmp, 3.bmp, 4.bmp etc I can then import them into SQL Server.
View 6 Replies
View Related
Mar 8, 2015
Exporting all the OLE files in a 2003 database.
Any way to automatically connect these file to an attachment field in the existing record.
View 7 Replies
View Related
