I have a project that has grown and is in serious need of a proper database server and will setup one as soon as a rewrite is done.
It started out as a simple project, then another different and also simple project. It has grown to having a common base, as well as no longer being simple on either side, also the two front ends [asp.net web app with a dozen users, hardly active] have been merged into one, and other features will be tacked on [lots of users & activity - migrating to a sqlserver in future].
The common base is the users table ( and more) which did not exist initially in Project 2. The quick fix was having a linked table to Project 1, which was done via access linked table manager (fully qualified UNC file names.) Now I need to move the database to another location and want to avoid using the linked table manager. Both databases are now in the same folder, so I want to be able to move move them onto another server, and only change the connection string on my application, and have Project2.mdb know to look in the same folder for the linked tables.
Is there any way to setup the access MDB to know that the linked table is always in the other MDB in the same folder and avoid running the linked table manager?
[Note : will be dumping access, but for now I need to patch features in]
It started out as a simple project, then another different and also simple project. It has grown to having a common base, as well as no longer being simple on either side, also the two front ends [asp.net web app with a dozen users, hardly active] have been merged into one, and other features will be tacked on [lots of users & activity - migrating to a sqlserver in future].
The common base is the users table ( and more) which did not exist initially in Project 2. The quick fix was having a linked table to Project 1, which was done via access linked table manager (fully qualified UNC file names.) Now I need to move the database to another location and want to avoid using the linked table manager. Both databases are now in the same folder, so I want to be able to move move them onto another server, and only change the connection string on my application, and have Project2.mdb know to look in the same folder for the linked tables.
Is there any way to setup the access MDB to know that the linked table is always in the other MDB in the same folder and avoid running the linked table manager?
[Note : will be dumping access, but for now I need to patch features in]