Access Projects

B

Bruce

I have developed a form for data entry in an Access Project. It works fine on my laptop in a development environment (local SQL server) but when I connect it to the actual remote server it connects, but the tables can not be edited, records can not be entered, etc. Any suggestions?
 
J

Jon

Check the securty privileges on the SQL server for the db .That's the first
place to look.

Jon

Bruce said:
I have developed a form for data entry in an Access Project. It works
Click to expand...
fine on my laptop in a development environment (local SQL server) but when I
connect it to the actual remote server it connects, but the tables can not
be edited, records can not be entered, etc. Any suggestions?
 
B

Bruce

Jon said:
Check the securty privileges on the SQL server for the db .That's the first
place to look.

Jon


fine on my laptop in a development environment (local SQL server) but when I
connect it to the actual remote server it connects, but the tables can not
be edited, records can not be entered, etc. Any suggestions?


Thanks. I did check this, and all seems to be in order. It gets stranger, however. Another form linked to a different table in the same SQL database works fine. If a blank (no records) table is created in the database with Enterprise Manager, the form does not even display its controls until at least one record is added (via Enterprise Manager, not the Access project). For the record, this is Access 2000 and SQL Server 2000.
Click to expand...
 
A

Arvin Meyer

Hi Bruce,

If you can connect to the server, it is undoubtedly a security permissions
issue. Try this:

1. Using Enterprise Manager, create a table on the server itself.
2. Connect to the table from your Access project.
3. I'll bet you can edit it, either directly or from a form.

Assuming you can, use tthe Enterprise manager to reset the permissions on
your tables.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

stranger, however. Another form linked to a different table in the same SQL
database works fine. If a blank (no records) table is created in the
database with Enterprise Manager, the form does not even display its
controls until at least one record is added (via Enterprise Manager, not the
Access project). For the record, this is Access 2000 and SQL Server 2000.
 
Top