No of visitors who read this post: 870
Category: MS Access
Type: Question
Author: Looner
Your rating: None Average: 5 (1 vote)

Hi all,

I can't explain this error a lot to you. But as far as I went to its bottom, I found that some table fields are missing. Though it's giving a table missing error, you can see next to it that it says table or no view found. It means that maybe the table exists, but table field are missing and that’s why the database is not able to view the table completely for proper results to be displayed.

I understand the database issues, but yet not able to sort them out.

If anyone of you can clear this error up, then please let me know. I have attached a screenshot of the error, so you can actually see what the error is given by the system database.

I think it might be easy for someone who is familiar with using MS Access and is able to link Access database to other databases.

Hope to hear from you soon.

Thanks.

Sybase Database

PowerDesigner – Error

[Sybase][ODBC Driver][.ODBC SQL Server Driver ]Table or view not found: Table ‘PMUSER’ not found

SQLSTATE = S0002

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Check MS Access power design option, otherwise Remove Microsoft Access by Removing Microsoft Office from add/remove programs on Control Panel. Then Reinstall MS Access. Use MS Access 2003 for good performance.

Hope this works out well.

Thanks.

Aiman

# (Solution Accepted)

Hi,

Try creating a table by same name 'PMUSER'. It can also happen if you didn’t install MS acess properly or some of the files u accidentally deleted so it is unable to find the right path .Uninstall MS Access and install it again.  Try out this. Hope ur  problem will be solved . Thanks