Question Upgrading from 2003 to 2010

[@stan]

After opening my base in 2010 I no longer can print reports, access keeps printing whatever report or information is highlighted in the navigation panel. What should I do or what can I do to make access 2010 operate with a database build in access 2003 ?
I have simply opened it in 2010, I have imported it into 2010 I have opened it and saved it as a 2007. Clearly I am missing something. My boss wants this in 2010… now.
:banghead:

 

[CJ_London]

If you have upgraded from 2003 the chances are you need to set the security access to enable the system. I've attached a short document to explain

Once enabled I would also compact the database and compile the code to make sure everything works OK.

It is also possible that in your upgrade you have moved from 32bit to 64bit in which case you will need to modify any API calls you have by adding PtrSafe as shown below

'APIs
Declare PtrSafe Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpbuffer As String, nsize As Long) As Long

 

[CJ_London]

sorry, forgot the attachment!

 

[James Dudden]

I have seen this problem crop up a few times and believe it's a bug in Access 2010. Take a look at this for a possible fix:

http://www.access-programmers.co.uk/forums/showthread.php?t=223383

 

[@stan]

Thank you, did it, still not printing reports.

 

[James Dudden]

Have you tried sending the report straight to print without a preview?

 

[@stan]

While I am able to send a report directly to the printer, I am in need of having the operator be able to preview the report first.

 

[James Dudden]

You could bypass the report and printing functions by exporting the report to pdf. Not really a fix but it may get round your problem until someone comes up with something better or Microsoft creates a patch.

 

[@stan]

Looks more and more like I'm looking at a rebuild.