G
Guest
I have another computer in another office connected via wirless router. How
can they, on the other computer, get access to my database?
can they, on the other computer, get access to my database?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Do they have access to the drive where the database lives? If so, they can
simply open the file.
Using this wireless connection could cause you to experience more frequent
corruption. If the connection is not very clean and stable, you may run
into issues.
simply open the file.
Using this wireless connection could cause you to experience more frequent
corruption. If the connection is not very clean and stable, you may run
into issues.
G
Guest
I don't really know. We get the same Emails, but I went to the other
computer and can't find the database I'm looking for.
--
Rich D
Armstrong Custom Homes
Redmond
computer and can't find the database I'm looking for.
--
Rich D
Armstrong Custom Homes
Redmond
Rick B said:Do they have access to the drive where the database lives? If so, they can
simply open the file.
Using this wireless connection could cause you to experience more frequent
corruption. If the connection is not very clean and stable, you may run
into issues.
R
Rick B
Well, we can't see your LAN. If you have a question about building a
database, we can help.
Not sure what sharing emails has to do with it. I can check my email from
just about any place in the World, but I can't get to a file on my computer
at home. If he is connected to your LAN and can browse the drives there,
then he should be able to open the file (assuming he has access to the drive
where that file lives).
--
Rick B
database, we can help.
Not sure what sharing emails has to do with it. I can check my email from
just about any place in the World, but I can't get to a file on my computer
at home. If he is connected to your LAN and can browse the drives there,
then he should be able to open the file (assuming he has access to the drive
where that file lives).
--
Rick B
Rich D said:I don't really know. We get the same Emails, but I went to the other
computer and can't find the database I'm looking for.
D
dbahooker
if you use a wireless network; then you can't use MDB format.
end of story.
use Access Data Projects.
MDB is prone to data corruption; and MDB is for babies anyways.
-Aaron
end of story.
use Access Data Projects.
MDB is prone to data corruption; and MDB is for babies anyways.
-Aaron
G
Guest
if you are using wireless network you can all use the windows remote
connection which you will the full access to the pc on the other network.
data integrity is not a big problem because access uses data locking records
which stored the data so once you accidentally disconnected you can always re
open the database and the data encoded will always be in the data locking
record file.
connection which you will the full access to the pc on the other network.
data integrity is not a big problem because access uses data locking records
which stored the data so once you accidentally disconnected you can always re
open the database and the data encoded will always be in the data locking
record file.
D
dbahooker
yeah. but in practical terms-- don't do it-- it is too risky.
if you care enough about your data to build a database; grow some balls
and use SQL Server. Access Data Projects are _QUITE_ similiar to MDB
and they allow you to re-use a lot of your forms and reports from your
MDB.
mdb vs sql server?
views and sprocs slaughter mdb queries; for starters; you can stack
view on top of view on top of view in SQL Server; and it works.
in MDB if you stack query on top of query on top of query?
you're stuck with flakiness; random crapouts.
with MDB you frequently have to use temp tables-- because MDB is flaky
and it can't munge 9 queries stacked on top of each other.
SQL Server? it doesn't have practical limits like this.
you don't have to link; create DSNs; or anything.
a single connection to a single server; linking between databases in
SQL Server is _EASIER_ than linking tables in MDB.. because you just
have to use the database.owner (aka schema in 2005).object
nomenclature.
aka
northwind.dbo.Orders for example.
if you're in the northwind database; and you want to pull information
out of the foodmart database you can just refer to it with a 3-part
naming convention.
if you're really serious you can link servers in one place.. and use
Server.Northwind.dbo.Orders
-Aaron
-Aaron
if you care enough about your data to build a database; grow some balls
and use SQL Server. Access Data Projects are _QUITE_ similiar to MDB
and they allow you to re-use a lot of your forms and reports from your
MDB.
mdb vs sql server?
views and sprocs slaughter mdb queries; for starters; you can stack
view on top of view on top of view in SQL Server; and it works.
in MDB if you stack query on top of query on top of query?
you're stuck with flakiness; random crapouts.
with MDB you frequently have to use temp tables-- because MDB is flaky
and it can't munge 9 queries stacked on top of each other.
SQL Server? it doesn't have practical limits like this.
you don't have to link; create DSNs; or anything.
a single connection to a single server; linking between databases in
SQL Server is _EASIER_ than linking tables in MDB.. because you just
have to use the database.owner (aka schema in 2005).object
nomenclature.
aka
northwind.dbo.Orders for example.
if you're in the northwind database; and you want to pull information
out of the foodmart database you can just refer to it with a 3-part
naming convention.
if you're really serious you can link servers in one place.. and use
Server.Northwind.dbo.Orders
-Aaron
-Aaron
D
Douglas J. Steele
However, be aware that the risk of database corruption is significantly
higher with wireless. In fact, I really wouldn't advise it.
higher with wireless. In fact, I really wouldn't advise it.
T
Tony Toews
jetro=) said:if you are using wireless network you can all use the windows remote
connection which you will the full access to the pc on the other network.
data integrity is not a big problem because access uses data locking records
which stored the data so once you accidentally disconnected you can always re
open the database and the data encoded will always be in the data locking
record file.
I respectfully disagree. Wireless connections have been reported as a
cause of corruptions.
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
D
dbahooker
in other words
USE ACCESS DATA PROJECTS and keep your data in sql server
USE ACCESS DATA PROJECTS and keep your data in sql server
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.