By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,222 Members | 1,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,222 IT Pros & Developers. It's quick & easy.

Backend Database on Web Server

P: n/a
HB2

I am using the Linked Table Manager in Access to try and connect my front
end database (on my desktop) to my backend database (on my web host) I get
an invalid name error.

Any help much appreciated.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
Access doesn't recognize the http protocol (nor ftp, for that matter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:Bl2sc.99518$iF6.9213519@attbi_s02...

I am using the Linked Table Manager in Access to try and connect my front
end database (on my desktop) to my backend database (on my web host) I get
an invalid name error.

Any help much appreciated.

Thanks

Nov 13 '05 #2

P: n/a
HB2
Any suggestions on how to make the connection?

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:uN********************@news04.bloor.is.net.ca ble.rogers.com...
Access doesn't recognize the http protocol (nor ftp, for that matter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:Bl2sc.99518$iF6.9213519@attbi_s02...

I am using the Linked Table Manager in Access to try and connect my front end database (on my desktop) to my backend database (on my web host) I get an invalid name error.

Any help much appreciated.

Thanks


Nov 13 '05 #3

P: n/a
You need to be able to connect to the share on the server. If you can't
(such as I assume is the case if this is on a website hosted by a 3rd
party), I don't believe you have any option but to download a copy of the
backend, make your updates, then upload it again.

Alternatively, you can try redoing your application as an ASP page, if your
ISP supports that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:rW2sc.26418$zw.16402@attbi_s01...
Any suggestions on how to make the connection?

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:uN********************@news04.bloor.is.net.ca ble.rogers.com...
Access doesn't recognize the http protocol (nor ftp, for that matter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:Bl2sc.99518$iF6.9213519@attbi_s02...

I am using the Linked Table Manager in Access to try and connect my front end database (on my desktop) to my backend database (on my web host) I get an invalid name error.

Any help much appreciated.

Thanks



Nov 13 '05 #4

P: n/a
You can work on your tables in code by connecting to them, but I don't
think you can link them. (So you'd be "back to basics" as if you were
doing an ASP page or something).

Or, depending on the size of your tables, read the tables and copy data
to local temporary tables... ?

Bradley

Douglas J. Steele wrote:
You need to be able to connect to the share on the server. If you
can't (such as I assume is the case if this is on a website hosted by
a 3rd party), I don't believe you have any option but to download a
copy of the backend, make your updates, then upload it again.

Alternatively, you can try redoing your application as an ASP page,
if your ISP supports that.
"HB2" <bg******@comcast.net> wrote in message
news:rW2sc.26418$zw.16402@attbi_s01...
Any suggestions on how to make the connection?

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
message
news:uN********************@news04.bloor.is.net.ca ble.rogers.com...
Access doesn't recognize the http protocol (nor ftp, for that
matter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:Bl2sc.99518$iF6.9213519@attbi_s02...

I am using the Linked Table Manager in Access to try and connect
my front end database (on my desktop) to my backend database (on
my web host) I get an invalid name error.

Any help much appreciated.

Thanks


--
regards,

Bradley
Nov 13 '05 #5

P: n/a
Even if you could link to a remote back-end, you would quickly corrupt your
data because of the instability of the WAN. Access/Jet is only reliable on a
LAN. If you somehow solved the reliability problem, you would have an
extremely slow application because all the data has to be transmitted to the
workstation when running a query. I use Terminal Server/Citrix and a VPN for
WEB access to my Access application, The application runs on the LAN and
only the UI is transmitted.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:uN********************@news04.bloor.is.net.ca ble.rogers.com...
Access doesn't recognize the http protocol (nor ftp, for that matter).

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"HB2" <bg******@comcast.net> wrote in message
news:Bl2sc.99518$iF6.9213519@attbi_s02...

I am using the Linked Table Manager in Access to try and connect my front end database (on my desktop) to my backend database (on my web host) I get an invalid name error.

Any help much appreciated.

Thanks


Nov 13 '05 #6

