 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / August 2005access and sql
Hi all, Sorry for grabbing at straws. My senerio is that I need to upgrade some of my depts to access 2003 and the other depts will still be using access 97. We have a shared database written in access 97 that all depts use. Is there any solution using sql where access 97 users and access 2003 users can use the same database? Or is there a way to install access 97 on a server/pc and share the program itself from a shortcut? or is their some kind of run time program to use. Thanks in advance for any solutions that you may have for me. Sher The easiest thing to do is split the db (if you haven't already) and make sure to leave the backend (with the tables) in Access 97. All the various Front-ends should be able to link to it regardless of the version.  SignatureKevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. www.experts-exchange.com - experts compete for points to answer your questions > Hi all, > Sorry for grabbing at straws. [quoted text clipped - 11 lines] > Thanks in advance for any solutions that you may have for me. > Sher If you can get the proper drivers, you may be able to use both versions of Access front-ends with a SQL-Server back-end. I am pretty sure that both Access versions will read the data from SQL-Server 7.0. As to ADPs, there are none for Access 97, you must use an MDB. You cannot run Access 97 from a server (other than a terminal server, and you still need licenses for each copy). You can build runtime versions for Access 97 (or any other version) if you have the developer's kits. In all cases, splitting the front-end and back-end into the data itself (back-end) running on a server is mandatory. SignatureArvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access > Hi all, > Sorry for grabbing at straws. [quoted text clipped - 7 lines] > Thanks in advance for any solutions that you may have for me. > Sher |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.