I have made an Access program and now I have made usergroups with 

different rights. I believe next step would be to make an .exe-file of my 

program but I have no idea how to do it. I'm allready confused with the 

files Access made when making those usergroups and everything. I used the 

wizard to do that.

Situation is that I have 5 files which has something to do with the 

solution:

Mikrotukikäynnit   2968KB  MS Access application

Mikrotukikäynnit.mdb  1KB  Shortcut

Mikrotukikäynnit     13KB  Snapshot file

Suojattu ('Protected' in English) 1KB  Access.LockFile.9

Suojattu                          180KB   The workgroup data of MS Access



Now the application opens ONLY by doubleclicking the shortcut. If I try to 

open any other file of those 5 access says that I don't have the 

nessessary rights to open it and I should get in touch with the 

administrator, which I am. If I open Access and then try to open any of 

those five files, it doesn't do that.

When I check the properties of the shortcut, it says the target is the 

workgroup data -file.



I'm also wondering why the original file (before I gave userrights) was 

14320KB and the new ones the access mabe are so much smaller.



Now I should be able to download this application into the servers of our 

clients and don't know how I should do it. If I had one .exe file it would 

probaply make things more simple but this is the first time I have gone so 

far with Access. At school we just made simple databases and forms, never 

thought about user rights or .exe-files.



If you could give me some advice, I would realy preciate it,

Sanna

It is not possible to convert an Access database to an .exe file--the

various files Access can produce must be run by the Access

executable--MSAccess.exe.  If you can count on all your users having the

right version of Access already installed on their computers, then you can

just distribute the files you've listed below (you may want to also include

a script or batch file that does an automated install).



If you have the developer version of Office, then you have the legal right

to distribute a run-time version of Access, and you have the Package &

Deployment wizard, which will let you create an automated install routine

for the run-time and your app files.



HTH,



-Roy



-----Original Message-----

From: Sanna Korpela [mailto:sanna.m.korpela@l...]

Sent: Monday, August 27, 2001 3:01 AM

To: Access

Subject: [access] Making .exe-file of .mdb





I have made an Access program and now I have made usergroups with 

different rights. I believe next step would be to make an .exe-file of my 

program but I have no idea how to do it. I'm allready confused with the 

files Access made when making those usergroups and everything. I used the 

wizard to do that.

Situation is that I have 5 files which has something to do with the 

solution:

Mikrotukikaynnit   2968KB  MS Access application

Mikrotukikaynnit.mdb  1KB  Shortcut

Mikrotukikaynnit     13KB  Snapshot file

Suojattu ('Protected' in English) 1KB  Access.LockFile.9

Suojattu                          180KB   The workgroup data of MS Access



Now the application opens ONLY by doubleclicking the shortcut. If I try to 

open any other file of those 5 access says that I don't have the 

nessessary rights to open it and I should get in touch with the 

administrator, which I am. If I open Access and then try to open any of 

those five files, it doesn't do that.

When I check the properties of the shortcut, it says the target is the 

workgroup data -file.



I'm also wondering why the original file (before I gave userrights) was 

14320KB and the new ones the access mabe are so much smaller.



Now I should be able to download this application into the servers of our 

clients and don't know how I should do it. If I had one .exe file it would 

probaply make things more simple but this is the first time I have gone so 

far with Access. At school we just made simple databases and forms, never 

thought about user rights or .exe-files.



If you could give me some advice, I would realy preciate it,

Sanna

Hi Sanna,



You could make MDE file (as close as you can get to exe file in Access).

To create MDE, chose Database Utilities, Make MDE file... and follow

directions.



PS: Make sure to save a copy of your original database so you can edit it

when you need it, MDE files cannot be edited.  Check MDE in Access Help

before you try to convert the database.



JohnF





>>> roy.e.pardee@l... 28/08/2001 2:22:26 >>>

It is not possible to convert an Access database to an .exe file--the

various files Access can produce must be run by the Access

executable--MSAccess.exe.  If you can count on all your users having the

right version of Access already installed on their computers, then you can

just distribute the files you've listed below (you may want to also include

a script or batch file that does an automated install).



If you have the developer version of Office, then you have the legal right

to distribute a run-time version of Access, and you have the Package &

Deployment wizard, which will let you create an automated install routine

for the run-time and your app files.



HTH,



-Roy



-----Original Message-----

From: Sanna Korpela [mailto:sanna.m.korpela@l...]

Sent: Monday, August 27, 2001 3:01 AM

To: Access

Subject: [access] Making .exe-file of .mdb





I have made an Access program and now I have made usergroups with

different rights. I believe next step would be to make an .exe-file of my

program but I have no idea how to do it. I'm allready confused with the

files Access made when making those usergroups and everything. I used the

wizard to do that.

Situation is that I have 5 files which has something to do with the 

