How to produce accdr files from accdb version (1 Viewer)

[Ajit Singh]

Hello

I have a database (accdb) out of which I want to generate accdr files of which user can only access / view the reports section ONLY. Can anybody help with a VB code which will generate employee wise (or any criteria) accdr files?????

 

[Rx_]

On this site: http://www.access-programmers.co.uk/forums/showthread.php?t=242975
Visual:
http://www.setha.info/ict-msaccess/90-ict-msaccess-0006.html
http://www.access-programmers.co.uk/forums/showthread.php?t=225356


I have never done it or needed it. Just looked it up for the first time.
You asked how to accomplish this with Code:

Just a guess, it might be something like this?
Dim app As New Access.Application ' often C:\Test folder may need to be given permissions
Const conDB_TO_CONVERT As String = "C:\Test\Test.accdb"
Const conCONVERTED_DB As String = "C:\Test\Test.accde"
app.AutomationSecurity = msoAutomationSecurityLow
app.SysCmd 603, conDB_TO_CONVERT, conCONVERTED_DB

Ah, found this from some valued members - look into this:
http://www.access-programmers.co.uk/forums/showthread.php?t=201640
http://www.access-programmers.co.uk/forums/showthread.php?t=163880

Suggest you learn how to use this site's search tool. There are another half dozen related articles.
If it works for you, please share your results with the rest of us, be sure to add your version of Windows and MS Access.

 

[Ajit Singh]

Thanks much for the instant help!!!!!!

I will look into the threads and will share once I get anything useful.