Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Linked tables in MS access used by IIS problem

Posted on 2004-04-16
6
Medium Priority
?
568 Views
Last Modified: 2012-05-04
Situation:
Got a Web-server running IIS. On the local disk got an mdb-file with 2 linked tables to two other mdb-files (tables) located on another server (file-server).
In an ASPscript I'm connecting to a query; this query has information of a table in the local mdb and the 2 linked tables.
Problem: the webbrowser (on a client machine)errors saying the specified drive of the linked tables is not correct.
Tried to fix this by setting up the to remote mdb-files as ODBC's; but the local access won't let me link via ODBC to it.

Anyone a good idea how to solve this?
Thanks,
Toto.
0
Comment
Question by:Totosh
  • 3
  • 3
6 Comments
 
LVL 1

Expert Comment

by:phL
ID: 10845168
If you are using drive letters for your linking (D:\, E:\, etc.) that could be the problem.  Use server names, if possible.
0
 

Author Comment

by:Totosh
ID: 10858164
PHL,
Thought about that too but getting a permissions problem on the page now:
 Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file '\\server\directory\datafile.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

The datafile.mdb file is the original table; so basically the link works but now getting permission problems.

Any ideas how to work-around or solve this?
Toto.


0
 
LVL 1

Expert Comment

by:phL
ID: 10860117
Datafile.mdb is on the webserver and now your ASP page connects to it with a connection path that uses server names instead of file letters.  That is good.  Datafile.mdb has two linked tables that refer to a database on another server (file server).  These links should also use server names instead of file letters.

You should also check to make sure you can access the database on the file server directly.  Also, is there any chance it is actually opened exclusively by another user?  This also occurs if any object in that database is in design view.  Is there any possibility of moving that database to the web server?  If the linked tables are read only and updated infrequently, could local copies be imported?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:Totosh
ID: 10928998
Phl,

Sorry for the late reply.
No - moving the applications/database to the web-server is not an option.
But I made a small program that is importing the needed tables.

Other and related issue with this is the size of the mdb-file. When importing these tables; the size of the mdb-file is (of course) getting bigger and bigger.
Is there a way I can compact the mdb-file automatically (via code or macro)?

Cheers,
Toto.
0
 
LVL 1

Accepted Solution

by:
phL earned 750 total points
ID: 10929285
The Access Web has some code to compact a database:
http://www.mvps.org/access/modules/mdl0020.htm

It should be done when no one is using it.
0
 

Author Comment

by:Totosh
ID: 10929793
Thanks.
Cheers,
TOTO.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question