How to run shared split database with most users on 2003 and others on 2007

[theProfessor]

We are using a shared split database with all users currently using
Access 2003. The back end is on a shared drive of a state wide WAN.
Each user has a copy of the front end on their local computer.

I programmed and maintain the database. We have about 140 users with
about a maximum of about 20 concurrent users.

I use user level security to determine which of the three groups a
user belongs to, and then VB Script and macros show the appropriate
forms and objects. From reading this forum, I realize that Microsoft
Access built-in user level security doesn't give good security; but
that's okay because we are on an intranet.

The database was working fine until IT started to roll out new
computers with Office (Access) 2007. I only had a few minutes using
a networked computer with Access 2007. I'm working on getting my own
copy of Access 2007.

A bunch of dialog boxes popped up when Access 2007 opened the front
end. Since I wasn't sure what the effect would be on the shared back
end, I canceled out of Access.

I have read some postings on this forum about 2007 issues, but I
haven't seen anything covering our database situation. I'd
appreciate any guidance about how to get the Access 2007 users on to
the shared split database.

Gerald

[Tony Toews [MVP]]

theProfessor <ge******@sbcglobal.netwrote:

>We are using a shared split database with all users currently using
Access 2003. The back end is on a shared drive of a state wide WAN.
Each user has a copy of the front end on their local computer.

Good design as we recommend.

>The database was working fine until IT started to roll out new
computers with Office (Access) 2007.

And they did this without asking for your input and/or testing of your app? Wow.

>A bunch of dialog boxes popped up when Access 2007 opened the front
end. Since I wasn't sure what the effect would be on the shared back
end, I canceled out of Access.

Well, you'd better write down those messages and post back. However they are likely
going to be the trusted locations stuff. Which you can setup on the users PC I would
think.

There shouldn't be any problem with the shared 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Tom van Stiphout]

On Tue, 28 Aug 2007 05:34:26 GMT, "Tony Toews [MVP]"
<tt****@telusplanet.netwrote:

But Access is not designed to run on a WAN. If you don't regularly
need to repair & compact the back-end the quality of service of yours
must be above average and you can continue to run in this
configuration; otherwise you need a server-class back-end.

Why are we surprised new computers are being rolled out with A2007?
It's not easy to buy computers with previous OS or Office.

-Tom.

>theProfessor <ge******@sbcglobal.netwrote:

>>We are using a shared split database with all users currently using
Access 2003. The back end is on a shared drive of a state wide WAN.
Each user has a copy of the front end on their local computer.

Good design as we recommend.

>>The database was working fine until IT started to roll out new
computers with Office (Access) 2007.

And they did this without asking for your input and/or testing of your app? Wow.

>>A bunch of dialog boxes popped up when Access 2007 opened the front
end. Since I wasn't sure what the effect would be on the shared back
end, I canceled out of Access.

Well, you'd better write down those messages and post back. However they are likely
going to be the trusted locations stuff. Which you can setup on the users PC I would
think.

There shouldn't be any problem with the shared back end.

Tony

[Tony Toews [MVP]]

Tom van Stiphout <no*************@cox.netwrote:

>But Access is not designed to run on a WAN.

Yikes, I missed the WAN part. Thanks for noticing that.

>Why are we surprised new computers are being rolled out with A2007?
It's not easy to buy computers with previous OS or Office.

Larger IT departments will continue to toll out images of systems with their standard
configuration even if new OS and Office and such has been available for a year or
two.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/