I upsized my Asset Template .accdb to SQL Server 2008. Every field except the Attachments works as expected.
I tried changing the datatype of the Attachments field in the SQL Server table, no types would get the Attachments field to work.
We don't have the time to spend coding VBA to handle attachments ourselves (possibly with storing the path to the file in the db and making our own upload form).
Is...
bkernan
Last Activity: Apr 28 '10, 12:06 PM
Joined: Apr 18 '10
Location:
-
Upsizing Access 2007 .accdb with Attachments to SQL Server 2008
-
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. -
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: MSysComplexType VH_1CA2435D69A7 42F498B36C3C73E 48216
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...Leave a comment:
-
Oh sorry, I'll let you know tomorrow what it says exactly, but the path is the the Database fieldLeave a comment:
-
Thanks for this post, i have a very similar issue with copying my access dbs and getting stuck on an invalid path which I can only find to be stored in MSysObjects.
I'll try your solution and post if it works for others who have a similar issue.Leave a comment:
-
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...Leave a comment:
-
Access 2007 Assets copy front end db to new directory Issue
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... -
Access 2007 Assets copy front end db to new directory Issue
Hello and thanks for your time,
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...
No activity results to display
Leave a comment: