In web folder, I cannot import tables in an access database file

  • Thread starter Thread starter Beefminator
  • Start date Start date
B

Beefminator

Hello,

In the web folder, I have two database files in the "fpdb" folder.

If I open up one of the database files and try to import a table from
the other database file, I get a "Not a valid file name. (Error 3055)"
message.

Thanks,
Jason
 
Export both databases to your desktop, then try it. When finish you must re-import the databases
into the fpdb folder.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Tom,

This did not work.

When you create the table link in your database and then export the
database back into the web folder, the database still looks for the
table link on your hard drive.

I try "updating" the file path for the table link, but it brings me
back to my original problem.

Jason
 
I need to clarify my issue.

I would like to "link tables" not "import tables" in the web folder.
 
You can not use the linked table manager in Access for an access DB used on a web server
- the linked table manager requires a fixed path to the back end DB

Instead of the linked tables
- Import your required tables into your DB used on your server

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I need to clarify my issue.
|
| I would like to "link tables" not "import tables" in the web folder.
|
 
Hey Stefan,

I wanted to let you know that there is a way to "link tables" between
two or more databases in a web folder.

I contacted my web host, and they told me that I would not be able to
directly link the databases using my computer because the database path
will change from my local computer to the server. They told me that I
need to replicate a file path. They instructed me to create a specfic
file path on my local computer and make the links between databases.
Then upload the databases to the web server.

Thanks,
Jason
 
They are technically correct
- but you are using 2 DB connections when only 1 is needed
- and there is no functional advantage of having link tables except as a front/back end

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hey Stefan,
|
| I wanted to let you know that there is a way to "link tables" between
| two or more databases in a web folder.
|
| I contacted my web host, and they told me that I would not be able to
| directly link the databases using my computer because the database path
| will change from my local computer to the server. They told me that I
| need to replicate a file path. They instructed me to create a specfic
| file path on my local computer and make the links between databases.
| Then upload the databases to the web server.
|
| Thanks,
| Jason
|
 
Back
Top