Some problems with access

  • Thread starter Thread starter Andrew Diakin
  • Start date Start date
A

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?
 
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
 
Back
Top