Publisher/Access problem

[Sam Ceccola]

I am using MS Office 2000 Professional on a Windows XP
Professional OS. (Access 2000 SP-3, Publisher 2000 SP-3)

I created a Publisher file called "reunion.pub". It
contains: name, address,and other information. I went to
reference it using MS Access and the ".pub" file was
automatically converted to a ".mdb" file. Now I can't
reference it using MS Publisher. Is there any way to
convert the file back to a ".pub" file so that it can be
used in Publisher?
Thank You,
Sam Ceccola

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I created a Publisher file called "reunion.pub". It
contains: name, address,and other information. I went to
reference it using MS Access and the ".pub" file was
automatically converted to a ".mdb" file.

What do you mean by "reference" it?
You do not use a Publisher file as a database.
You cannot open Publisher files in Access

Now I can't
reference it using MS Publisher. Is there any way to
convert the file back to a ".pub" file so that it can be
used in Publisher?

I don't see how you opened it in Access at all.
Try renaming the file to have a .pub extension again
You can store a database in Access format and use the merge engine to merge
it in to Publisher.

 

[Sam Ceccola]

-----Original Message-----
After managing to set up OE-QuoteFix on his new PC, Ed reads a message

What do you mean by "reference" it?
You do not use a Publisher file as a database.
You cannot open Publisher files in Access

I don't see how you opened it in Access at all.
Try renaming the file to have a .pub extension again
You can store a database in Access format and use the merge engine to merge
it in to Publisher.

--
Ed Bennett - MVP Microsoft Publisher
http://www.mvps.org/the_nerd/
Before reading this message, view the disclaimer:
http://mvps.org/the_nerd/disclaim.htm


.
ED:

I tried renaming the file "reunion.pub". Publisher gave
message "It can not open the file". When I opened
reunion.mdb" via Publisher, it gave me the
message "Publisher is converting the file" and then
generated worsheets. I don't know how to convert he
worksheets into an editable Publisher Address List.

 

[°°°MS°Publisher°°°]

Ed, prudence tells me to leave this question to an old codger/geezer like
you!!!

--

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I don't know how to convert he
worksheets into an editable Publisher Address List.

I see your problem.
You originally claimed you had a Publisher file. You do not. You have a
Publisher Address List, which is stored in a Microsoft Access Database in
MDB format. You should have your original file somewhere.
You do not need to convert the file back to a Publisher Address List,
because the file is more useful and less awkward to use if it is in Access
format.

 

[Sam Ceccola]

-----Original Message-----
After managing to set up OE-QuoteFix on his new PC, Ed reads a message

What do you mean by "reference" it?
You do not use a Publisher file as a database.
You cannot open Publisher files in Access

I don't see how you opened it in Access at all.
Try renaming the file to have a .pub extension again
You can store a database in Access format and use the merge engine to merge
it in to Publisher.

--
Ed Bennett - MVP Microsoft Publisher
http://www.mvps.org/the_nerd/
Before reading this message, view the disclaimer:
http://mvps.org/the_nerd/disclaim.htm

Ed:

I posted a reply earlier but for some reason it wasn't
put on the board. Anyway, I tried changing the ".mdb"
file to a ".pub". Publisher said it could not open the
file.
I also tried opening the ".mdb" file in Publisher.
Publisher return a message it "is converting the file".
It created a lot of worksheets that contained my data.
When I tried to "Mail Merge/Edit Publisher Address List"
I couldn't get to the file. Is there a way to convert the
worksheets into a way I could edit the file?
Sam

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I posted a reply earlier but for some reason it wasn't
put on the board.

Your reply was shown earlier, and I replied to it.
Here is the reply that I posted before:

You originally claimed you had a Publisher file. You do not. You have a
Publisher Address List, which is stored in a Microsoft Access Database in
MDB format. You should have your original file somewhere.
You do not need to convert the file back to a Publisher Address List,
because the file is more useful and less awkward to use if it is in Access
format.