Importing Reports through Access

[ryansarmy]

Hello, a few months ago I started creating reports for an .MDB that
resides on another developer's computer. Everytime we wanted to merge
data he would import forms/reports/queries from my computer, it seems
my reports would lose certain items. Such as the "order by" in a report
or a query relationship. After the merge I would copy another .MDB and
start making changes again. My question is has anyone ever had this
problem, and I understand that Visual Source Safe is the best way to
go. I am just trying to prove my case so we can move to that.


Thanks,

Ryan Sarmast

 

[Rick Brandt]

Hello, a few months ago I started creating reports for an .MDB that
resides on another developer's computer. Everytime we wanted to merge
data he would import forms/reports/queries from my computer, it seems
my reports would lose certain items. Such as the "order by" in a
report or a query relationship. After the merge I would copy another
.MDB and start making changes again. My question is has anyone ever
had this problem, and I understand that Visual Source Safe is the
best way to go. I am just trying to prove my case so we can move to
that.

Reports (for the most part) ignore the sorting of the underlying query. You
need to set the sort order you want using the Sorting/Groupng dialog that is
available in the design view of the report. That should definitely stay
with the report as it is imported/exported.

 

[ryansarmy]

Thanks Rick, that did work through importing. I guess now I have a
follow up question. What is the best way for two Access developers to
work on the same MDB at the same time? We both edit tables/forms and
reports so I guess I don't see how spliting the MDB could work. Also, I
am new to Visual Source Safe and I have googled what I can about it,
half of what I have read leads me to believe that two people can not
have the same MDB checked out at the same time. Importing is not
working for us because of the amount of changes being made to various
objects.

I am hoping it is a simple answer that I just don't know. Thanks
for any help

Ryan Sarmast