solution:

Mikrotukikaynnit   2968KB  MS Access application

Mikrotukikaynnit.mdb  1KB  Shortcut

Mikrotukikaynnit     13KB  Snapshot file

Suojattu ('Protected' in English) 1KB  Access.LockFile.9

Suojattu                          180KB   The workgroup data of MS Access



Now the application opens ONLY by doubleclicking the shortcut. If I try to

open any other file of those 5 access says that I don't have the

nessessary rights to open it and I should get in touch with the

administrator, which I am. If I open Access and then try to open any of

those five files, it doesn't do that.

When I check the properties of the shortcut, it says the target is the

workgroup data -file.



I'm also wondering why the original file (before I gave userrights) was

14320KB and the new ones the access mabe are so much smaller.



Now I should be able to download this application into the servers of our

clients and don't know how I should do it. If I had one .exe file it would

probaply make things more simple but this is the first time I have gone so

far with Access. At school we just made simple databases and forms, never

thought about user rights or .exe-files.



If you could give me some advice, I would realy preciate it,

Sanna

Hi Sanna,



May I suggest you always post the version of Access you are using?



The snapshot file is probably the details of your security. You would not

want to distribute that. Surely the first file on your list has an extention

of .mdb?



It sounds like the security is working exactly like it is supposed to. Do

you want the database secure or not? If so, you need to distribute the

workgroup file with it and use it to open the database.



The reason it is smaller might be because the process did a compact and

repair on the database. Actually I seem to remember that the security Wizard

creates a new database, so if you have not compacted the original for some

time, that would be the reason it is smaller.



You cannot make an exe from an access database. The best you can do is is

get the Office Developer Edition (I think the name is changed in A2K) and

make an installable, run-time version. This could include an mde instead of

mdb, file. With Office 2000, it will check if Access is installed on the

local machine and if so just install the database. If not, it will install

necessary run-time files. BTW, the run-time package is very large. I think a

minimum of 60 MB or perhaps it was even more.



You mention servers. If you want a split front end/back end database, which

is definitely the way to go if you have multiple users on a server based

system, then there will be additional difficulties. I'm not sure on this -

perhaps someone else can help out, but I don't think the run-time package

will support that without modifications.



Peter







> -----Original Message-----

> From: Sanna Korpela [mailto:sanna.m.korpela@l...]

> Sent: August 27, 2001 10:01 AM

> To: Access

> Subject: [access] Making .exe-file of .mdb

>

>

> I have made an Access program and now I have made usergroups with

> different rights. I believe next step would be to make an .exe-file of my

> program but I have no idea how to do it. I'm allready confused with the

> files Access made when making those usergroups and everything. I used the

> wizard to do that.

> Situation is that I have 5 files which has something to do with the

> solution:

> Mikrotukikäynnit   2968KB  MS Access application

> Mikrotukikäynnit.mdb  1KB  Shortcut

> Mikrotukikäynnit     13KB  Snapshot file

> Suojattu ('Protected' in English) 1KB  Access.LockFile.9

> Suojattu                          180KB   The workgroup data of MS Access

>

> Now the application opens ONLY by doubleclicking the shortcut. If

> I try to

> open any other file of those 5 access says that I don't have the

> nessessary rights to open it and I should get in touch with the

> administrator, which I am. If I open Access and then try to open any of

> those five files, it doesn't do that.

> When I check the properties of the shortcut, it says the target is the

> workgroup data -file.

>

> I'm also wondering why the original file (before I gave userrights) was

> 14320KB and the new ones the access mabe are so much smaller.

>

> Now I should be able to download this application into the servers of our

> clients and don't know how I should do it. If I had one .exe file

> it would

> probaply make things more simple but this is the first time I

> have gone so

> far with Access. At school we just made simple databases and forms, never

> thought about user rights or .exe-files.

>

> If you could give me some advice, I would realy preciate it,

> Sanna

Hi everyone,



I think if Sanna has Office Developer's Edition (ODE), then it's entirely 

possible for her to make an .EXE out of the Access program.  



Granted, it's probably going to be a bit of a hassle since Security is 

involved, but I heard that ODE offers this option.  I need to double-check 

on that --which I can do, since it's on my desktop.  (I just bought it for 

the API viewer and haven't touched it since!)



I'm beginning to become convinced, however, that the best, easiest way to 

enforce security on an Access database,  is to develop it using ASP, and 

let it sit on the web server....



Susan

Hi again,



Please disregard my previous message.  After reading more of Peter 

Kaufman's message, I see he addressed the ODE option.  And he's correct, 

too, I think -- I don't think it applies for this particular scenario.



Sorry about that!  I'm bummed to find out that ODE doesn't turn Access 

into an actual .exe, but it's good to know about those runtime versions.



What does it do about multiple versions of Access, does anyone know?



Susan