What is '¦' object?

[zhongwei]

When I'm trying to import data from access database, the message tell me :"don't have permission for '|' object",does any know what the '|' object is? pls advise, thank you for your help.

 

[gormcd]

It is commonly referred to as a "Pipe" it is used in many programming languages.

In UNIX, you can concatenate commands using the Pipe.

It can also separate fields in other data. Most of our raw data comes to us using the Pipe as a field separator.

gormcd

 

[RickSpr]

The "|" (vertical bar or pipe) character is used in Access error messages as a place holder for a variable part of the message. It was supposed to have been replaced with the name of a real object before the message was displayed, but for some reason in your case it wasn't replaced.

However, the error message is telling you that the database you're importing from is secured, and you don't have permission (with the logon you're using, if you're using one) to read the design and/or the data of that object. The object could be a table, query, form, report, macro, or module.

If you really do have permission when using the source database directly, the problem is that you have to be logged on the same way in order to import from it. Do you also log on when opening the database you want to import into? If yes, do you log on the same way?

Avoiding this problem could involve some delicate and complex steps. It might be wise to ask the administrator of your source database for assistance. Rick Sprague