Hi

[zadiac8318]

I am new to this forum and I am looking forward to learn alot about it.

Anyway, I have a problem.

I have created a table through "Link Tables..." in the table object in Access with Excel. However, as I was burning the two files(Access and Excel File) to a blank CD, the link is broken. Is there a way to make it work??

Thanks in Advance.

 

[mcadle]

When you originally linked the file it had a full path i.e. c:\user\file.xls so when you burned it all to a cd and are running the DB from the cd (I think this is what you are doing) it is looking for the file at the full path and not the path as related to the cd. If this makes any sense. So..to fix it you would have set the link to be the anticipated path i.e. e:\file.xls

If this is not what you are doing then sorry I wasted your time.

 

[zadiac8318]

Hi,
Thank you for your reply.
But, could you please be more specific and tell me how to do it?

Thanks in advance

 

[Ron_dK]

I have created a table through "Link Tables..." in the table object in Access with Excel. However, as I was burning the two files(Access and Excel File) to a blank CD, the link is broken.

If you have copied the Dbase and the Excel spreadsheet on a CD, open the Dbase and restore the link. I don't think that in simply copying the Dbase (and the spreadsheet) you can copy the link(path) with it.
As said, once on CD, open the Dbase > file > get external data > link tables
and that should re-establish the link between Dbase and XLS.

 

[zadiac8318]

But, Once I have burned it on CD, Dbase becomes Read-Only File.

Any suggestions?

 

[zadiac8318]

I need help please~!

 

[Ron_dK]

I have no experience with writing Dbases to CD, but have you tried to open the Dbase ( on CD) in the Open Exclusive mode. If this is possible it would allow you to re-establish the links.

 

[zadiac8318]

But I cannot do that since it becomes Read Only file and I cannot alter anything.

 

[Damonpc]

It appears to me that the link will need to be established when you copy the database back to a readable drive. If you are going to put them back where they were this should work fine, anywhere else will need the link to be established anew.

Why do you need the link on the CD when as you say you cannot do anything with it, eg test it?

Hope this helps

Damon

 

[mcadle]

OK I went and played with this a little bit. The only way I could get it to work was to do this.

Burn to cd the excel file. Then open the database from your hard drive and link the file via file - get external data - link LINKING the file on the cd. Now save the db and burn both the DB and excel file to cd. It will run now.

HERE IS THE BIG PROBLEM WITH THIS:

It worked once then it didn't on a different computer. As long as the computer running the DB has the same drive mapping for the CD-ROM then everything worked fine. I moved to a different computer with different mapping and it still worked. BUT then I move to another that had the same style of mapping and it didn't work. It was looking for the old path of d: instead of the machines e:

So...this might be a solution but then it might not.