Unanswered: Can MS Access 97 read an Access 2000 mdb?
I have a mdb file that I created with MS Access 2000. It is basically a fancy spreadsheet at this point, with a single table of 700 or so lines in about 20 columns.
I have to transfer this data to a facility across town that is still (shudder) on Office 97... I tried opening the mdb file there, and I got an error message telling me that the database could not be opened.
When I saved the database under Access 2000, I looked for a way to save it in Access 97 format, but there was no choice for that mode that I saw.
Any suggestions welcome...
Motorola Global Software Group,
If you only need the one table then the simplest suggestion is to copy the data from the table to an excel file and paste it into the other system. This of course assumes the tables have the same layout at both sites. If you copy the data out it will give you the columns names for each column in the table, just in case you need to rearrange them before inserting into the table at the new site.
Another option involves you creating a 97 db from a 97 version. You can open this with the 2k version, be sure not to convert it when it prompts you about this. You can then import the table to it from the 2k version you have at your main site.
Both of these of course are assuming the table is not to big to be put on a disk. Then again you might be moving it on a cd.
I had 722 lines in the database. I was feeling all chuffed because the db was 5 Mb in Access 2000. Exported to Text, it was 186k! When I exported it into Access 97, it was 370k. That's a HUGE difference! No data lost, so I can only assume that Access 2000 has a lot of overhead.
"Uncle Bobby Collins" on WGN used to say there was no Iowa, just a blank spot on the map covered in corn...
I think I have this part of Access mastered.
Now what I need to do is get each row of data cranked into a seperate MS Word document and automagically put into a seperate directory (which already exists). I have heard Mail Merge can do this, but I need to mess with it a bit.
As usual, there are many different ways to skin a cat. I tend to shy away from doing too much "programming" in Word, because I find it gets really messy. There are ways you can use the SendObject command to get what you want into a doc, or you can export data from queries into separate files, etc etc.
I'll need to know a bit more about what you are trying to achieve.
I have a list of names in Access, and I have 700 of them.
Each entry is name, address, company, location information etc.
Hembrook, RangeR BoB, Austin, 867-5309, etc...
I have a very strictly formatted form (to make it look just like the ones in the other departments) that I want to fill with data.
I have a directory structure with 700 directories, on for each entry in the database. This particular form would then go into its own subdirectory under the named directory.
A normal mailmerge will make a single, 700 page document that I will have to bust up into separate files and save by hand in each directory. If I could do it another, simpler, way, life would get much easier.
I only have 2 weeks to get this setup and debugged. it would be nice if others could follow along (I am the only techie here) when I am done here, and automate the process so that if the database gets updated, I ccan just make a run and produce a sheaf of new docs, so I don't have to have them update each datasheet everytime a single record gets changed.