Access database linking to SQL server isses

[Arch_art]

Hi,

I set up a project that use SQL server. Now, I am trying to linking Access to SQL server so that I can do some data update from there.

when I use the "imprt the source data..."option,

the data is appeared properly. See image below:

but, when I choose, "link the data source... " option, the data being display in this way:

What can I do to fix this?

I need to be able to make some link to update the data more effectively. Any thoughts?

By the way, I am use Plant 3D 2012, Access 2010, and SQL server express 2012.

Cheers,

Peggy Lin

[mikael]

Hi,

Maybe something helpful through this link:

http://support.microsoft.com/kb/128809

//Mikael

[TomislavGolubovic]

Peggy, wouldn't using the Data Manager be more effective? Export the Data, edit in Excel, then import back in.

[Arch_art]

Hi, Tom

It is not that effective with my last project (only with 20+ P&ID drawings). Exporting to excel is easy and quick. But importing it back to Plant 3D is quite time consuming (this is Plant 3D 2012, if there is anything changes after this, update me please). Often you can't just select all of the items that needs to be updated to update, Plant 3D will stop, you will have to break it down to udpate bit by bit. And it always need to open the drawings to update as well. If you have a lot of drawings, how long it will take? Further more, uring the intensive design period, in order to make sure the data are correct, we have to export and import very frequently. That is the reason that I want to look into it to see if I can improve this process by the other way. I might go back to data manager in the end, if there is no better way of doing it.

This is all based on the assumtion that we have to put all of data into Plant 3D database.

The other day, I found the "External Database Reference Manager", I am not able to find "Microsoft Office 12.0 Access Database Engine" from the list. So I can't test what is this function do. Can the external data be maped and linked with Plant 3D?

Cheers,

Peggy Lin

[TomislavGolubovic]

---

@Arch_art wrote:

Hi, Tom

It is not that effective with my last project (only with 20+ P&ID drawings). Exporting to excel is easy and quick. But importing it back to Plant 3D is quite time consuming (this is Plant 3D 2012, if there is anything changes after this, update me please). Often you can't just select all of the items that needs to be updated to update, Plant 3D will stop, you will have to break it down to udpate bit by bit. 

Cheers,

Peggy Lin

---

When you import from Data Manager, you do get the option to "Accept all changes" in the Data Manager.

As for the SQL Link, I'm not 100% sure on it, perhaps someone else can chime in.

[Arch_art]

Hi, Tom

I do forget that is a good option. I will give it a go on update the data.

The other issue that I forgot to mention is to filter the data you want. What I did was to manually change the .xml. It seems that it would be better if I can just use SQL query from access. This might be a stuip question: Any where I can find a data relationship map? save me sometime to export the data myself to find the link?

Anyway to add "current time" to the item when item is created? This helps engineers to know when the item was added, so that this can be easiler filtered. Then we can reduce the frequency of import & export data. That can help for effectioncy as well. I can't find a acquisition rule on "add a current time".

Cheers,

Peggy Lin