Microsoft Access?

Question

Microsoft Access?

How's everyone doing? There is this inventory database that was set up at my job. This database has alot of problems, but are fixable. However, this one problem is the one that cuts the cake, there is this button that tells you create an excel report based on the input we put on the database. In other words, it extracts information from this database to excel. Once the button is clicked, it tells you that the output will be on the root directory file which in my case is the c:drive. When I look at the C:DRIVE, there's no excel files to be found. I don't know if the reports are even produced? When can I do? I forgot to mention, this same database is also in another old computer and it exports the files to the c:drive, but in our new computer, it doesn't.

Thank you everyone for your help. I really appreciated.

Answer 1

Hey there

I've used this programme a bit in my last job :-)

"However, this one problem is the one that cuts the cake, there is this button that tells you create an excel report based on the input we put on the database. In other words, it extracts information from this database to excel"

When you have created the table you need to go to Tools - Office links - Analyze with Excel ... then in Excel file it as a workbook in the directory you want ... I would suggest doing a dummy one to the desktop :-)

I've also given you a helpful tutorial link :-)

Answer 2

It's really hard to tell without actually looking at the database and the system it's on. The control is going to do exactly what it's told to do, but it's hard to guess what it was told to do. The fact that the same database on an old system works, but doesn't on the new one, makes me consider that the control is pointing to a drive/folder/file that no longer exists on that system. If you had a mapped network drive previously, and the control was set to that drive, this could occur. Or perhaps the "root" directory isn't on C? Some vendors put a seperate volume on the hard drive to host recovery files or the OS. Your database could be reading that as the "root", when it isn't.
The first thing I would do is a search of the entire computer for files with the .xls extension. Include system/hidden folders to be sure you search everything. See if it's creating the files somewhere odd.
The control may also be looking for a specific exel file to export to, which doesn't exist. Try creating an excel file in the root directory that is named the same as the good file on the old system (or copy and paste the good file), then see if the export works.
Or, you could just export the data manually.
Or, you could send me the form via e-mail (without the data, if you wish) and I could physically take a look.

Answer 3

OK this is a tough one although i build databases. you didn't say if your new PC is a workstation or a stand alone system. excel has different versions and different commands from a relational database(Microsoft's and borlands are relational) i suspect that the version of excel is different in you new machine. the commands from access to excel will be different. with all the problems you talk about it seems you need your database re-designed with a working relationship first. fixing part of a database is disaster at best. relationships have to be balanced with structural index's. get help.