Problems after converting 97 to 2002

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi, Company have just upgraded to XP and I have converted
the Access 97 database to 2002 with a number of problems.
Any advice (or pointers to suitable knowledge base)
appreciated.

First, whereas 97 would allow me to go into design while
others were logged in (multy user networked environment),
2002 will not allow this. I have a general system
password set but no further security. Is there anything I
can do in, say, record locking to allow me to do design
work while others are in?

Second, I had a number of Mail Merge docs linked via
Hyperlink addresses on Command buttons which all users
could access. When I converted the links were broken and
now I can only set this up for one user. If I try to set
up for another, it breaks the link between the MM doc and
the database for the first one. All users still have
access to the Merge docs folder. I cant figure out if
this is an Access or network problem.

An ideas? Thanks, Noel
 
Noel said:
Hi, Company have just upgraded to XP and I have converted
the Access 97 database to 2002 with a number of problems.
Any advice (or pointers to suitable knowledge base)
appreciated.

First, whereas 97 would allow me to go into design while
others were logged in (multy user networked environment),
2002 will not allow this. I have a general system
password set but no further security. Is there anything I
can do in, say, record locking to allow me to do design
work while others are in?
Click to expand...

You have to split the app into a FE and BE.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It also supports
Terminal Server/Citrix quite nicely.
Second, I had a number of Mail Merge docs linked via
Hyperlink addresses on Command buttons which all users
could access. When I converted the links were broken and
now I can only set this up for one user. If I try to set
up for another, it breaks the link between the MM doc and
the database for the first one. All users still have
access to the Merge docs folder. I cant figure out if
this is an Access or network problem.
Click to expand...

Hmm, is each users link to the MM doc file the same? If a drive
letter does everyone have the same drive letter?

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
 
Thanks Tony. Ill have a look at your website, although Im
not sure I want to add any more complications to this
project. It seems every time I move into a new area to
solve one problem I get another two or three to deal
with. Im very wary of Access now. As for the second
point, Im using a Hyperlink address that specifically
avoids mentioning a drive, just in case their drive
allocations change at some point in the future - one of
the computer technicians gave it to me. This used to work
fine before the upgrade to XP and convert to Access 2002.
I did try building a new Word MM doc, just in case 2002
didnt like the old MM doc but that didnt solve the
problem. As I say, Im not sure if this is an Access or
network problem. Thanks again, Noel
 
Noel said:
As for the second
point, Im using a Hyperlink address that specifically
avoids mentioning a drive, just in case their drive
allocations change at some point in the future - one of
the computer technicians gave it to me. This used to work
fine before the upgrade to XP and convert to Access 2002.
I did try building a new Word MM doc, just in case 2002
didnt like the old MM doc but that didnt solve the
problem. As I say, Im not sure if this is an Access or
network problem.
Click to expand...

Then I'm not sure either. Could you post the hyperlink address here
for us to review?

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
 
Hi. Picked this up at home. Will post Hyperlink address
when back in work on Monday. Thanks, Noel
 
Tony, the Hyperlink address is

\\Csufb1\Shared\SCHOOLX\Mail Merge
Documents\SchoolLetBEdFinalMain.doc

One other point, which I will also discuss with the tech
people here, is that when I go through the process of
reestablishing the link between the MM doc and access I
get asked a lot of questions that I dont get when I set
up a new MM doc. eg what sort of link to use - something
about DDE or ODBC. I dont understand what these mean and
I choose DDE. Then I get a box asking me to confirm the
security requirements eg that the user is Admin and
whether a password is needed or not. The thing is, I have
set a general password but nothing else. So I dont really
know how to answer this question. Are all my users signed
on as Admin by default? Could my entering the wrong info
be creating the problem?

Thanks again, Noel
 
Noel said:
Tony, the Hyperlink address is

\\Csufb1\Shared\SCHOOLX\Mail Merge
Documents\SchoolLetBEdFinalMain.doc
Click to expand...

Looks fine.
One other point, which I will also discuss with the tech
people here, is that when I go through the process of
reestablishing the link between the MM doc and access I
get asked a lot of questions that I dont get when I set
up a new MM doc. eg what sort of link to use - something
about DDE or ODBC. I dont understand what these mean and
I choose DDE. Then I get a box asking me to confirm the
security requirements eg that the user is Admin and
whether a password is needed or not. The thing is, I have
set a general password but nothing else. So I dont really
know how to answer this question. Are all my users signed
on as Admin by default? Could my entering the wrong info
be creating the problem?
Click to expand...

Ah, this sounds more like a network problem. In your initial post you
stated "Hi, Company have just upgraded to XP and I have converted
the Access 97 database to 2002 " Now does this mean your company has
just upgraded to Windows XP for all the client computers and you have
converted the A97 database to A2002?

If so this problem has something to do with network permissions and
the nature of the new network. When I see stuff such as DDE/ODBC
then you've gone out of Access and are in the network portion of
things.

So I'm going to pass the buck. <smile> I'd suggest visiting a Word
networking newsgroup to ask these kinds of questions.

Tony (Why yes, I am excellent at passing the buck. Why do you ask?)

--
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
 
Hi Tony. Thanks for your reply.

To your question - Now does this mean your company has
just upgraded to Windows XP for all the client computers
and you have converted the A97 database to A2002? The
answer is yes.

I too feel that the problem is outside Access but Im no
expert. Ill be showing one of the Computer/Network people
the problem soon so hopefully theyll recognise the
questions about DDE/ODBE and security as indicating a
network problem. If no success with them Ill follow your
advice re contacting a Word networking newsgroup.

Thanks again for your help. Noel
 
Back
Top