Re: Linking to back end on a web server ?
- From: mscertified <rupert@xxxxxxxxxxxxx>
- Date: Tue, 22 May 2007 11:46:01 -0700
Thanks for your advice so far. The saga contuinues... I set up a System DSN
in ODBC connections.
When I do the File--Get External Data and select the DSN, here is what I
get, any ideas? I don't know what it means by "<SQL Database>".
"You cannot use ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database. (Error 3423)"
You are attempting to link, import data from, or export data to either an
external Microsoft Jet table or an external ISAM database table (for example,
dBASE, Microsoft® FoxPro®, Paradox, or Btrieve), but you have selected <SQL
Database> as the data source. You must select the appropriate data source for
the data you are attempting to link.
"Douglas J. Steele" wrote:
You'll have to talk to the administrator of that server. Either no share has.
been created, the shares are hidden, or you haven't been given permission to
even see the shares. Even if you can't browse to the file (such as will be
the case if the share is hidden), you can type the full path to the file.
Once you've create the DSN, you go through File | Get External Data | Link
Tables and select "ODBC Databases()" from the Files of Type list.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:C67933E7-5D48-4722-8162-E084ABF9AD30@xxxxxxxxxxxxxxxx
Do you know how to create a DSN?
I went into Control-panel settings and tried but it expects me to browse
to
the database and I cannot get into the server to display the folders
Also, assuming I can create the DSN, how do I use that to link to the back
end tables?
"Douglas J. Steele" wrote:
If you can see the server, you should be able to create a DSN and link to
it. Once you've linked to it using a DSN, you should then be able to
change
that DSN-based connection to a DSN-less connection.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:F48B8733-30D7-49AF-B2B3-BBFA7B90E772@xxxxxxxxxxxxxxxx
I do see this server in 'My network places', so i believe it's on the
network.
Are you saying to get to the data, I'd have to open an ADO connection
and
read the data via ODBC?
"Rick Brandt" wrote:
mscertified wrote:
Does anyone know how to link my front end to a back end sitting on a
web server?
There is a userid and password required for the web server and the
back end is also protected by an Access password.
Can this even be done?
Thanks.
No. An Access link requires being able to see and open the back end
file
like you would on a local drive or local network. An internet
connection
over HTTP does not allow for that.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
- References:
- Re: Linking to back end on a web server ?
- From: Rick Brandt
- Re: Linking to back end on a web server ?
- From: Douglas J. Steele
- Re: Linking to back end on a web server ?
- From: Douglas J. Steele
- Re: Linking to back end on a web server ?
- Prev by Date: find and replace data in a text file using VBA from Access
- Next by Date: Re: Linking to back end on a web server ?
- Previous by thread: Re: Linking to back end on a web server ?
- Next by thread: Re: Linking to back end on a web server ?
- Index(es):
Relevant Pages
|
