Can a split db FE user use the tables

[Guest]

Hi,
I am having issues with FE users using/adding data to the tables. When I
split the DB I brought over all tables, forms, queries and reports, but the
tables are saying they are read only - WHY?
Thanks!
Krista

 

[Guest]

Hi Krista,

When you split a DB, you usually have the tables in one file (the Back End),
and everything else in another file (the Front End), then you link your BE
files to the FE by opening the FE and selecting File->Get External Data->Link
Tables.

Is this what you have done?

Damian.

 

[John W. Vinson]

Hi,
I am having issues with FE users using/adding data to the tables. When I
split the DB I brought over all tables, forms, queries and reports, but the
tables are saying they are read only - WHY?
Thanks!
Krista

Presumably because you made some sort of error. Without more information it's
hard to guess what!

The frontend should have the Forms, Queries, Reports and code, and should have
links to the Tables; the backend should have only the tables. Can you open the
backend and edit the tables?

John W. Vinson [MVP]

 

[Guest]

I re-did the whole entire process leaving the forms, queries and reports on
the FE and the tables on the BE, but I am still the only one to access the
db. It gives a message "microsoft jet database engine cannot open the file
(followed by the drive
mapping)....." I have looked at my permissions and checked exclus and all
is okay. Any advice???????

Does anyone know of an person that is an access guru in connecticut? I am
having quite a bit of difficulty trying to get this database up and running.

 

[John W. Vinson]

I re-did the whole entire process leaving the forms, queries and reports on
the FE and the tables on the BE, but I am still the only one to access the
db. It gives a message "microsoft jet database engine cannot open the file
(followed by the drive
mapping)....." I have looked at my permissions and checked exclus and all
is okay. Any advice???????

You need Windows read, write, create and delete privileges in the backend
folder (or else some trickiness), in order for Access to be able to create and
delete the .ldb locking file. Just read/write is NOT enough.

Does anyone know of an person that is an access guru in connecticut? I am
having quite a bit of difficulty trying to get this database up and running.

Well, I'm a few thousand miles from there in Idaho... sorry!

John W. Vinson [MVP]

 

[punjab_tom]

I would reccomend finding someone that knows SQL Server instead of
Access.

Access MDB has been obsolete for 10 years.
Access Data Projects won the war


it's a much much simpler architecture; none of this front-end / back-
end crap.. all your tables / queries-- they live in ONE PLACE and you
can edit tables while people are using other tables without having a
problem

you can edit queries while people are using other queries without a
problem