I need to programmaticall y create a link to a table in an MDB on a CD, so I
can read data from it.
Access objects that it can't create an LDB file in the same directory as the
MDB.
Is there any way I can write the linked table's Connect property (I'm using
DAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)
Or is there another solution possible?
- Turtle
7  1899 
On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <ma********@nos pam.com>
wrote:
Not sure if this would work, but try the /readonly command line
argument for msaccess.exe
-Tom. I need to programmaticall y create a link to a table in an MDB on a CD, so I
can read data from it.
Access objects that it can't create an LDB file in the same directory as the
MDB.
Is there any way I can write the linked table's Connect property (I'm using
DAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)
Or is there another solution possible?
- Turtle
On May 28 2004, 05:30 am, Chuck Grimsby
<c.*******@worl dnet.att.net.in valid> wrote in
news:4c******** *************** *********@4ax.c om: On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <ma********@nos pam.com>
wrote:I need to programmaticall y create a link to a table in an MDB on a CD,
so I can read data from it.
Access objects that it can't create an LDB file in the same directory
as the MDB.
Is there any way I can write the linked table's Connect property (I'm
using DAO) to force exclusive access for this MDB? (That way no LDB
would be necessary.) Or is there another solution possible?
In Message-ID 3B************* **@uibk.ac.at, Helmut Kalb discovered
that the secret is to use the undocumented /EMBEDDING switch.
But this only helps to prevent the "read-only" message when opening the
database from CD. The OP is trying to link to a database on CD, not open it
in the Access UI. When opening the linked table, Access attempts to create
the ldb file for the database on CD, which fails.
--
remove a 9 to reply by email
Great idea, Tom,
but how do I use that when I'm trying to create a link programmaticall y?
"Tom van Stiphout" <to*****@no.spa m.cox.net> wrote in message
news:qm******** *************** *********@4ax.c om... On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <ma********@nos pam.com>
wrote:
Not sure if this would work, but try the /readonly command line
argument for msaccess.exe
-Tom.
I need to programmaticall y create a link to a table in an MDB on a CD, so
Ican read data from it.
Access objects that it can't create an LDB file in the same directory as
theMDB.
Is there any way I can write the linked table's Connect property (I'm
usingDAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)
Or is there another solution possible?
- Turtle
Thanks, Dimitri!
That's my problem exactly.
Ideas, anyone?
- Turtle
"Dimitri Furman" <df*****@cloud9 9.net> wrote in message
news:Xn******** *************** *****@127.0.0.1 ... On May 28 2004, 05:30 am, Chuck Grimsby
<c.*******@worl dnet.att.net.in valid> wrote in
news:4c******** *************** *********@4ax.c om:
On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <ma********@nos pam.com>
wrote:I need to programmaticall y create a link to a table in an MDB on a CD,
so I can read data from it.
Access objects that it can't create an LDB file in the same directory
as the MDB.
Is there any way I can write the linked table's Connect property (I'm
using DAO) to force exclusive access for this MDB? (That way no LDB
would be necessary.) Or is there another solution possible?
In Message-ID 3B************* **@uibk.ac.at, Helmut Kalb discovered
that the secret is to use the undocumented /EMBEDDING switch.
But this only helps to prevent the "read-only" message when opening the
database from CD. The OP is trying to link to a database on CD, not open
it in the Access UI. When opening the linked table, Access attempts to create
the ldb file for the database on CD, which fails.
--
remove a 9 to reply by email
Take a look at http://support.microsoft.com/default...b;en-us;208431
If that doesn't work, here's something else you can try: Before creating a
link, use SetOption to programmaticall y change the default database open
mode from shared to exclusive. Most likely, it applies only to databases
opened in Access UI, but it's worth a try.
On May 28 2004, 09:39 pm, "MacDermott " <ma********@NoS pam.com> wrote in
news:lR******** ***********@new sread1.news.pas .earthlink.net: Thanks, Dimitri!
That's my problem exactly.
Ideas, anyone?
- Turtle
"Dimitri Furman" <df*****@cloud9 9.net> wrote in message
news:Xn******** *************** *****@127.0.0.1 ... On May 28 2004, 05:30 am, Chuck Grimsby
<c.*******@worl dnet.att.net.in valid> wrote in
news:4c******** *************** *********@4ax.c om:
> On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <ma********@nos pam.com>
> wrote:
>>I need to programmaticall y create a link to a table in an MDB on a CD,
>>so I can read data from it. Access objects that it can't create an LDB
>>file in the same directory as the MDB.
>>Is there any way I can write the linked table's Connect property (I'm
>>using DAO) to force exclusive access for this MDB? (That way no LDB
>>would be necessary.) Or is there another solution possible?
>
> In Message-ID 3B************* **@uibk.ac.at, Helmut Kalb discovered
> that the secret is to use the undocumented /EMBEDDING switch.
>
But this only helps to prevent the "read-only" message when opening the
database from CD. The OP is trying to link to a database on CD, not open
it in the Access UI. When opening the linked table, Access attempts to
create the ldb file for the database on CD, which fails.
--
remove a 9 to reply by email
Can't you copy the DB from the CD onto the local drive?
--
Michael Hopwood
"MacDermott " <ma********@nos pam.com> wrote in message
news:Nl******** *********@newsr ead3.news.atl.e arthlink.net... I need to programmaticall y create a link to a table in an MDB on a CD, so
I can read data from it.
Access objects that it can't create an LDB file in the same directory as
the MDB.
Is there any way I can write the linked table's Connect property (I'm
using DAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)
Or is there another solution possible?
- Turtle
Many thanks to all who replied here.
To the last question -
yes, if it were just me, I could copy from a CD to a local file.
But I'm writing this application for some folks who are not especially
technically inclined, and they will be receiving the source data on a CD,
so I'm trying to make it as easy as possible for them.
My face is a bit red now, because I'm pretty sure I've tracked the problem
down.
This being personal information, I had secured it pretty tightly with a
workgroup file.
In my zeal, I had removed permission for anybody but the "Administra tor"
group to open the file exclusively.
Hope nobody else has this problem, but if you do -
check your permissions!
- Turtle
"MacDermott " <ma********@nos pam.com> wrote in message
news:Nl******** *********@newsr ead3.news.atl.e arthlink.net... I need to programmaticall y create a link to a table in an MDB on a CD, so
I can read data from it.
Access objects that it can't create an LDB file in the same directory as
the MDB.
Is there any way I can write the linked table's Connect property (I'm
using DAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)
Or is there another solution possible?
- Turtle
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Shawn Windle |
last post by:
----begin node.h--------
#ifndef NODE_H
#define NODE_H
#include <iostream> //NULL
using namespace std;
class node
{
|
by: sudhirlko2001 |
last post by:
How to swap two nodes of doubly Linklist
|
by: Darren Clark |
last post by:
I have a link button that i would like to be used if the value of the text is NOT 0...
So the code below will always make a linkbutton....
However if the value of "DataBinder.Eval(Container,"DataItem."+ JR.Core.Data.JobseekerData.FLD_SEARCH_MATCHES) " is 0 i do not want the the 0 to become a link.... I simply want to display it as text.
How can i do this?
<asp:LinkButton
CommandArgument='<%# DataBinder.Eval(Container,"DataItem."+...
|
by: Jeff |
last post by:
This a little strange.
The link in a FE database get corrupted when the BE get compacted, and the
FE is not even open.
I have checked. The data is fine in the BE. The data is fine in the link in
the FE before compacting the BE. I shutdown the FE and then compact the BE.
Open the FE and the data 'looks' corrupt. In data sheet view the first
columns on the left are okay. Then the last several rows have been shifted
to the right and some...
|
by: sri2097 |
last post by:
Hi all, I have written a Link list implementation in Python (Although
it's not needed with Lists and Dictionaries present. I tried it just
for the kicks !). Anyway here is the code -
# Creating a class comprising of node in Link List.
class linklist:
def __init__(self, data=None,link=None):
self.data = data
self.link = link
| | |
by: Mica Cooper |
last post by:
Hi,
I need to pass some info in a javascript submit.
<a href="javascript:document.formName.submit();">Submit Form</a>
Normally a link would do page.jsp?x1=1&x2=2&x3=3 and you would pull x1, x2,
x3. I have no clue how to do this with a link submit.
Thanks,
|
by: mendiratta |
last post by:
Hello,
I am Learning Link List. Today wrote a simple program, but not working. Program is like this
#include<stdio.h>
#include<stdlib.h>
#include<alloca.h>
struct node{
int data;
struct node *link;
|
by: ADezii |
last post by:
Rather than using CurrentProject.Connection or entering your own Connection information, ADO supports storing Connection information in an external file called a Data Link File (which normally has a *.UDL extension). Data Link Files provide two very important capabilities:
They implement a graphical interface for constructing what can be complex and confusing OLE DB Connection Strings.
They offer a way to allow Users to edit Connection...
|
by: trpost |
last post by:
I am looking for a way to send data from one page to another as POST
data without using forms or cURL.
I have a php script that is passing a list of cases from on page to
another when a link is clicked. This is working fine for the most part
as a link, but sometimes the list gets very large and gets cut off.
The reason it gets cut off appears to be a limitation on the amount of
data that can be passesd in the URI.
It looks like I can...
|
by: johnnash |
last post by:
i'm declaring a data structure for link list of integers in A.h
#ifndef A_H (can anyone please explain how ifndef works as well..i
just seem to see it in almost every program)
#define A_H
typedef struct node nodestruct
{
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
