Read/Write Issues After Copying An Access .mdb File

Jeigh

Jul 31 2006, 02:11 PM

Alright, I'm currently creating an interface program for a MS Access database. I've only used Access once in the past but used other DB's a handful of times so I didn't have any trouble getting the general program created. My issue arose when I tried to make it so that the users needing to use the program can just copy the .exe and the .mdb files and use it.

The program doesn't require users to share the database but to store their OWN programs information in their OWN database, so basically each needs to have their own database with the exact same design. The original plan was to just get them to copy over a near empty .mdb with the design set up and have them slowly create their own dataset with it. However, upon copying these files between my computer and others it ends up allowing my interface program to retrieve data from the DB but not write any new entries to it. All security permission on the file itself are set to allow read/write to everyone so I'm not sure what's causing this. Is there any other security settings I should worry about? Everything I could find within access seemed to be set so that it could be used freely so I'm not sure what the problem is. Any help would be greatly appreciated.

Comment/Reply (w/o sign-up)

faulty.lee

Nov 14 2006, 09:59 AM

Can you give more detail regaing the program you're writing, such as is it written in VB, .Net, C++ ..... etc

What method you use to access the database? ADO, ADO.NET, ODBC

Does this problem also appear on the development machine?

For you case i would recommend using ODBC, since newer windows machine has ODBC built in, even though personally i prefer direct accessing the database. Using ODBC can help isolate problem like file access, and can even work over shared folder. One thing though, you'll need to setup DSN (one time) on all the pc where the software need to run

All the best

QUOTE(Jeigh @ Jul 31 2006, 10:11 PM)

Alright, I'm currently creating an interface program for a MS Access database. I've only used Access once in the past but used other DB's a handful of times so I didn't have any trouble getting the general program created. My issue arose when I tried to make it so that the users needing to use the program can just copy the .exe and the .mdb files and use it.

The program doesn't require users to share the database but to store their OWN programs information in their OWN database, so basically each needs to have their own database with the exact same design. The original plan was to just get them to copy over a near empty .mdb with the design set up and have them slowly create their own dataset with it. However, upon copying these files between my computer and others it ends up allowing my interface program to retrieve data from the DB but not write any new entries to it. All security permission on the file itself are set to allow read/write to everyone so I'm not sure what's causing this. Is there any other security settings I should worry about? Everything I could find within access seemed to be set so that it could be used freely so I'm not sure what the problem is. Any help would be greatly appreciated.

Comment/Reply (w/o sign-up)

ignite

Nov 17 2006, 12:02 PM

QUOTE(Jeigh @ Jul 31 2006, 04:11 PM)

Alright, I'm currently creating an interface program for a MS Access database. I've only used Access once in the past but used other DB's a handful of times so I didn't have any trouble getting the general program created. My issue arose when I tried to make it so that the users needing to use the program can just copy the .exe and the .mdb files and use it.

The program doesn't require users to share the database but to store their OWN programs information in their OWN database, so basically each needs to have their own database with the exact same design. The original plan was to just get them to copy over a near empty .mdb with the design set up and have them slowly create their own dataset with it. However, upon copying these files between my computer and others it ends up allowing my interface program to retrieve data from the DB but not write any new entries to it. All security permission on the file itself are set to allow read/write to everyone so I'm not sure what's causing this. Is there any other security settings I should worry about? Everything I could find within access seemed to be set so that it could be used freely so I'm not sure what the problem is. Any help would be greatly appreciated.

The problem may be in versioning. Check DB engine's versions at user's machine.

Comment/Reply (w/o sign-up)

iGuest-mansiha

Sep 10 2008, 10:05 AM

backup of access database
Read/Write Issues After Copying An Access .mdb File

Hi! friends,
I m Manisha I m working on project using vb.Net and access, there is my big problem I tell you, I don't know the vb.Net but I just work on old project, my actual problem is that I want to create a backup file using vb.Net 2003 code,
Please give me the set of code that use to create a backup of access database,

My idea was that there is one command button for back up and I just click it and the back up of database created automaticaly using vb.Net code so please send me the set of code for this problem.

-reply by mansiha

Comment/Reply (w/o sign-up)

jelsa

Feb 26 2009, 03:40 AM

If It's about backing up your *.mdb, I have the code to back up your database into *.rar format (Winrar)

CommonDialog1.CancelError = True
CommonDialog1.ShowSave
Dim CopyString As String, path As String
path = Chr(34) & CommonDialog1.FileName & Chr(34)
DestFile = Chr(34) & "D:\DATA\data.mdb" & Chr(34) 'The path of your data
CopyString = "c:\program files\winrar\winrar.exe a " + path + " " + DestFile
Dim RetVal
RetVal = Shell(CopyString, 1)

Comment/Reply (w/o sign-up)