Microsoft Access

[BEERBOY]

Can someone please help me if possible?
We have a network at work where we have a database designed in Microsoft Access where we input records.

The problem is that one of the machines wasn't connected up to the network properly and therefore, any records entered on that machine didn't register on the server but were saved on that machine.

My question is, is there anyway where I can merge the 2 files or inserting the records that weren't entered on the main server into the database?

Please help...thanks

 

[koalabear]

Sorry I can't help! WH where are you!

http://pages.prodigy.net/rogerlori1/emoticons/latemail.gif

 

[koalabear]

http://pages.prodigy.net/rogerlori1/emoticons/misce66.gif

 

[Weird Harold]

Sorry I can't help! WH where are you!

At the time you posted, I was browsing page three, trying to catch up with what happened while I was napping.

BEERBOY, I don't know anything about MS Access, but most database managers have a "merge database" function and many of the newer MS products have "synchronize" functions for updating PALM devices.

Check your help menu for those two terms.

 

[Laurel]

Hi Harold! It's you, me, & the Kiwis this morning!

 

[Weird Harold]

Hi Harold! It's you, me, & the Kiwis this morning!

Oh, there's a few others around, too.

I've got to go soon and start writing checks for the morning mail -- it's mother's day again, you know.

 

[Zamdrist]

My question is, is there anyway where I can merge the 2 files or inserting the records that weren't entered on the main server into the database?

Depending on the project, anywhere from 1/2 to 3/4 of my day is spent working with MS Access. I've worked with versions 2.0, 97 and 2000. I'm assuming you're working with 2000?

Now, to answer your question. Working from the main server database file, you can import the table of information into this database. (File / Get External Data) The dialogs will prompt you to choose which type of data to import, you want MS Access Database of course.

You'll be able to select the database file (something.mdb) and select a table to import. Import the table giving it a name you will remember. From the main database file you can then create what's called an Append Query. This will append the data from the imported table into the main database table, field by field.

If you need help writing the Append Query, let me know. If this invlolves more than one table, it can get complicated.

Of course before you begin any of this, make a copy of the main database file, the .mdb.

It is possbile also to just copy the records to the clipboard and paste them into the destination table, but if their are a lot of records I wouldn't recommend this. Also you'd have to have both databases on the same machine and open at the same time.

If you need more clarity or have other questions, feel free to let me know.

 

[BEERBOY]

Re: Re: Microsoft Access

Depending on the project, anywhere from 1/2 to 3/4 of my day is spent working with MS Access. I've worked with versions 2.0, 97 and 2000. I'm assuming you're working with 2000?

Now, to answer your question. Working from the main server database file, you can import the table of information into this database. (File / Get External Data) The dialogs will prompt you to choose which type of data to import, you want MS Access Database of course.

You'll be able to select the database file (something.mdb) and select a table to import. Import the table giving it a name you will remember. From the main database file you can then create what's called an Append Query. This will append the data from the imported table into the main database table, field by field.

If you need help writing the Append Query, let me know. If this invlolves more than one table, it can get complicated.

Of course before you begin any of this, make a copy of the main database file, the .mdb.

It is possbile also to just copy the records to the clipboard and paste them into the destination table, but if their are a lot of records I wouldn't recommend this. Also you'd have to have both databases on the same machine and open at the same time.

If you need more clarity or have other questions, feel free to let me know.

Thanks Zamdrist, I'll print that off and try it tomorrow...

Any different instruction for 97?

And thanks to the rest of you for trying to help...The Lit community are great!!

 

[Zamdrist]

Re: Re: Re: Microsoft Access

Thanks Zamdrist, I'll print that off and try it tomorrow...

Any different instruction for 97?

And thanks to the rest of you for trying to help...The Lit community are great!!

The instructions would be identical. Good luck! And feel free to call upon me if you need further help.

 

[BEERBOY]

Re: Re: Re: Re: Microsoft Access

The instructions would be identical. Good luck! And feel free to call upon me if you need further help.

Thank you for your time and help...its much appreciated.

 

[Guest]

Can someone please help me if possible?
We have a network at work where we have a database designed in Microsoft Access where we input records.

The problem is that one of the machines wasn't connected up to the network properly and therefore, any records entered on that machine didn't register on the server but were saved on that machine.

My question is, is there anyway where I can merge the 2 files or inserting the records that weren't entered on the main server into the database?

Please help...thanks

Yes, you should be able to put the records on a floppy (if you can't upload to your intranet) and merge them.....let me go look at my Access and find where it's at.

Moon

 

[Guest]

nevermind, looks like Zam came to the rescue.

Moon