![]() Each different program has a master version, which is stored on the server, and a local version which is copied down to each person's computer. We use numerous Access programs which have an Access front end with the data stored in SQL Server. My problem is not fully understanding how/where the processing occurs within the different scenarios - which will create the most bottlenecks, network traffic and how much work is being done by Jet or SQL Server in each case?. to each client machine and go back to the problems of linking in the dozens of tables to each users pc with machine based DSN Copy each complete access application containing the forms, linked tables etc. Just have one MDB backend on the file share containing all the linked tables and have copies of the front ends on each client pc - not sure where the DSN should beģ. forms, queries, reports, linked tables on the file share with a single file DSNĢ. Leave things as they are - the complete access applications inc. The question is, bearing in mind that for the present we need to stick with OBDC/Access queries due to current skill set, is it more efficient to:ġ. However, the performance of these databases is pretty abysmal and has only recently improved as I have begun to rewrite some of the Access queries behind reports as server side views and then linked them back into the databases with ODBC so we changed to a single file based DSN for ease of management. Originally, although the databases where always on the file share, we had local machine based DSN's on each client pc, but this seemed to cause no end of problems with some users linking new tables which could not then be seen by others/broken links etc. All these client machines have MS Access installed locally.Īll these file share MDB databases have ODBC linked tables to a single large SQL Server 2000 database and the tables are linked through a single file based DSN also residing on the Novell server. We do not have Microsoft network/domains, only Windows client machines. In the current setup we have a series of Access databases, written over several years by different members of staff that reside on a Novell file share. I am sure other people must have had very similar issues to this. ![]() I am not talking about ADP projects or delivery via the web at this stage, just old fashioned ODBC linked tables in MDB database files. I am hoping to establish once and for all, the most efficient way to deliver MS Access based reports to our 20-30 users.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |