I posted a question a couple of days ago about running different versions of
Access for the frontend versus the backend databases. Got some good advice
but now I've received this information:
"We are currently running AppleShare IP 6.3 and this allows machines running
Windows to connect via IP."
So the first choice of server is a Mac. The client is willing to buy a
Windows machine if necessary but would like to use an existing server if
possible. Could anyone advise me please? Could my database function if the
backend was on a Mac/not running Access? (My initial thought is no, that
the file systems would be different).
thx
Linda 10 2075
Squirrel wrote: I posted a question a couple of days ago about running different versions of Access for the frontend versus the backend databases. Got some good advice but now I've received this information:
"We are currently running AppleShare IP 6.3 and this allows machines running Windows to connect via IP."
So the first choice of server is a Mac. The client is willing to buy a Windows machine if necessary but would like to use an existing server if possible. Could anyone advise me please? Could my database function if the backend was on a Mac/not running Access? (My initial thought is no, that the file systems would be different).
File systems shouldn't bother you. My backend currently is on a unix
machine. That is fine, as long as the file sharing mechanism does its work.
The Mac should support the smb protocol in sharing files. I can't
remember whether it does. Maybe the Apple site can tell you more.
--
Bas Cost Budde http://www.heuveltop.nl/BasCB
On Thu, 05 Feb 2004 09:04:22 +0100, Bas Cost Budde <ba*@heuveltop.org> wrote: Squirrel wrote: I posted a question a couple of days ago about running different versions of Access for the frontend versus the backend databases. Got some good advice but now I've received this information:
"We are currently running AppleShare IP 6.3 and this allows machines running Windows to connect via IP."
So the first choice of server is a Mac. The client is willing to buy a Windows machine if necessary but would like to use an existing server if possible. Could anyone advise me please? Could my database function if the backend was on a Mac/not running Access? (My initial thought is no, that the file systems would be different).
File systems shouldn't bother you. My backend currently is on a unix machine. That is fine, as long as the file sharing mechanism does its work.
The Mac should support the smb protocol in sharing files. I can't remember whether it does. Maybe the Apple site can tell you more.
Actually, Access has a history of being very picky about its back-end server.
Only the fery best Netware engineers have ever made that work, and until
recently, SAMBA was pretty much a no-go, too. Squirrel is asking about using
AppleShare, and I don't know if that will work well or not, but there's a good
chance it won't. On OS X, you can probably run SAMBA 2.x, and that might even
be what it's doing by already, but I wouldn't be too sure about anything on OS
9.
On Wed, 4 Feb 2004 16:59:20 -0800 in comp.databases.ms-access,
"Squirrel" <wi*****@covad.net> wrote: I posted a question a couple of days ago about running different versions of Access for the frontend versus the backend databases. Got some good advice but now I've received this information:
"We are currently running AppleShare IP 6.3 and this allows machines running Windows to connect via IP."
So the first choice of server is a Mac. The client is willing to buy a Windows machine if necessary but would like to use an existing server if possible. Could anyone advise me please? Could my database function if the backend was on a Mac/not running Access? (My initial thought is no, that the file systems would be different).
In theory the filesystem used on the server should not matter as it's
the workstation doing the work, e.g. you can have a MDB file on a
Linux ext2 partition. Your workstation doesn't know the difference as
the server makes it look like a network disk so in theory (that word
again) it should be possible but in practice, you may experience
locking problems, ISTR people here not having much luck with
Linux/Samba.
--
A)bort, R)etry, I)nfluence with large hammer.
Steve Jorgensen wrote: Actually, Access has a history of being very picky about its back-end server. Only the fery best Netware engineers have ever made that work, and until recently, SAMBA was pretty much a no-go, too. Squirrel is asking about using AppleShare, and I don't know if that will work well or not, but there's a good chance it won't. On OS X, you can probably run SAMBA 2.x, and that might even be what it's doing by already, but I wouldn't be too sure about anything on OS 9.
Are Samba versions for MacOS comparable to unix versions? I have had
Samba 1.9 without complaints from Access (97 that is)
--
Bas Cost Budde http://www.heuveltop.nl/BasCB
On Thu, 05 Feb 2004 10:49:40 +0100, Bas Cost Budde <ba*@heuveltop.org> wrote: Steve Jorgensen wrote: Actually, Access has a history of being very picky about its back-end server. Only the fery best Netware engineers have ever made that work, and until recently, SAMBA was pretty much a no-go, too. Squirrel is asking about using AppleShare, and I don't know if that will work well or not, but there's a good chance it won't. On OS X, you can probably run SAMBA 2.x, and that might even be what it's doing by already, but I wouldn't be too sure about anything on OS 9.
Are Samba versions for MacOS comparable to unix versions? I have had Samba 1.9 without complaints from Access (97 that is)
You made that work? Multi-user? I was told that that pretty much didn't
work, but 2.x worked well.
I don't know anything for sure about what SAMBA options are or aren't
available for OS X, I was just assuming SAMBA 2.0 should be able to run pretty
much unchanged because it works identically on many other different 'NIXes,
and OS X is based around a pretty standard BSD kernel. I wouldn't be
surprised if the OS X files haring for Windows is already SAMBA under the
hood.
Steve Jorgensen wrote: Are Samba versions for MacOS comparable to unix versions? I have had Samba 1.9 without complaints from Access (97 that is) You made that work? Multi-user? I was told that that pretty much didn't work, but 2.x worked well.
To be honest, I never tried to break it. I had only two users for the
application then ;-)
files haring for Windows
Uh? oh, fil esharing. I see. <G>
--
Bas Cost Budde http://www.heuveltop.nl/BasCB
Steve, Bas, Trevor,
Thank you very much for your advice. I will try installing the backend on
their Mac and will be pleasantly surprised if it works. :-) These are
non-technical people and I need to leave them with a system which is easily
understood and maintained. Thank you so much for your help.
Linda
"Trevor Best" <bouncer@localhost> wrote in message
news:p1********************************@4ax.com... On Wed, 4 Feb 2004 16:59:20 -0800 in comp.databases.ms-access, "Squirrel" <wi*****@covad.net> wrote:
I posted a question a couple of days ago about running different versions
ofAccess for the frontend versus the backend databases. Got some good
advicebut now I've received this information:
"We are currently running AppleShare IP 6.3 and this allows machines
runningWindows to connect via IP."
So the first choice of server is a Mac. The client is willing to buy a Windows machine if necessary but would like to use an existing server if possible. Could anyone advise me please? Could my database function if
thebackend was on a Mac/not running Access? (My initial thought is no, that the file systems would be different).
In theory the filesystem used on the server should not matter as it's the workstation doing the work, e.g. you can have a MDB file on a Linux ext2 partition. Your workstation doesn't know the difference as the server makes it look like a network disk so in theory (that word again) it should be possible but in practice, you may experience locking problems, ISTR people here not having much luck with Linux/Samba.
-- A)bort, R)etry, I)nfluence with large hammer.
Steve Jorgensen <no****@nospam.nospam> wrote: Are Samba versions for MacOS comparable to unix versions? I have had Samba 1.9 without complaints from Access (97 that is)
You made that work? Multi-user? I was told that that pretty much didn't work, but 2.x worked well.
Ah, thanks both for your comments. I'll add them to the Corruptions FAQ Causes Samba
page.
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
On Thu, 05 Feb 2004 23:36:24 GMT, Tony Toews <tt****@telusplanet.net> wrote: Steve Jorgensen <no****@nospam.nospam> wrote:
Are Samba versions for MacOS comparable to unix versions? I have had Samba 1.9 without complaints from Access (97 that is)
You made that work? Multi-user? I was told that that pretty much didn't work, but 2.x worked well.
Ah, thanks both for your comments. I'll add them to the Corruptions FAQ Causes Samba page.
Well, sure, but given my level of certainty, you should probably file it as
"rumor" until you hear it from a more direct source.
Steve Jorgensen <no****@nospam.nospam> wrote: Well, sure, but given my level of certainty, you should probably file it as "rumor" until you hear it from a more direct source.
"There have been newsgroup comments indicating 1.9 and 2.x work. As always your
mileage may vary."
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: w |
last post by:
Hello all!!!
For a year and a half now, we have been developing different Access
2000 applications. Most of them are access frontend and access
backends. Some of them have SQL server 2000 as a...
|
by: matt bourke |
last post by:
Hi,
Can you please tell me what the advantage is of using an access backend with
a VB frontend OVER access as a frontend and backend.
M
|
by: Wayne Aprato |
last post by:
I have several Access 97 databases which are split into front end and
back end running off a server. The front end mde is shared by 2 or 3
- absolute maximum of 6 concurrent users. This scenario...
|
by: Bradley |
last post by:
Has anyone else noticed this problem? I converted the back-end to A2000
and the performance problem was fixed. We supply a 97 and 2000 version
of our software so we kept the backend in A97 to make...
|
by: DD |
last post by:
Hi
I have a split database, that is packaged and used in a runtime
enviroment.
I want to make it easier for the user, a button on the frontend
"Export Backend"
They can click on the button...
|
by: Sukkel |
last post by:
When I define relations in the Backend of my Database, everything works
fine. I get these funny lines (with 1 and "OO") between the fields of
the different table that indicate a one to many...
|
by: PC Datasheet |
last post by:
I have zero experience with using a SQL database for a backend and Access
for a frontend. I have some questions:
1. Does an SQL database have tables?
2. How does Access connect to the data in...
|
by: philelpko |
last post by:
Good Morning all,
Lost once again which is becoming a common occurance atm.
My database has successfully been broken into a frontend and a backend db. A problem has now arisen as it has become...
|
by: Kaustubha B S |
last post by:
hi! this is Kaustubha from BLR , INDIA
i had a doubt about Client/server technology
1) how does a backend-frontend tool in clientserver technology work
and what ...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |