There was a problem when using the financial software to close the bill, using the ACCESS database 2

If you are confident about modifying the foreign key, you can go to the access database and cancel the corresponding foreign key. You will be able to check out the bill smoothly.

However, it is recommended that you still look with a software company, there must be something wrong with the data, otherwise there will be no such prompt. (Could it be an earlier version of UF?) ）

It should be that there is another reference in the record you want to delete, and you must delete the other one first, and then delete this one.

You can pour it into Excel** to make it easier to deal with.

Pour it out as excel and print it yourself.

You have no one to explain to you, you have to tell what software you use.

Why doesn't your software have the ability to print subledgers?

We are UF's.

If you ask that, almost no one can help you solve this problem. Because, what you asked is too general, the reasons for the access database opening error are varied and innumerable, and I don't think your sticker is "database opening error".

Therefore, if you want to solve the problem, you must describe the problem clearly (paste **, and tell the location of the error, etc.), and even send the project directly to others, and ask people to help see the mistakes and correct them to successful operation.

The database switch panel form is broken, create a new database, and import the tables, queries, forms, reports, macros, and ** in this database.

It would be nice if you could send the sample file.

Create a federated query in Access, first query 22, then federated query 23, and then federated query 24.......

What is your statement for reading the data? Or is it directly bound to the table?

You need to check if there is a substitution function in access and replace it with empty.

。。。Reinstall Office and find one with access.

As for database and table creation, it is a graphical operation in Access. Very easy to get started.

Create an empty database first, and then create a table (you can use "Get External Data" under the file, you can follow the prompts in the table design object).

Open the Access program, create a new table, or you can import data from Excel.

What are the requirements for your database?

It is best to contact the database administrator.

A small commissary, a large department store.

The commissary sells few things, and the quality may not be guaranteed, but the price is cheap, easy to buy, and close to home.

The big department stores are full of goods and of high quality, but the price is also more expensive and far from home.

Small**, small program, ordinary stand-alone program, generally use access, easy to use, small file, strong portability, if you use SQL is not suitable, not calculated.

Large**, large programs, network programs generally use SQL, powerful, easy to manage, strong collaboration, when the data is larger, the performance is better than access, then it is not appropriate to use access, access can not be topped.

So it's up to you to choose.

In fact, this is not a big deal, at the beginning of the program is small, **small, you can use access first, and then it develops bigger, you can upgrade to SQL, there are conversion tools between them, it is very convenient, the program only needs to do a small amount of modifications. If you are using SQL and feel that it is a bit wasteful, you can also switch to access, and you can make small modifications.

More than 10 million, of course, too much. To use mysql