Some problems with access

[Andrew Diakin]

Hello all! I have a database in access with some forms, reports, macroses,
can I now make such thing:
store all data from tables in mssql and use Access to work with them. I
try to create Access projects and then or it import data from mssql and I
can't edit/add data or it links data with tables and all tables name
converts from TableName to localhost_TableName and I still can only read
data.
All forms/reports/etc I import from exiting db. What I must to do to make
such thing as I want?

 

[Guest]

Use the 'upsizing wizard'

-Dorian

 

[Andrew Diakin]

Hmm... I already try... It doesn't work. I run Upsizing Wizard, it create
new database, connect to server, I select all tables and then select
'create new Access project'
All goes ok except after this I cannot edit data, the error is that I
can't go to selected field when I want add data, but using Query Analyzer
I can write INSERT INTO dbo.Students VALUES(...) and it work