Sharing a database

[Guest]

I've allowed users to access my database and there has been a problem with
one of these users not being able to save after entering information into a
form. The error message says "Can't save design changes..." when the user
hasn't altered the design. The issue seemed to correct itself after a few
minutes. Could this have anything to do with multiple users accessing the
database at the same time?

 

[kingston via AccessMonster.com]

Have you split the application into a front end (user interface) and a back
end (shared data tables)? This is probably the solution to your problem.

 

[Guest]

I have split the database and this has prevented users from accessing the
form that I want them to use. How do I undo the split?

 

[John W. Vinson]

I have split the database and this has prevented users from accessing the
form that I want them to use. How do I undo the split?

Why not correct the error instead??

To undo the split:

- Back up both the frontend and backend databases
- Open the frontend and delete all the table links from the Tables window of
the database tab
- use File... Get External Data... Import to import all the tables.

Then share the database and put up with the bad performance, inability to edit
the design of any forms or reports, increased risk of corruption...

John W. Vinson [MVP]

 

[Guest]

I'm working toward that now. However, it's a bit scary when you don't really
understand what's going on. I've been studying diligently, however I'm still
having a problem understanding how to access my backend after the split. I'm
reading an article by Albert
Kallal(http://www.members.shaw.ca/AlbertKallal/articles/split/index.htm) and
also a thread started by Steve called Split databse questions? However, I'm
still very nervous. Thank you for your support and please bear with me.

Nicole

 

[John W. Vinson]

I'm working toward that now. However, it's a bit scary when you don't really
understand what's going on. I've been studying diligently, however I'm still
having a problem understanding how to access my backend after the split. I'm
reading an article by Albert

Good choice.

What specific problems are you having "accessing the backend"? You would only
need to *open* the backend database if you needed to make design changes to
the Tables (new fields, changing field names, etc.) - and such changes should
be infrequent in a properly-set up database.

If you're having problems with Forms or Reports, please post a description of
the problem. Split databases *DO* work and are perfectly routine; that's why
all of us recommend them.

John W. Vinson [MVP]

 

[Guest]

John,

I've split a database, copied the FE to another PC, and linked to the BE
tables all successfully. Thanks for your support, I'm sure I'll be back for
more soon.

Nicole