The Challenges of ACCESS Database Sharing 50

This doesn't work, one way is to write a program on your computer to read the database, and then let your friends use this program to call the data, and ours does just that.

You don't have to argue, the flower swallow means that the two of you are **different on the same server**. So it's wrong, and the following doesn't understand that it's on a different server, so there's no way to access it directly.

I may not have made it clear: I don't mean automatic synchronous updates, but synchronous display (just the foreground page display). Updates can only be done asynchronously.

Asynchronous is also that strategy, write a data access program in your local area to read your local database, of course, how to operate after reading, just display, or update the database on his side, it is up to his program to decide. I also think that other methods are too difficult to use ASP to achieve remote automatic updates, and it is too cumbersome to notify the remote execution operation. If the data is more secret, you have to write an IP access restriction program.

in the adoption of passwords.

There's a friend who wants to set up the same ** on "other servers".

Did you guys see it clearly upstairs?

If it can also be accessed by network path in the local area network, otherwise access alone cannot be achieved, and it can be achieved by changing the database or using webservices.

Supplement: WebServices is neither a component nor a software, but a technical specification, the use of SOAP protocol can achieve a real sense of network data sharing, is the future network data exchange standard, it is recommended that you study hard.

Just let the other ** database connection point to your mdb.

Find the absolute path to your mdb first

For example:"c:/inetpub/database/" ..

Then your friend can use this path to access your database...

Huayi Yanzi is very good, and he doesn't understand and scolds, he really has no quality.

, and ask questions.

You are an airplane, you don't have that kind of technology, and you still need this requirement.

To access a remote database, you need to use an oracle database, which is its feature.

It is also possible to use one MSSQL for each side with the data synchronization function.

asp I don't know, you can't specify the remote database, otherwise there will definitely be an error!

If ASP can specify other databases in the LAN, then try to establish a VPN connection and then specify the database, I don't know if it works.

1.The premise is that each user cannot open it in an exclusive way.

2.Shared Database (MDB) Note The information in this topic applies only to Microsoft Access databases (.).mdb)。

3.To access a shared Microsoft Access database from another computer, one of the following must be present on the other computer: a local installation of Access, a network installation of Access (licensed on a per-user basis), or a runtime application.

4.Set up a shared folder.

5.For more information about shared folders, use the Microsoft Windows Help Index.

6.If the shared folder is on a network server, you may need the assistance of your network administrator.

7.Copy the Microsoft Access database to a shared folder. Make sure that the Access database is set to open in shared mode, which is the default.

How it works: On the Tools menu, click Options.

8.On the Advanced tab, under Default Open Mode, click Share.

9.Note: Before sharing a database, you should delete any personal information that may have been stored in the file.

Note The information in this topic applies only to Microsoft Access databasesmdb)。

10.Methods for sharing data There are several ways to share data in a multi-user environment.

11.Share the entire Access database You can place the entire Access database on a web server or in a shared folder.

This is the easiest way to implement the entire Access database share.

12.Each user can share data and use the same forms, reports, queries, macros, and modules.

13.You can use this strategy if you want everyone to use the Access database in the same way, or if you can't support other users to create their own objects.

14.Share only the tables in the Access database You can place the tables only on the network server and leave all other database objects on the user's computer. In this case, the performance of the Access database is improved because only the data is sent over the network.

When splitting a database into a backend (tables) and a frontend, users can customize the forms, reports, and other objects in their own front-end database without affecting others. Sharing an Access Database Object or Data Access Page on the Internet You can create one or more databases or create a data access page that outputs the object as static HTML or server-generated HTML format.

You can use Excel as the client and ADO to access the Access database. There is another benefit to this design. Each user does not need to install access

Set the e-mail address in the record to be displayed in lowercase, and if the record is empty, the word nomail will be displayed.

It can be set up like this:

1) Open the table design view;

2) Select the [Email] field and set the data type of the field to "Text";

3) Select the "Format" attribute bar of the field and fill in the custom format: <; nomail"

4) Save the settings.

Drawings for reference:

Since it is to check which cabinet the book is in, then your main watch should be the cabinet and the secondary table is the book, which can be regarded as a way of thinking......

Create an index for the location number of the cabinet.

There is a special column in the library table to record the location of the cabinet

In a relation, connect the primary key column of the cabinet with the column of the cabinet in the book, and set it as a full cascade reference and update it at any time.

Then enter the cabinet table, and the corresponding relationship data will appear:

Here's what the form looks like:

I don't know if it's what you're hoping to achieve.

When adding entries, as long as the corresponding storage location is correctly selected, it will be recorded in the corresponding table:

There is a field "cabinet number" in the [record], as long as *query* to the [record] that meets the "book number" condition, isn't the "cabinet number" there?

Judging by your mistake, there is duplicate data on the field you want to manipulate. Workaround:

1. If your database allows your existing data to have duplicate data, you can create a primary key or constraint in the visual interface, and there is an option to ask whether to detect the existing data in that step, and you can check it.

2. If your database does not allow your existing data to have duplicate data, which is more troublesome, you can add constraints on other columns, or you can use multiple columns to establish constraints.