I am developing an Access 2007 database using the Assets template in a dev directory on our server. It's split and the back end data portion of the database is stored in the same directory as the front end. The front end has customized reports, queries, forms that I need preserved across future versions. This front end and back end will need to be moved to another server when we want to 'go live' with this database so users over a network can use it.
The problem is when I copy the front end and back end to another directory on the server (say sibling level), relink all the tables, and test that everything works fine, I am unable to delete any of the folders in the path to the Original back end database. This is because in the MSysObjects table there is a record which stores the path to the original back end db, although it is not used or referred to anywhere else in my code/tables/controls/etc.. This record is only created when you copy the database file (using .accdb btw). This record also has a field that says something along the lines of '...ComplexType...' and has '6' in the type field (which i believe means its the type of table).
I receive an error message like 'path [path to original dev backend db] does not exist', and, of course, I am unable to edit the record in the MSysObjects (normally a good thing).
Does anyone know how to:
a. remove this record from MSysObjects
b. edit this record to point to the new/correct location of the back end db
c. copy a database front end without this record getting inserted into MSysObjects
e. other solution
Note: Accidentally posted in VB section - reposting here in correct Access/VBA category
9  2511 
Are you talking about the Database field of that table? That changes when you use the Linked Table manager. AFAIK, Access does not keep track of your original development location. Maybe you are looking at a table that is no longer in the BackEnd and so can not be linked.
Hello RuralGuy, thanks for your help.
All the links to the tables in my Backend are there and good, and I can update them with the Link Table Manager with no problem. And in the Backend db in my new location, all the tables I need are there.
There is an additional link stored in the MSysObjects of the new db that points to the original backend location. I don't know how it gets there because it is only created when I copy the front end to a new location. In this system table MSysObjects, I also see the links to the tables (which are correct after I relink them to the new be db) stored in MSysObjects.
The system table MSysObjects in the original location does not have this record. I'll post the exact records data here tomorrow to better show what it is that is being automatically inserted.
As I asked, is this in the Database field of the table? Is it pointing to a particular table in the Name field of that table?
Oh sorry, I'll let you know tomorrow what it says exactly, but the path is the the Database field
Hello,
yeah the Database field is the path to where I first created the database backend before moving it
the Name field of this record is: MSysComplexTypeVH_1CA2435D69A742F498B36C3C73E48216
This link below explains that this issue is most likely caused by the new Attachments field http://bytes.com/topic/access/insigh...orking-correct
We decided to move our db up as one, then split it on our live server, as we do not get this error when the db is not split.
It would be interesting to learn more about why/how this path can/cannot be changed.
Thanks for your help anyway : )
Hmm...Does the attachment field still work as expected? I'll admit I have not used them yet.
In this case (when the invalid path alert comes up) I cannot open my Datasheet, so I cannot get to the Attachments.
When I restore the path to the original location, everything works fine. The original database is not even Used (because I relinked my tables).
It is peculiar.
Makes me suspect that the attachment is not really in a "field" in the db but simply linked. If the link were a UNC value it might work.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: EJO |
last post by:
In a post about an unrelated issue, I described the setup being used in
my workgroup, and was told that under TS each user should have their
own working copy in seperate folders. I am hoping to...
|
by: Terry Bell |
last post by:
We've had a very large A97 app running fine for the last seven years.
I've just converted to SQL Server backend, which is being tested, but
meanwhile the JET based version, running under terminal...
|
by: Sekhar |
last post by:
I want to access a shared folder of a different machine (Mapped to my
server) say E:\ (which is actually "\\myothermac\c$\somefolder") from
C#.
If I use
string strFolder = "E:\myNewFolder";
if...
|
by: B1ackwater |
last post by:
We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a...
|
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting...
|
by: ARC |
last post by:
Hello All,
I have a major application for quoting and invoicing that is written in
Access 97 (both front and back ends). I have a user base of over 300
customers, and currently I don't require...
|
by: ARC |
last post by:
Hello All,
I have a major application for quoting and invoicing that is written in
Access 97 (both front and back ends). I have a user base of over 300
customers, and currently I don't require...
|
by: TheScullster |
last post by:
Hi all
This must have been covered already, but Google (or my use thereof) is
failing me!
We have a company database originally created in Access 2000.
The backend is located on a Win2003...
|
by: Brian Nelson |
last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm
just stuck!
We've had a multiuser .mdb file on a network share for years. I know
it's not ideal, but it's worked well from...
|
by: Snoopy33 |
last post by:
I have a DB that I developed on access XP (2002) and deployed over a
year ago. No one has had problems printing any of the reports within
the DB until we started loading 2007 on new computers. ...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