P: n/a
Rob
"paii, Ron" <pa**@packairinc.com> wrote in message news:<10*************@corp.supernews.com>...
Even if you could link to a remote back-end, you would quickly corrupt your
data because of the instability of the WAN. Access/Jet is only reliable on a
LAN. If you somehow solved the reliability problem, you would have an
extremely slow application because all the data has to be transmitted to the
workstation when running a query. I use Terminal Server/Citrix and a VPN for
WEB access to my Access application, The application runs on the LAN and
only the UI is transmitted.


Ron, How do I get ahold of you. (your email address gets kicked back)
I have a question about Access and Citrix.
Please email me at si****@ensco.com
Thanks,
Rob
Nov 13 '05 #7

P: n/a
Rob
"paii, Ron" <pa**@packairinc.com> wrote in message news:<10*************@corp.supernews.com>...
Even if you could link to a remote back-end, you would quickly corrupt your
data because of the instability of the WAN. Access/Jet is only reliable on a
LAN. If you somehow solved the reliability problem, you would have an
extremely slow application because all the data has to be transmitted to the
workstation when running a query. I use Terminal Server/Citrix and a VPN for
WEB access to my Access application, The application runs on the LAN and
only the UI is transmitted.


Ron, How do I get ahold of you. (your email address gets kicked back)
I have a question about Access and Citrix.
Please email me at si****@ensco.com
Thanks,
Rob
Nov 13 '05 #8

P: n/a
si****@ensco.com (Rob) wrote:
Ron, How do I get ahold of you. (your email address gets kicked back)
I have a question about Access and Citrix.


Why not just ask in the newsgroup?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #9

P: n/a
Rob
Sure, here goes, but I posted this question as its own thread.

I am an Access developer and have done many Access databases in the
standard Front-end on the workstations, backend on the server
(over a LAN) but have never worked with Access over Citrix, though
that situation is coming up for me shortly.

Question: When you run the front-end on the Server, does Citrix clone
the front
end application database file for each user that connects or do they
all connect
to physically the same front-end file?
The real question here is: If user1 adds rows to a table that is
local in the
front-end will user 2 be able to see those records (assuming they have
the
proper table permissions)? If they were running in physically the
exact same
front-end file, they would be able to see each others records. If
Citrix gives
each user their own workspace and a copy of the front-end, they
wouldn't.
Any enlightenment you could provide would be appreciated.
Thanks
Nov 13 '05 #10

P: n/a

"Rob" <si****@ensco.com> wrote in message
news:bd*************************@posting.google.co m...
Sure, here goes, but I posted this question as its own thread.

I am an Access developer and have done many Access databases in the
standard Front-end on the workstations, backend on the server
(over a LAN) but have never worked with Access over Citrix, though
that situation is coming up for me shortly.

Question: When you run the front-end on the Server, does Citrix clone
the front
end application database file for each user that connects or do they
all connect
to physically the same front-end file?
The real question here is: If user1 adds rows to a table that is
local in the
front-end will user 2 be able to see those records (assuming they have
the
proper table permissions)? If they were running in physically the
exact same
front-end file, they would be able to see each others records. If
Citrix gives
each user their own workspace and a copy of the front-end, they
wouldn't.
Any enlightenment you could provide would be appreciated.
Thanks


Each user must get there own front end, I store it in the user's home
directory. Setup each Terminal Server user as if they are using a normal
work station.

Access if VERY demanding on the hardware. I have 1GB of memory for 15 users
on each of my Terminal servers. The servers are Compact with (2) 450mhz PII,
Running Window 2000 and Access 97, each can handle 10 to 15 concurrent
Access users.

Download installation instruction for Access on Terminal server from MS
website. Each version of Access will need special tweaking to run.

Access 97 needed each user to be a member of a Group with write access the
system32 directory. Note: this access must be though a user defined group,
not directly to the user.
Nov 13 '05 #11

P: n/a
si****@ensco.com (Rob) wrote:
Sure, here goes, but I posted this question as its own thread.


I've responded elsewhere.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.