Not quite sure if this is the right forum, my apologies if not.
I am looking to set up a database using Access, and have a table linked to a .csv document.
I am using ASP to connect to this database.
This works on my machine, however, I need to be able to get it online.
The problem I am having, is specifying a relative path to the csv file. When the table is made, it always uses an absolute path from C:/...
So when I upload and try to connect, I get an error stating the file can't be found - because the table is trying to find the path on my machine from C:/ etc...
Is there any way around this - can't seem to link to a web csv file either?
This is why I need to link using a relative path from the mdb file - link "linked_data/someFile.csv".
Thanks for any hellp, at all here.
I am looking to set up a database using Access, and have a table linked to a .csv document.
I am using ASP to connect to this database.
This works on my machine, however, I need to be able to get it online.
The problem I am having, is specifying a relative path to the csv file. When the table is made, it always uses an absolute path from C:/...
So when I upload and try to connect, I get an error stating the file can't be found - because the table is trying to find the path on my machine from C:/ etc...
Is there any way around this - can't seem to link to a web csv file either?
This is why I need to link using a relative path from the mdb file - link "linked_data/someFile.csv".
Thanks for any hellp, at all here.