Changing file format of back end

[Guest]

I have converted from Office 2000 to 2003. My back end is in 2000 format
with Tools/Options/Advanced/save as 2002-2003 format. I have switched my
front end to also reflect the same format. When the database is called up it
specifically says that it is in 2000 format. How do I get to save the back
end as 2003 format.

I notice that one table that I used to be able to pull info from another
table has lost that capability so that has prompted this question, do know if
this is the solution.

 

[Roger Carlson]

Go to Tools>Database Utilities>Convert Database>To Access 2002-2003 File
Format

I don't know if this will fix your problem. Can you elaborate on it a bit?
Better yet, try the upgrade and if it doesn't repost the question under a
new thread.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tony Toews [MVP]]

I have converted from Office 2000 to 2003. My back end is in 2000 format
with Tools/Options/Advanced/save as 2002-2003 format. I have switched my
front end to also reflect the same format. When the database is called up it
specifically says that it is in 2000 format. How do I get to save the back
end as 2003 format.

Don't bother. You won't notice any difference for the backend
containing tables to be in A2003 format vs A2000 format.

This only makes a difference for some functionality in the forms and
reports thus doesn't matter for the back end.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

OK, I updated both the back end and the front end.

What I referred to was that I have a "Products" table and a "Vendor History"
table. If I were to go into "Products" there would be a + by each record.
Clicking on the plus sign gave the history of that product from "Vendor
History". I understood that this functionality was because I had used the
Products table's fields as a drop down for the "Vendor History" fields. It
was very convenient to look up. Now I have to create queries. Since the
only change I have made was upgrading to a newer version don't know what has
happened.

 

[Roger Carlson]

Hmmmm. I'm not a fan of subdatasheets, which is what you're describing. I
never allow my users to look directly at the tables themselves. I do
everything through queries, forms, and reports. But this is only because
I'm creating applications for other people. If you're using this just for
you, subdatasheets may be useful.

Try opening the tables in Design View and then look at the properties. Make
sure the Subdatasheet Name property is set to [Auto] or the actual table it
should be linked to. Be sure to save the table before opening it again.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L