473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Frontend on Windows PC/backend on a Mac?

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

Nov 12 '05 #1
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

Nov 12 '05 #2
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.
Nov 12 '05 #3
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.
Nov 12 '05 #4
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

Nov 12 '05 #5
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.
Nov 12 '05 #6
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

Nov 12 '05 #7
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.

Nov 12 '05 #8
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
Nov 12 '05 #9
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.
Nov 12 '05 #10
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
Nov 12 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
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...
1
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
16
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...
22
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...
3
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...
2
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...
42
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...
9
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...
2
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 ...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
0
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.