front end 2003, back end 97

[billb]

can i create a database using access 97 as the back end and 2003 as the
front end so users of both 97 and 2003 can use it and update records?

Bill Bedal

 

[Rick Brandt]

can i create a database using access 97 as the back end and 2003 as the front
end so users of both 97 and 2003 can use it and update records?

Yep. A relatively common scenario in fact.

 

[Tony Toews [MVP]]

can i create a database using access 97 as the back end and 2003 as the
front end so users of both 97 and 2003 can use it and update records?

Agreed with Rick. While we only did this using A2000 I had 15 users coming in via
A2000 and 10 users hitting the A97 BE from A97. Worked quite well. Last I heard,
I fired the client, the BE was at 300 Mb with four tables with at least 200K records
each.

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/

 

[billb]

Thanks all